This Post is a quick lookup of the SQL-Syntax.
| key | example |
|---|---|
| CREATE TABLE | CREATE TABLE table_name ('column1' NVARCHAR(32), 'column2' NUMBER, ... ) |
| DROP TABLE | DROP TABLE table_name |
| TRUNCATE TABLE | TRUNCATE TABLE table_name |
| INSERT INTO | INSERT INTO table_name(column1, column2, ...) VALUES(value1, value2, ...) WHERE ... |
| UPDATE | UPDATE table_name SET column1=value1 WHERE ... |
| DELETE FROM | DELETE FROM table_name WHERE ... |
Data Types
Oracle
MySQL
Editors
Eclipse Data Tools Platform (DTP)
Eclipse SQL Explorer
No comments:
Post a Comment