Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
|
SELECT |
SELECT * FROM table; |
|
|
INSERT INTO |
INSERT INTO table (a,b,c) VALUES (1,2,3) ORDER BY b; |
|
|
UPDATE |
UPDATE table SET a = 7, b = 5; |
|
|
DELETE FROM |
DELETE FROM table WHERE a = 7; |
|
|
SELECT COUNT |
SELECT COUNT (*) FROM table; |
|
|
- - |
a comment |
|
|
/* |
a multi-line comment |
|
|
CREATE TABLE |
CREATE TABLE test (a INTEGER, b TEXT); INSERT INTO test VALUES (1,'a'); INSERT INTO test VALUES (2,'a'); INSERT INTO test VALUES (3,'a'); SELECT * FROM test; |
|
|
DELETE TABLE |
DROP TABLE test; |
|
|
DELETE ROW |
DELETE FROM test WHERE a=?; |
|
|
ALTER TABLE |
ALTER TABLE test; |
|
|
Includes a value in the name (LIKE) |
LIKE '%test%' |
|
|
SELECT DISTINCT |
removes duplicate |
|
|
Descending |
DESC |
|
|
Length String |
SELECT LENGTH('string'); |
|
|
Sub String |
SELECT SUBSTR('this string', 6) |
|
|
Integers Types |
INTEGERS(precision) DECIMAL(precision, scale) MONEY(precision, scale) |
|
|
Real Types |
REAL(precision) FLOAT(precision) |
|
|
Dates & Times |
DATE TIME DATETIME YEAR INTERVAL Exp. SELECT DATE ('now') |
|
|
Save Views |
SELECT VIEW (); |
