To write a query with DML commands .
DML (Data Manipulation Language):
The SQL commands that deal with the manipulation of data present in the database belong to DML or Data Manipulation Language, and this includes most of the SQL statements. It is the component of the SQL statement that controls access to data and to the database. Basically, DCL statements are grouped with DML statements.
List of DML commands:
- INSERT: It is used to insert data into a table. QUERY*
- UPDATE: It is used to update existing data within a table. QUERY*
- DELETE: It is used to delete records from a database table. QUERY*
INSERT INTO BOOKS VALUES (1012, 'C+', 'ABC', 'Xyz', 800, 3, 2); |
UPDATE Customers SET ContactName = 'Alfred Schmidt', City = 'Frankfurt' WHERE CustomerID = 1; |
DELETE FROM Customers WHERE CustomerName = 'Alfreds Futterkiste'; |
Comments
Post a Comment