fVZKYpHi

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