www.webdeveloper.com
Results 1 to 2 of 2

Thread: [RESOLVED] What error?

  1. #1
    Join Date
    Mar 2010
    Location
    Finland
    Posts
    82

    resolved [RESOLVED] What error?

    Hi, Can anyone spot the error here? I sure can't
    #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 'TYPE=MyISAM)' at line 12
    Code:
    CREATE TABLE pec_mssgs (
      id mediumint(5) unsigned NOT NULL auto_increment,
      uid tinyint(3) unsigned NOT NULL default '0',
      m tinyint(2) NOT NULL default '0',
      d tinyint(2) NOT NULL default '0',
      y smallint(4) NOT NULL default '0',
      start_time time NOT NULL default '00:00:00',
      end_time time NOT NULL default '00:00:00',
      title varchar(50) NOT NULL default '',
      text text NOT NULL,
      PRIMARY KEY  (id)
    ) TYPE=MyISAM
    ;
    Note: I'm using...
    PHP version: 5.3.14
    MySQL version: 5.5.10
    Perhaps something here in the code is depreciated?

    Thanks.
    Last edited by leke; 09-01-2012 at 11:43 AM.

  2. #2
    Join Date
    Mar 2010
    Location
    Finland
    Posts
    82
    Ah, ok. After more googleing I found TYPE is depreciated. Use ENGINE instead.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles