here’s the code! i need help with this! can anyone tell what’s wrong with it!
here’s the error i get: 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, type_id int(11) NOT NULL, description int NOT NULL, P
Thanks
CREATE TABLE events (
event_id int not null AUTO_INCREMENT,
dept_id int not null,
section_id int not null,
oo_id int not NULL,
location_id int not null,
action_id int not null,
date_from DATETIME not null,
date_to int not null,
title varchar not null,
type_id int(11) NOT NULL,
description int NOT NULL,
PRIMARY KEY (event_id)
) TYPE=MyISAM