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.

Back to Pagehome Tutorial Page

Ordering
Support
FAQ
Suggestions
Search
Resources
Prices
Brought to you by:
Great Southern Resources, Inc.
Copyright© 1997 All rights reserved.
 
All other products mentioned are registered trademarks or trademarks of their respective companies.

Questions or problems regarding this web site should be directed to webmaster@pagehome.com.