By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
column1 | column2 |
---|---|
11 | value 11 |
123 | value 123 |
12 | value 1234 |
13 | value 1313 |
Table | Create Table |
---|---|
old_table | CREATE TABLE `old_table` ( `column1` int DEFAULT NULL, `column2` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
column1 | column2 |
---|---|
11 | value 11 |
123 | value 123 |
12 | value 1234 |
13 | value 1313 |
id | column1 | column2 |
---|---|---|
1 | 11 | value 11 |
2 | 123 | value 123 |
3 | 12 | value 1234 |
4 | 13 | value 1313 |
Table | Create Table |
---|---|
new_table | CREATE TABLE `new_table` ( `id` int NOT NULL AUTO_INCREMENT, `column1` int DEFAULT NULL, `column2` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
max(id) |
---|
4 |
max(id) |
---|
8 |
id | column1 | column2 |
---|---|---|
1 | 11 | value 11 |
2 | 123 | value 123 |
3 | 12 | value 1234 |
4 | 13 | value 1313 |
8 | 10 | michaelangelo |