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
insert | update | delete | transaction | load_data_infile;
23
START TRANSACTION | COMMIT | ROLLBACK |
24
SAVEPOINT A | ROLLBACK TO SAVEPOINT A | RELEASE SAVEPOINT A |
28
CREATE DATABASE implicit_commit ; CREATE TABLE implicit_commit . _letter SELECT * FROM _table LIMIT digit ; DROP DATABASE implicit_commit |
29
SET AUTOCOMMIT = ON | SET AUTOCOMMIT = OFF |
30
CREATE TABLE IF NOT EXISTS _letter ENGINE = engine SELECT * FROM _table LIMIT digit |
31
RENAME TABLE _letter TO _letter |
32
TRUNCATE TABLE _letter |
33
DROP TABLE IF EXISTS _letter |
34
LOCK TABLE _table WRITE ; UNLOCK TABLES ;
37
SELECT * FROM _table ORDER BY _field LIMIT digit INTO OUTFILE tmpnam ; LOAD DATA INFILE tmpnam REPLACE INTO TABLE _table ;
40
INSERT INTO _table ( _field , _field , _field , _field ) VALUES ( value , value , value , value ) |
41
INSERT INTO _table ( _field , _field , _field ) VALUES ( value , value , value ) |
42
INSERT INTO _table ( _field , _field ) VALUES ( value , value ) |
43
INSERT INTO _table SELECT * FROM _table LIMIT digit ;
46
UPDATE _table SET _field = value where order_by limit ;
49
DELETE FROM _table where LIMIT digit ;
52
WHERE _field > value |
53
WHERE _field < value |
54
WHERE _field = value ;
63
_digit | _letter | _english | _data |
64
_digit | _letter | _english | _data | NULL ;