What's up with MySQL ??
Posted: 24. November 2003 21:06
I got xampp running fine. When I try to create a new table in the "test" database, via PHPMyAdmin I get the following error message. (I cut and pasted.)
Error
SQL-query :
CREATE TABLE `sales` (
`BLOCK` TEXT( 9 ) NOT NULL ,
`LOT` TEXT( 9 ) NOT NULL ,
`QUAL` TEXT( 11 ) NOT NULL ,
`ADDRESS` TEXT( 25 ) NOT NULL
) COMMENT = 'SALES RECORDS'
MySQL said:
#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 '(9) NOT NULL, `LOT` TEXT(9) NOT NULL, `QUAL` TEXT(11) NOT NULL,
What to do??
Error
SQL-query :
CREATE TABLE `sales` (
`BLOCK` TEXT( 9 ) NOT NULL ,
`LOT` TEXT( 9 ) NOT NULL ,
`QUAL` TEXT( 11 ) NOT NULL ,
`ADDRESS` TEXT( 25 ) NOT NULL
) COMMENT = 'SALES RECORDS'
MySQL said:
#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 '(9) NOT NULL, `LOT` TEXT(9) NOT NULL, `QUAL` TEXT(11) NOT NULL,
What to do??