DML - MySQL Conclusion

Conclusion for DML (Manipulation Data) SQL Syntax for MySQL.

• DML = Data Manipulation Language

INSERT

Keywords	Syntax	Description	Link
INSERT INTO ... () VALUES ()	INSERT INTO <table_name> (Field1, Field2, FieldN) VALUES (Value1, Value2, ValueN);	Insert a new record to table (Specific)	Click Here
INSERT INTO ... VALUES ()	INSERT INTO VALUES (Value1, Value2, ValueN);	Insert a new record to table (All)	Click Here
INSERT INTO ... () VALUES (), ()	INSERT INTO <table_name> (Field1, Field2, FieldN) VALUES (Value1, Value2, ValueN), (Value1, Value2, ValueN);	Insert multiple new record to table (Specific)	Click Here
INSERT INTO ... VALUES (), ()	INSERT INTO <table_name> VALUES (Value1, Value2, ValueN), (Value1, Value2, ValueN);	Insert multiple new record to table (All)	Click Here

UPDATE

Keywords	Syntax	Description	Link
UPDATE ... SET ... = ... WHERE ... = ...	UPDATE <table_name> SET field1 = new_value, fieldN = new_value_N WHERE <condition>;	Update records of a table	Click Here

DELETE

Keywords	Syntax	Description	Link
DELETE FROM ... WHERE ... = ...	DELETE FROM <table_name> WHERE <condition>;	Delete records of a table	Click Here