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
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event |
20
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event |
21
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event |
22
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event | ddl ;
39
binlog_format_statement ; dml ; dml ; dml ; dml ; binlog_format_restore ;
42
intvar_event_pk | intvar_event_last_insert_id ;
45
binlog_format_statement ; INSERT INTO _table ( `pk` ) VALUES ( NULL ) ; binlog_format_restore ;
47
intvar_event_last_insert_id:
48
binlog_format_statement ; INSERT INTO _table ( _field ) VALUES ( LAST_INSERT_ID() ) ; binlog_format_restore ;
51
binlog_format_statement ; rand_event_dml ; binlog_format_restore ;
54
INSERT INTO _table ( _field ) VALUES ( RAND () ) |
55
UPDATE _table SET _field = RAND() where ORDER BY RAND () limit |
56
DELETE FROM _table WHERE _field < RAND() limit ;
59
binlog_format_statement ; SET @a = value ; user_var_dml ; binlog_format_restore ;
62
INSERT INTO _table ( _field ) VALUES ( @a ) |
63
UPDATE _table SET _field = @a ORDER BY _field LIMIT digit |
64
DELETE FROM _table WHERE _field < @a LIMIT 1 ;
67
START TRANSACTION | COMMIT | ROLLBACK |
68
SAVEPOINT A | ROLLBACK TO SAVEPOINT A | RELEASE SAVEPOINT A |
72
CREATE DATABASE ic ; CREATE TABLE ic . _letter SELECT * FROM _table LIMIT digit ; DROP DATABASE ic |
73
CREATE USER _letter | DROP USER _letter | RENAME USER _letter TO _letter |
74
SET AUTOCOMMIT = ON | SET AUTOCOMMIT = OFF |
75
CREATE TABLE IF NOT EXISTS _letter ENGINE = engine SELECT * FROM _table LIMIT digit |
76
RENAME TABLE _letter TO _letter |
77
TRUNCATE TABLE _letter |
78
DROP TABLE IF EXISTS _letter |
79
LOCK TABLE _table WRITE ; UNLOCK TABLES |
80
SELECT * FROM _table LIMIT digit INTO OUTFILE tmpnam ; LOAD DATA INFILE tmpnam REPLACE INTO TABLE _table ;
82
begin_load_query_event:
83
binlog_format_statement ; load_data_infile ; binlog_format_restore ;
85
execute_load_query_event:
86
binlog_format_statement ; load_data_infile ; binlog_format_restore ;
89
SELECT * FROM _table ORDER BY _field LIMIT digit INTO OUTFILE tmpnam ; LOAD DATA INFILE tmpnam REPLACE INTO TABLE _table ;
92
binlog_format_row ; insert ; binlog_format_restore ;
95
binlog_format_row ; update ; binlog_format_restore ;
98
binlog_format_row ; delete ; binlog_format_restore ;
100
binlog_format_statement:
101
SET @binlog_format_saved = @@binlog_format ; SET BINLOG_FORMAT = 'STATEMENT' ;
104
SET @binlog_format_saved = @@binlog_format ; SET BINLOG_FORMAT = 'ROW' ;
106
binlog_format_restore:
107
SET BINLOG_FORMAT = @binlog_format_saved ;
110
insert | update | delete ;
113
INSERT INTO _table ( _field ) VALUES ( value ) ;
116
UPDATE _table SET _field = value where order_by limit ;
119
DELETE FROM _table where LIMIT 1 ;
122
CREATE TRIGGER _letter trigger_time trigger_event ON _table FOR EACH ROW BEGIN procedure_body ; END |
123
CREATE EVENT IF NOT EXISTS _letter ON SCHEDULE EVERY digit SECOND ON COMPLETION PRESERVE DO BEGIN procedure_body ; END ;
124
CREATE PROCEDURE _letter () BEGIN procedure_body ; END ;
133
binlog_event ; binlog_event ; binlog_event ; CALL _letter () ;
139
WHERE _field > value |
140
WHERE _field < value |
141
WHERE _field = value ;
150
_digit | _english | NULL ;