You have forgotten " ; " in the end
CREATE TABLE `delivery` ( `del_id` double NOT NULL AUTO_INCREMENT ,
`del_name` varchar( 60 ) default NULL ,
`del_date` date default '0000-00-00',
`del_status` tinyint( 1 ) default '0',
`del_delivered` date default '0000-00-00',
PRIMARY KEY ( `del_id` )
) CREATE TABLE `delivery_products` ( `del_id` double NOT NULL default '0',
`prod_id` double NOT NULL default '0',
`prod_quantity` double default '0'
);
If that does not work try to remove " ` "
CREATE TABLE delivery (del_id double NOT NULL AUTO_INCREMENT ,
del_name varchar(60) default NULL ,
del_date date default '0000-00-00',
del_status tinyint(1) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY (del_id)
) CREATE TABLE delivery_products (del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
);



Reply With Quote
