 |
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.
mSQL copyright 1996 Hughes Technologies Pty Ltd.
|
