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 |
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
|
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
|
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Promote collaboration among coworkers in your organization through project workspaces where others can efficiently find information and work together |
|
Personalize your company profile by bookmarking and organizing favorite content, uploading assets, posting photos, blogging, and more |
|
Interact with features like tagging, flagging, wikis and ratings found in the Web 2.0 Toolbox |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an
INSTANT DEMO or download a
FREE TRIAL today. |
|
HOME
Printer friendly page
