I've moved on to actually creating the MySQL database now. I've read a lot of theory on database design and such but at university I have not come across INNO DB tables and I believe these need to be used in order to maintain Referential Integrity and aid in the creation of foreign keys. Does the use of this table type as apposed to ISAM have any effect on the way I should implement my web-based project??
I'm currently using phpMyAdmin to test my database by running queries but upon creating this table I get an error.
CREATE TABLE Notification (
Notification_ID INT(4) NOT NULL AUTO_INCREMENT ,
Person_ID INT(4) NOT NULL ,
NotificationType_ID INT(4) NOT NULL ,
NotificationSubType_ID INT(4) NOT NULL ,
Notification_Details TEXT(250) NOT NULL ,
Notification_Date DATE(12) NOT NULL ,
Target_Date DATE(12) NOT NULL ,
Status_Type VARCHAR(32) NOT NULL ,
PRIMARY KEY (Notification_ID)
) TYPE = InnoDB
#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 '(12) NOT NULL, `Target_Date` DATE(12) NOT NULL, `Status_Type` V
Any ideas why??
Last edited by Wealth-Builderz; 11-30-04 at 15:53.