phpmyadmin / MySQL error message - help please
Posted: Wed Nov 19, 2008 6:13 am
Hi All
I get the error msg below when using the create table 'wizard' in phpmyadmin. The script it generates and the error are below. Any help would be very much appreciated
Thanks, Steve
SQL query:
CREATE TABLE `boardga_sql1`.`seller_stock` (
`seller_id` INT( 3 ) NOT NULL ,
`ID` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`products_model` VARCHAR( 20 ) NOT NULL ,
`stock_quantity` INT( 5 ) NOT NULL ,
`products_price` DOUBLE( 7 ) NOT NULL ,
`shipping_price` DOUBLE( 7 ) NOT NULL ,
`seller_sameday_price` DOUBLE( 7 ) NULL
)
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 ,
`shipping_price` DOUBLE( 7 ) NOT NULL ,
`seller_sameday_price` DO' at line 6
I get the error msg below when using the create table 'wizard' in phpmyadmin. The script it generates and the error are below. Any help would be very much appreciated
Thanks, Steve
SQL query:
CREATE TABLE `boardga_sql1`.`seller_stock` (
`seller_id` INT( 3 ) NOT NULL ,
`ID` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`products_model` VARCHAR( 20 ) NOT NULL ,
`stock_quantity` INT( 5 ) NOT NULL ,
`products_price` DOUBLE( 7 ) NOT NULL ,
`shipping_price` DOUBLE( 7 ) NOT NULL ,
`seller_sameday_price` DOUBLE( 7 ) NULL
)
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 ,
`shipping_price` DOUBLE( 7 ) NOT NULL ,
`seller_sameday_price` DO' at line 6