SQL Examples

CREATE
All domains

MySQL
limit to five results, start from the fifth result.

MS-SQL
no offset

DB2
Use MYSQL compatibility mode

Export to CSV
The FILE privilege This command does not seem to work.

SELECT INTO

MySQL
LAST_INSERT_ID