Problems creating a table

loureiro

hi,

im getting an error everytime i try to create this table. can anyone help?

CREATE TABLE Customer (

customerID INT( 5 ) NOT NULL AUTO_INCREMENT,
name VARCHAR( 30 ) NOT NULL ,
address VARCHAR( 40 ) NOT NULL ,
city VARCHAR( 25 ) NOT NULL ,
state VARCHAR( 20 ) NOT NULL ,
country VARCHAR( 2 ) NOT NULL ,
email VARCHAR( 40 ) NOT NULL ,
phone VARCHAR( 13 ) NOT NULL ,
cell VARCHAR( 13 ) ,
fax VARCHAR( 13 ) ,
title VARCHAR( 25 ) ,
picture VARCHAR( 3 ) NOT NULL ,
signature VARCHAR( 3 ) NOT NULL ,
link1 VARCHAR( 35 ) ,
link2 VARCHAR( 35 ) ,
link3 VARCHAR( 35 ) ,
link4 VARCHAR( 35 ) ,
comments VARCHAR( 255 ) ,
distributor VARCHAR( 25 ) ,
sponsor VARCHAR( 25 ) ,
package VARCHAR( 8 ) NOT NULL ,
version VARCHAR( 15 ) NOT NULL ,
design VARCHAR( 25 ) NOT NULL ,
finished VARCHAR( 3 ) DEFAULT 'no' NOT NULL ,
update VARCHAR( 3 ) DEFAULT 'no' NOT NULL ,
dateuploaded DATE NOT NULL ,
amounttopay DOUBLE( 5 ) ,
gsttopay DOUBLE( 5 ) ,
PRIMARY KEY ( customerID )
)

loureiro

also i was wondering if there is a date function i can use with my date field. thanks

laserlight

SQL isnt exactly my strong point, but could it be that there is a problem with setting a VARCHAR field as NOT NULL without a default value?

Also, it would help if you posted the error message returned.

As for a function to use with handling dates of that form, well, in PHP we have a number of them, e.g. date()
I would suggest reading the PHP manual on date/time functions.
I personally store dates as an integer obtained from time() in PHP.

loureiro

SQL-query :

CREATE TABLE Customer (

MySQL said:

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 '), gsttopay DOUBLE(5), PRIMARY KEY (customerID))' at line 1

this is what it shows me when i try to create the table