Asterisk Databse linux

Creating a table with auto_increment

October 18, 2013March 5, 2014 eduguru 1 Comment autoincrement table, CREATE TABLE example_autoincrement ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Creating a table with auto_increment, data VARCHAR(100) ) TYPE=innodb;, data VARCHAR(100) ); CREATE TABLE example_innodb ( id INT, how to create auto increment table

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;

One thought on “Creating a table with auto_increment”

eduguruPost author
October 18, 2013 at 4:30 am
Permalink
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 Reply Cancel reply

You must be logged in to post a comment.