1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
query:
update | insert | select | alter | transaction ;
select:
SELECT _field FROM _table WHERE where_cond group_by limit;
group_by:
| GROUP BY _field ;
limit:
| LIMIT digit ;
where_cond:
_field < digit;
insert:
INSERT INTO _table ( _field , _field ) VALUES ( digit , digit ) ;
update:
# UPDATE _table SET _field = digit WHERE where_cond limit
;
delete:
DELETE FROM _field WHERE where_cond LIMIT digit;
transaction:
START TRANSACTION | COMMIT | ROLLBACK;
alter:
ALTER online TABLE _table key_def , key_def |
ALTER online TABLE _table DROP KEY letter ;
online:
;
key_def:
ADD key_type letter ( _field , _field );
key_type:
KEY | UNIQUE | PRIMARY KEY ;
|