s51Qy3zE

1ALTER TABLE infrastructure.mfg 
2CHANGE COLUMN
3 mfg_id mfg_id INT(10) UNSIGNED 
4NOT NULL AUTO_INCREMENT
5	
61st = 1000
72nd = 1100
83rd = 1200
94th = 1300
10	
11LAST_INSERT_ID()
12mysql_insert_id()
13	
14ALTER TABLE infrastructure.mfg 
15
16CHANGE COLUMN mfg_id
17 mfg_id INT(10) GENERATED ALWAYS AS () VIRTUAL
18	
19CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
20    (create_definition,...)
21    [table_options]
22    [partition_options]
23
24-- irrelevant stuff omitted
25
26column_definition:
27    data_type [NOT NULL | NULL] [DEFAULT default_value]
28      [AUTO_INCREMENT] [UNIQUE [KEY]] [[PRIMARY] KEY]
29      [COMMENT 'string']
30      [COLUMN_FORMAT {FIXED|DYNAMIC|DEFAULT}]
31      [STORAGE {DISK|MEMORY|DEFAULT}]
32      [reference_definition]
33
34-- irrelevant stuff omitted
35
36table_option:
37    AUTO_INCREMENT [=] value
38  | AVG_ROW_LENGTH [=] value
39
40-- many stuff omitted
41	
42ALTER TABLE infrastructure.mfg 
43    CHANGE COLUMN mfg_id mfg_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
44    AUTO_INCREMENT = 100 ;