Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2004
    Posts
    29

    Exclamation Unanswered: MySQL Implementation Issue

    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??

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, it shouldn't, it merely allows you to utilize relational integrity in the database rather than writing logic into your app to handle it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2004
    Posts
    29
    Thanks, just needed to make sure before hand.

  4. #4
    Join Date
    Oct 2004
    Posts
    29

    Thumbs down

    I'm currently using phpMyAdmin to test my database by running queries but upon creating this table I get an error.

    SQL-query:

    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

    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 '(12) NOT NULL, `Target_Date` DATE(12) NOT NULL, `Status_Type` V


    Any ideas why??
    Last edited by Wealth-Builderz; 11-30-04 at 16:53.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    DATE datatype doesn't take a length

    it's a special datatype with an internal format that you need not know anything about
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Oct 2004
    Posts
    29
    D'oh, silly me, thanks r937.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •