Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 5. Manipulating Data
Q&A
Q1:
With all the warnings about DELETE and UPDATE , I'm a little afraid to use them. If I accidentally update all the records in a table because the WHERE clause was not used, can the changes be reversed ?
A1:
There is no reason to be afraid, because there is not much you can do to the database that cannot be corrected, although considerable time and work may be involved. The next hour discusses the concepts of transactional control, which allows data manipulation operations to either be finalized or undone.
Q2:
Is the INSERT statement the only way to enter data into a table?
A2:
No, just remember that the INSERT statement is ANSI standard. The various implementations have their tools to enter data into tables. For example, Oracle has a utility called SQL*Loader. Also, many of the various implementations have utilities called IMPORT that can be used to insert data. There are many good books on the market that will expand on these utilities.