Active Server Pages 3.0 from Scratch

SQL Basics: Insert

One nice thing about SQL is that it is a standard, so while each database has its own dialect that makes it unique, almost any database can understand the basic commands. Another nice thing about it is that if you look at it like a sentence, it almost makes sense. Over the course of this project you look at the four basic SQL statements: insert, update, delete, and select. But for now just look at insert. The most common form of insert statement is as follows:

insert into table_name (column_names) values (data_values)

Most databases enable you to leave out the column names under certain circumstances, but you're asking for trouble later if you do. So to insert the URL and the current date into the ad_loc table, use the following ...