Inserting Data into a Table

A database, no matter how well defined, is useless without data. To add data to your database table, use the Insert Into statement. This statement has the following syntax:

Insert Into tableName (columnNameList) Values(valueList)

The column name list is an optional parameter that allows you to insert the values in a row in any order. The values in the values list will be inserted into the table in a one to one correspondence with the column order defined in the column name list.

$SOL = qq | Insert Into MailTable (firstName, Phone)
Values ('$YourName, '$YourPhone) |;

The single quotes are required in the values list when using the Insert Into statement with win32:.:ODBC and Microsoft Access. Single quotes are only used on text column data.

Domain Name Search