Not Solved Default Value - mybb_mysubs
#1
Not Solved
1364 - Field 'order' doesn't have a default value

I tried doing this command - 

alter table mybb_mysubs alter order set default 0;
Result: 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order set default 0' at line 1
Reply
#2
Not Solved
I recommend you google SQL Queries before trying to run them.

'order' is a reserved keyword, and therefore is not interpreted as a 'column' like how you see it.

You would have to enclose it in single brackets or like this order, as such, it would look similar to:
ALTER TABLE mybb_mysubs ALTER `order` SET DEFAULT 0;
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)