|
||||||||||||||
|
||||||||||||||
|| 
|| 
|| | SQL Basics |
 Introduction |
|
Create Tables
|
|
Data Type
|
|
Delete/Modify Table
|
|
Add Rows
|
|
Create Sequence
|
|
Quiries
|
|
Single-Row Function
|
|
Group Functions
|
|
Joints
|
|
Create Views
|
| Books @ |
|
CA Amazon |
|
UK Amazon |
| US Amazon |
| :: Home |
| PC Topics |
| :: Build A PC |
| :: Windows XP |
| :: PC Help |
| Tutorials |
| :: HTML |
| :: JavaScript |
| :: ASP |
| :: PHP |
| :: VBScript |
| :: SQL |
| Miscellaneous |
| :: Code/Scripts |
| :: Forum |
| :: Links |
| :: Contact us |
| :: Tell A Friend |
| :: In Somali |
| :: |
| Web Articles |
|
Top Web Hosting Reviews |
|
Processing Online Card Payment Guide |
|
Domain name registration & buying guide |
|
Getting a website online guide |
|
Search Engine submission & optimization tips |
|
Adding new rows to database table We created the table, define the constraints and now they are ready to be populated with data. INSERT command is used to populate the table with records. Here is a statement that adds a row or record to product table. This type of statement needs all the columns to be exact order. This is a poor way to insert values into a table
Here is a more favorable and controllable way to insert values into the a table.
| ||
  Create Sequences
|
|
| PC Articles |
|
Computer Safety prevent viruses & Spyware |