phpMyAdmin gives SQL syntax error when I try to create table.
Applies to: Grid System
If you are getting errors when you try to create a table like:
CREATE TABLE ´foo´ (
´bar´ VARCHAR NOT NULL
and get a MySQL error:
You have an error in your SQL syntax near 'NOT NULL)' at line 1
Then this probably means that you have forgotten to specify a length for the Varchar type in the "Length/Values" column, which is a required field.
So, this is wrong:
CREATE TABLE bla (bla VARCHAR NOT NULL);
and this is correct:
CREATE TABLE bla (bla VARCHAR(25) NOT NULL);
21711/0%Last update: 2010-10-03 16:27
Author: FAQ Admin
You can comment this FAQ