What's the error in my MySQL statement?
Posted
by
Jim
on Stack Overflow
See other posts from Stack Overflow
or by Jim
Published on 2011-01-14T07:41:44Z
Indexed on
2011/01/14
7:53 UTC
Read the original article
Hit count: 154
mysql
The following SQL statement has a syntax error according to phpMyAdmin, but I can't spot what it is. Any ideas?
CREATE TABLE allocations(
`student_uid` INT unsigned NOT NULL DEFAULT 0,
`active` INT unsigned NOT NULL DEFAULT 1,
`name` VARCHAR( 255 ) NOT NULL DEFAULT '',
`internal_id` VARCHAR( 255 ) DEFAULT '',
`tutor_uid` INT NOT NULL DEFAULT 0,
`allocater_uid` INT unsigned NOT NULL DEFAULT 0,
`time_created` INT NOT NULL DEFAULT 0,
`remote_time` FLOAT NOT NULL DEFAULT 0,
`next_lesson` VARCHAR NOT NULL DEFAULT -1,
PRIMARY KEY ( student_uid )
);
© Stack Overflow or respective owner