1
# Copyright (C) 2008 Sun Microsystems, Inc. All rights reserved.
2
# Use is subject to license terms.
4
# This program is free software; you can redistribute it and/or modify
5
# it under the terms of the GNU General Public License as published by
6
# the Free Software Foundation; version 2 of the License.
8
# This program is distributed in the hope that it will be useful, but
9
# WITHOUT ANY WARRANTY; without even the implied warranty of
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11
# General Public License for more details.
13
# You should have received a copy of the GNU General Public License
14
# along with this program; if not, write to the Free Software
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
19
dml | dml | dml | dml | dml | dml | dml | dml | dml | dml |
20
dml | dml | dml | dml | dml | dml | dml | dml | dml | dml |
21
database | tablespace | table |
22
alter | show | transaction | use ;
25
SELECT _field FROM _letter WHERE where_cond group_by limit;
28
update | insert | select | delete ;
40
INSERT INTO _letter ( _field , _field ) VALUES ( _digit , _digit ) ;
43
UPDATE _letter SET _field = _digit WHERE where_cond limit ;
46
DELETE FROM _letter WHERE where_cond LIMIT _digit;
49
START TRANSACTION | COMMIT | ROLLBACK | SAVEPOINT A | ROLLBACK TO SAVEPOINT A ;
55
create_database | create_database | create_database | create_database | create_database |
59
CREATE DATABASE IF NOT EXISTS _letter ;
62
DROP DATABASE IF EXISTS _letter ;
65
create_tablespace | create_tablespace | create_tablespace | create_tablespace | create_tablespace |
69
CREATE TABLESPACE _letter ADD DATAFILE ' _letter . TABLESPACE ' ENGINE = Falcon ;
72
DROP TABLESPACE _letter ENGINE = Falcon ;
75
create_table | create_table | create_table | create_table | create_table |
76
drop_table | rename_table | truncate_table ;
79
CREATE TEMPORARY TABLE IF NOT EXISTS _letter TABLESPACE _letter SELECT * FROM _letter |
80
CREATE TABLE IF NOT EXISTS _letter (`pk` INTEGER AUTO_INCREMENT NOT NULL , PRIMARY KEY (`pk`) ) TABLESPACE _letter |
81
CREATE TABLE IF NOT EXISTS _letter (`pk` INTEGER ) partition ;
84
DROP TABLE IF EXISTS _letter ;
87
RENAME TABLE _letter TO _letter |
88
RENAME TABLE _letter . _letter TO _letter . _letter ;
91
TRUNCATE TABLE _letter ;
94
ALTER TABLE _letter ADD PARTITION (PARTITION _letter VALUES LESS THAN ( _tinyint_unsigned ) TABLESPACE _letter ) |
95
ALTER TABLE _letter DROP PARTITION _letter |
96
ALTER TABLE _letter REORGANIZE PARTITION _letter INTO (
97
PARTITION _letter VALUES LESS THAN ( _digit ) TABLESPACE _letter ,
98
PARTITION _letter VALUES LESS THAN ( _tinyint_unsigned ) TABLESPACE _letter
100
ALTER TABLE _letter REMOVE PARTITIONING |
101
ALTER TABLE _letter partition ;
104
PARTITION BY KEY(`pk`) |
105
PARTITION BY RANGE (`pk`) (
106
PARTITION _letter VALUES LESS THAN ( _digit ) TABLESPACE _letter ,
107
PARTITION _letter VALUES LESS THAN ( _tinyint_unsigned ) TABLESPACE _letter ,
108
PARTITION _letter VALUES LESS THAN MAXVALUE TABLESPACE _letter
113
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA |