This is personal study note Copyright and original reference: https://www.youtube.com/watch?v=hUXOf8JEupM&list=PLVsNizTWUw7HhYtI-4GGmlJ5yxNdwNI_X ================================================================================ SQL statement: DML, DDL, DCL DML: select, insert, update, delete DDL: create, drop, alter DCL: grand, revoke, deny ================================================================================ 3 values are inserted into 3 fields ================================================================================ 2 values are inserted into 2 fields (id, userName) ================================================================================ Explicit order of field ================================================================================ Auto_increment ================================================================================ Get last id ================================================================================ new start number for auto-incremented-id ================================================================================ use "leap" for Auto_increment_id ================================================================================ Copy large data and paste it into new table Simpler statement without insert into ================================================================================ update ================================================================================ ================================================================================ ================================================================================ If price has been changed due to, for example, currency change, you can use update statement without using where clause ================================================================================ delete from ================================================================================ Create large data tables for test ================================================================================ remove table, time comparison ================================================================================ ================================================================================ BBK is duplicate in terms of PK ================================================================================ ignore: if error occurs, that data is ignored ================================================================================