One thought on “Creating a table with auto_increment

  • 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()
    );

Leave a Reply