SQL Reference

Chapter 2 | Supported standards 17
1 If the data was inserted using the Insert > Picture command, drag and drop, or paste from the
clipboard, specify one of the file types listed in the following table. For example:
SELECT GetAs(Company_Logo, 'JPEG') FROM Company_Icons
DELETE statement
Use the DELETE statement to delete records from a database table. The format of the DELETE
statement is:
DELETE FROM table_name [ WHERE { conditions } ]
Note The WHERE clause determines which records are to be deleted. If you don’t include the
WHERE keyword, all records in the table are deleted (but the table is left intact).
Example
An example of a DELETE statement on the Employee table is:
DELETE FROM emp WHERE emp_id = 'E10001'
Each DELETE statement removes every record that meets the conditions in the WHERE clause. In
this case, every record having the employee ID E10001 is deleted. Because employee IDs are
unique in the Employee table, only one record is deleted.
INSERT statement
Use the INSERT statement to create records in a database table. You can specify either:
1 A list of values to be inserted as a new record
1 A SELECT statement that copies data from another table to be inserted as a set of new records
The format of the INSERT statement is:
INSERT INTO table_name [(column_name, ...)] VALUES (expr, ...)
column_name is an optional list of column names that provides the name and order of the
columns whose values are specified in the VALUES clause. If you omit column_name, the value
expressions (expr) must provide values for all columns defined in the table and must be in the
same order that the columns are defined for the table. column_name may also specify a field
repetition, for example lastDates[4].
File type Description File type Description
'GIFf' Graphics Interchange Format 'PNTG' MacPaint
'JPEG' Photographic images '.SGI' Generic bitmap format
'JP2 ' JPEG 2000 'TIFF' Raster file format for digital images
'PDF ' Portable Document Format 'TPIC' Targ a
'PNGf' Bitmap image format '8BPS' PhotoShop (PSD)