Experiment 3

 

Queries retrieve and change data create, insert, update, delete command.

1.  Create command: To create table we use create command.

Eg: To create a table employee(enamevarchar(10),eidint,esalint);

2. Update command :To update the values for particular column(value).

Syntax:

Update table table_nameset column1=value1,column2=value2,..

where condition

 

3.  Delete command: To delete the values for a particular column (value).

Syntax:

Delete from tablename where [condition];