INSERT QUERY
INSERT INTO Table_Name
(column_name1, column_name2) VALUES (Column_value1, column_value2)
UPDATE QUERY
UPDATE Table_Name SET
Column_Name1 = Column_Value1, Column_Name2=Column_Value2 WHERE
Column_ID=Value_ID
DELETE QUERY
1. DELETE FROM Table_Name
[It delete whole table ]
2. DELETE FROM Table_Name
WHERE Column_ID=Value_ID [it deletes one row of table using by
Column_ID]
1. SELECT * FROM Table_Name [it select whole data of specified table]
2. SELECT * FROM Table_Name WHERE Column_ID=Value_ID [it select
row data of specified table using by Column_ID]
No comments:
Post a Comment