|
|||||
Kickass Phone Rates from 3U
|
|||||
| PLACES TO GO: |
A cheat sheet on basic SQL that I like to have handy in case my brain needs a jog. SELECT (DISTINCT) select_list (AVG(DISTINCT)) (COUNT) (MAX) (MIN) (SUM(DISTINCT)) FROM (table_list | view_list) WHERE search_conditions (IN | NOTIN) (EXISTS) GROUP BY non_aggregate_expressions HAVING search_conditions ORDER BY column_list ([ASC | DESC]) INSERT INSERT INTO table_name (column_list) VALUES (constant_expressions | select_statement) UPDATE UPDATE table_name SET column=value (,column=value) FROM table_list WHERE search_conditions DELETE DELETE FROM table_name WHERE search_conditions CREATE TABLE CREATE TABLE tablename( column_name type restriction, column_name type restriction, PRIMARY KEY(column_name)); ALTER TABLE
ALTER TABLE tablename
ADD column-definition [ column-constraint ... ]
| ADD table-constraint
| { ADD PCTFREE percent-free-space | PCTFREE DEFAULT }
| MODIFY column-definition
| MODIFY column-name DEFAULT default-value
| ALTER column-name SET DEFAULT default-value
| ALTER column-name DROP DEFAULT
| ALTER column-name SET COMPUTE ( expression )
| ALTER column-name DROP COMPUTE
| MODIFY column-name [ NOT ] NULL
| MODIFY column-name CHECK NULL
| MODIFY column-name CHECK ( condition )
| { DELETE | DROP } column-name
| { DELETE | DROP } CHECK
| { DELETE | DROP } UNIQUE ( column-name, ... )
| { DELETE | DROP } PRIMARY KEY
| { DELETE | DROP } FOREIGN KEY role-name
| RENAME new-table-name
| RENAME column-name TO new-column-name
ALTER TABLE tablename
ADD FOREIGN KEY fkname(column-name)
REFERENCES tablename(ref_column)
on update ACTION,
on delete ACTION;
|
||||
