db sql error.. easy fix

[nickbunyun]

Error

SQL query:

 

CREATE TABLE `inventory` (

 

`id` int NOT NULL PRIMARY KEY '',

`full_name` varchar( 100 ) NOT NULL default '',

`phone_number` varchar( 20 ) NOT NULL default '',

`address` text NOT NULL default '',

`short_info` varchar( 150 ) NOT NULL default '',

`long_info` text NOT NULL default '',

`new_date` date '',

`user` varchar( 20 ) NOT NULL default '',

`other_info` text NOT NULL default '',

 

)

 

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 ''',

`full_name` varchar(100) NOT NULL default '',

`phone_number` varchar(20) N' at line 2

 

 

[sasa]

try

CREATE TABLE `inventory` (

`id` int NOT NULL PRIMARY KEY ,
`full_name` varchar( 100 ) NOT NULL default '',
`phone_number` varchar( 20 ) NOT NULL default '',
`address` text NOT NULL default '',
`short_info` varchar( 150 ) NOT NULL default '',
`long_info` text NOT NULL default '',
`new_date` date ,
`user` varchar( 20 ) NOT NULL default '',
`other_info` text NOT NULL default ''

) 

[AndyB]

Please DO NOT DOUBLE POST

 

Having two people solve the same problem in two different places (mis-placed as well) just irritates solvers, as well as being against forum guidelines.