Page 319 - IT 402 v2.0 class 10
P. 319
am le: Create a table of ‘Students’ that contains four columns: STUDENT_ID, FIRST NAME, LAST NAME and
MARKS.
Click on ‘Tools’ menu and then select ‘SQL’ option. ‘Execute SQL Statement’ window appears on the screen.
Type the following SQL Commands in the ‘Command to execute’ section.
CRE AT E T AB L E ST U D E NT
(
ST U D E NT _ I D I NT ,
F I RST NAM E V ARCH AR ( 2 5 5 ) ,
L AST NAM E V ARCH AR ( 2 5 5 ) ,
M ARK S I NT
) ;
Click on ‘Execute’ button.
Successful execution of command is displayed on ‘Status’ section.
CREATE COMMAND WITH PRIMARY KEY
CRE AT E T AB L E ST U D E NT
(
Ad mno nu mer ic p r imar y K ey ,
firstname varchar(200),
lastname varchar (200),
mar k s int
) ;
MANAGING QUERY
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. uery helps us to oin information
from different tables and filter specific information as per the re uired criteria.
More on Database 317

