MySQL INSERT,UPDATE,DELETE and SELECT Queries
Different types of mysql queries insert,update,delete and select
MySQL INSERT
MySQL INSERT used to insert data in MySQL table within the database. You can insert single or multiple records using a single query.
MySQL UPDATE Syntax
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN );
MySQL UPDATE
MySQL UPDATE used to update data of the MySQL table within the database. It is used when you need to modify the table.
MySQL UPDATE Syntax
UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]
MySQL DELETE
MySQL DELETE used to delete data from the MySQL table within the database. By using delete statement, we can delete records on the basis of conditions.
MySQL DELETE Syntax
DELETE FROM table_name WHERE (Condition specified);
MySQL SELECT
The MySQL SELECT used to fetch data from the one or more tables in MySQL. We can retrieve records of all fields or specified fields.
MySQL SELECT Syntax
SELECT expressions FROM tables [WHERE conditions]; //for all fields SELECT * FROM tables [WHERE conditions];