Sunday, November 11, 2007

SQL INSERT INTO Statement

The INSERT INTO Statement

The INSERT INTO statement is used to insert new rows into a table.

Syntax

INSERT INTO table_name

VALUES (value1, value2,....)

You can also specify the columns for which you want to insert data:

INSERT INTO table_name (column1, column2,...)

VALUES (value1, value2,....)

Insert a New Row

This "Persons" table:

LastName

FirstName

Address

City

Pettersen

Kari

Storgt 20

Stavanger

And this SQL statement:

INSERT INTO Persons
VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')

Will give this result:

LastName

FirstName

Address

City

Pettersen

Kari

Storgt 20

Stavanger

Hetland

Camilla

Hagabakka 24

Sandnes

Insert Data in Specified Columns

This "Persons" table:

LastName

FirstName

Address

City

Pettersen

Kari

Storgt 20

Stavanger

Hetland

Camilla

Hagabakka 24

Sandnes

And This SQL statement:

INSERT INTO Persons (LastName, Address)

VALUES ('Rasmussen', 'Storgt 67')

Will give this result:

LastName

FirstName

Address

City

Pettersen

Kari

Storgt 20

Stavanger

Hetland

Camilla

Hagabakka 24

Sandnes

Rasmussen


Storgt 67



Wednesday, November 7, 2007

Complete model of Testing


Grab this Widget ~ Blogger Accessories