w8ph w8ph - 1 year ago 68
SQL Question

Error in SQL syntax, even tho. everything seems to be normal

I have been trying to figure out whats wrong for quite long time yet I fail.

The error I get is

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 'UNSIGNED CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT NULL, `Date' at line 1

I cant seem to figure out whats wrong and this error seems to be quite common. Im not experienced with mysql, nor php for that matter.

Here is a screenshot, this is everything I enter:

enter image description here

Im unable to post pictures as my reputation is below 10, so please just check the link.

Update #1:

enter image description here

(I have also tried picking nothing typing null, picking null typing nothing and these with that tickbox on and off)

Answer Source

That UI is nuts... Remove the 'unsigned' option for the 'text' column.

-- Update --

If you were to create the same table manually:

create table `Win` (
    `No` int(4) unsigned auto_increment collate utf8_unicode_ci,
    `Text` text(1000) null default null collate utf8_unicode_ci,
    `Date` timestamp default on update current_timestamp collate utf8_unicode_ci,
    primary key(`No`)
) engine=InnoDB default charset=utf8 collate utf8_unicode_ci;

Take a look at phpMyAdmin, I haven't used it in years, but when I did it was a great GUI tool for administering MySQL schemas. You may also want to look at MySQL Workbench.