Create a similar table, preserve the auto-incrementing key

        
mysql>
mysql> CREATE TABLE product(
    ->     cust_num MEDIUMINT NOT NULL AUTO_INCREMENT,
    ->     cust_title TINYINT,
    ->     cust_last CHAR(20) NOT NULL,
    ->     cust_first CHAR(15) NOT NULL,
    ->     cust_suffix ENUM('Jr.', 'II', 'III','IV', 'V', 'M.D.','PhD'),
    ->     cust_add1 CHAR(30) NOT NULL,
    ->     cust_add2 CHAR(10),
    ->     cust_city CHAR(18) NOT NULL,
    ->     cust_state CHAR(2) NOT NULL,
    ->     cust_zip1 CHAR(5)NOT NULL,
    ->     cust_zip2 CHAR(4),
    ->     cust_duckname CHAR(25) NOT NULL,
    ->     cust_duckbday DATE,
    ->     PRIMARY KEY (cust_num)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 1, 'XML', 'Red', 'III', '1022 N.E. Sea of Rye', 'A207', 'Seacouver', 'WA', '98601', '3464', 'Netrek Rules'
, '1967:10:21');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 4, 'SQL', 'Vicki', 0, '2004 Singleton Dr.', 0, 'Freedom', 'KS', '67209', '4321', 'Frida Kahlo de Tomayo',
'1948:03:21');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 9, 'HTML', 'Chantel', 0, '1567 Terra Cotta Way', 0,  'Chicago', 'IL', '89129', '4444', 'Bianca', '1971:07:
29');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 7, 'Robert', 'David', 'Sr.', '20113 Open Road Highway', '#6', 'Blacktop', 'AZ', '00606', '1952', 'Harley',
 '1949:08:00');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 5, 'Kazui', 'Wonko', 'PhD', '42 Cube Farm Lane', 'Gatehouse', 'Vlimpt', 'CA', '45362', 0, 'Fitzwhistle', '
1961:12:04');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 6, 'iPhone', 'Karen', 0, '3113 Picket Fence Lane', 0,  'Fedora', 'VT', '41927', '5698', 'Tess D''urbervill
e', '1948:08:19');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>
mysql> INSERT INTO product VALUES
    -> (NULL, 8, 'Mac', 'Jenny', 0, '9 Wishing Well Court', 0, 'Meadowlark Hill', 'KS', '67048', '1234', 'Spike', '1961:
03:21');
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql>
mysql> CREATE TABLE cust_num_names (
    -> names_num MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
    -> names_first CHAR(15) NOT NULL,
    -> names_last CHAR(20) NOT NULL,
    -> PRIMARY KEY (names_num)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO cust_num_names
    -> SELECT cust_num, cust_first, cust_last FROM product;
Query OK, 7 rows affected (0.00 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql>
mysql> drop table cust_num_names;
Query OK, 0 rows affected (0.00 sec)

mysql> drop table product;
Query OK, 0 rows affected (0.00 sec)

Related examples in the same category

1.	Using AUTO_INCREMENT
2.	AUTO_INCREMENT Integers
3.	Preserve column attributes such as AUTO_INCREMENT and column's default value during table copying.
4.	An AUTO_INCREMENT column
5.	AUTO_INCREMENT sequences start at one
6.	For MyISAM tables, you can begin the sequence at a specific initial value n by including an AUTO_INCREMENT = n
7.	Using an AUTO_INCREMENT Column to Create Multiple Sequences
8.	AUTO_INCREMENT column:
9.	Not null tinyint and AUTO_INCREMENT
10.	MEDIUMINT NOT NULL AUTO_INCREMENT
11.	INTEGER UNSIGNED AUTO_INCREMENT
12.	Insert value to AUTO_INCREMENT column
13.	delete and reinsert value to AUTO_INCREMENT column
14.	SET @@AUTO_INCREMENT_OFFSET = 10,@@AUTO_INCREMENT_INCREMENT = 10
15.	Set AUTO_INCREMENT value
16.	Parameter: INT NOT NULL AUTO_INCREMENT
17.	Defining Auto-Increment Columns
18.	If this value is larger than the current sequence counter, subsequent automatically generated values begin with the value plus one

Create a similar table, preserve the auto-incrementing key : AUTO_INCREMENT « Data Type « SQL / MySQL

Related examples in the same category