1. MYSQL QUERY OF PHP
INSERT QUERY:
"Insert into Table_Name ( field1, field2,...fieldN )
VALUES
( value1, value2,...valueN )";
Example:
"INSERT INTO info_tb (name, address, phone) VALUES ('Rakesh', 'Kestopur', '9681212112')";
SELECT QUERY:
"select * from table_name";
Example:
"select * from info_tb";
Where info_tb is table name.
UPDATE QUERY:
"update table_name set field1=new-value1, field2=new-value2
[WHERE Clause]";
Example:
"update info_tb set name='$a',addr='$b',phone='$c'where id='$x'";
DELETE QUERY:
"Delete from table_name where (condition)";
Example:
"Delete * from Emp_tb Where e_name = "john"";
Where Emp_tb is table name.
DELETE TABLE QUERY:
"DROP TABLE emp_data";
