mSQL Tutorial 2 - The "Insert" clause

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.