Nov 26, 2010

Insert Data Row

HOW CAN INSERT DATA IN SQL TABLE

SYNTAX:

INSERT INTO <table_name> VALUES <VALUES>

Where :


INTO Is A KEYWORD  Between INSERT and Target Table.
<Table_name> Is the name of the table where records are inserted. 
VALUES are also a keyword.
<values> Is the data which you want to insert into table.

EXAMPLE:

INSERT INTO FLIGHT_MASTER

VALUES ('KU','Kuwait Airways')

Press F5 key

RESULT:

Command(s) completed successfully.

The record has been inserted.

No comments:

Post a Comment