solidcodes — 2013-04-29T10:31:01-04:00 — #1
I tried to run this sql statement below,
ALTER TABLE about ADD content MEDIUMTEXT(65,000);
under PHPMyAdmin, but it show some error message.
And the message was this,
#1064 - 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 '(65,000)' at line 1
So what I have done wrong here?
Thank you very much in advanced.
davemaxwell — 2013-04-29T10:37:11-04:00 — #2
Shouldn't it be
ALTER TABLE about ADD COLUMN content MEDIUMTEXT
guido2004 — 2013-04-29T10:41:32-04:00 — #3
Don't specify the length you want for the column:
ALTER TABLE about ADD content MEDIUMTEXT;
Edit: Dave beat me to it
solidcodes — 2013-04-29T11:09:31-04:00 — #4