What's up with MySQL ??

Problems with the Windows version of XAMPP, questions, comments, and anything related.

What's up with MySQL ??

Postby Killer » 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??
Killer
 

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 122 guests