|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
|
|||
|
|||
|
MySQL 5 - Error creating table
I created a table in phpMyAdmin EXACTLY the same way as a currently working table except used different names for the table headers
"Error SQL query: CREATE TABLE `Items` ( `SKUID` INT( 10 ) NOT NULL , `Name` VARCHAR( 16 ) NOT NULL , `Price` DOUBLE( 5 ) NOT NULL , `Picture` VARCHAR( 10 ) NOT NULL , `Description` LONGTEXT NOT NULL ) ENGINE = innodb MySQL said: Documentation #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 ') NOT NULL, `Picture` VARCHAR(10) NOT NULL, `Description` LONGTEXT NOT NULL) ENG' at line 1 " |
|
#2
|
|||
|
|||
|
The DOUBLE type requires two parameters, one for length and one for decimals, like: DOUBLE(5,2)
|
|
#3
|
|||
|
|||
|
thank you very much
![]() |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > MySQL 5 - Error creating table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|
|