Updating the Database

In this chapter we will discuss the various ways of updating tables. You will learn the commands to enter new rows, alter existing data items, delete rows - and recover from mistakes! We will also discuss ways of transferring data from one table to another, and how to ‘import’ data from a non-SQL file into an SQL table.