Creating a table with auto_increment

March 5, 2014October 18, 2013 by eduguru

CREATE TABLE example_autoincrement (
         id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
         data VARCHAR(100)
       );

CREATE TABLE example_innodb (
          id INT,
          data VARCHAR(100)
        ) TYPE=innodb;

1 thought on “Creating a table with auto_increment”

eduguru

October 18, 2013 at 4:30 am

CREATE TABLE user_data (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
user_id varchar(100),
prod_id VARCHAR(100),
created TIMESTAMP DEFAULT NOW()
);
Log in to Reply

Leave a Comment Cancel reply

You must be logged in to post a comment.