RSA Scripts

Create table with AUTO_INCREMENT

Create table with AUTO_INCREMENT.

  1. My Sql
  2. DDL
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

CREATE TABLE customers_2(
        id int(11) NOT NULL AUTO_INCREMENT,  
        name varchar(30) NOT NULL,  
        city char(3) NOT NULL,  
        phone varchar(20) NOT NULL,  
        PRIMARY KEY (`id`) 
    );