mSQL
Tutorial 2
The "Insert" clause
Having created a table it is necessary to insert data
into the fields of that table. The insert clause is designed to
do just that.
To insert data you would do the following:
INSERT INTO table_name ( column [ , column ]** )
VALUES (value [, value]** )
An example would be:
INSERT INTO emp_details (first_name, last_name, dept, salary)
VALUES ('David', 'Hughes', 'I.T.S.', 12345)
|
What's going on here? Well, we are inserting into the emp_details
table "David" into first_name, "Hughes" into
last_name, "I.T.S." into dept, and "12345"
into salary. He's not paid well is he?
So the next item on our list is The
"Drop" clause.
|