O'Reilly logo

Active Server Pages 3.0 from Scratch by Nicholas Chase

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required