Menu

Wednesday, 25 December 2013

Database Action Query


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]

SELECT QUERY 

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: