Jump to content

roslen

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

roslen's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Help plz. i get this error when running code below. Error SQL query: CREATE TABLE wateva_table( id int( 9 ) DEFAULT '0' NOT NULL AUTO_INCREMENT , name varchar( 20 ) NOT NULL , COMMENT text NOT NULL , date varchar( 10 ) NOT NULL , time varchar( 10 ) NOT NULL , ip varchar( 39 ) , PRIMARY KEY ( id ) ) MySQL said: #1067 - Invalid default value for 'id' can i just remove the default like this: id int( 9 ) NOT NULL AUTO_INCREMENT , will that make the default to number '0'
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.