Page 322 - IT 402 v2.0 class 10
P. 322
Step 2: Click on ‘Execute’ button.
1
2
elete Statement
‘Delete’ statement is used to remove one or more records in a database.
S nta : D E L E T E F RO M T AB L E _ NAM E W H E RE CO ND I T I O N;
am le : To delete records of the student who has secured 100 marks in the STUDENT table:
DELETE FROM STUDENT WHERE MARKS = 100;
Step 1: Type the statement.
Step 2: Click on ‘Execute’ button.
1
2
Recap Zone
ata efinition anguage or ata escription anguage is a standard for commands that
define the different structures in a database.
SQL statements consist of reserved words or characters used to perform arithmetical operations,
comparisons etc. hese reserved words or characters are called as Operators .
SQL Create Table statement is used to create a table in database. To create a table, assign a name
to the table and then define columns and the data types of each column.
ueries are commands that are used to define the data structure and also to manipulate the data
in the database. uery is used to collect specific information from the table.
ecords can also be added modified or deleted from the existing table using the Insert pdate
and Delete commands.
pdate statement is used for modifying records in a database.
320 Touchpad Information Technology-X

