Mysql
-
DML ) insert,select,update query remind exampleMysql 2017. 11. 15. 16:24
---------------- INSERT ------------------------ -- Insert a row with all the column values INSERT INTO products VALUES (1001, 'PEN', 'Pen Red', 5000, 1.23); -- INSERT multiple rows in one command INSERT INTO products VALUES (NULL, 'PEN', 'Pen Blue', 8000, 1.25), (NULL, 'PEN', 'Pen Black', 2000, 1.25); -- Missing value for the auto_increment column also results in max_value + 1 INSERT INTO produ..