ndb_binlog_ddl_multi.result

来自「开启mysql的远程连接的方法 mysql-noinstall-5.1.6-al」· RESULT 代码 · 共 126 行

RESULT
126 行
字号 
drop database if exists mysqltest;drop table if exists t1,t2;drop database if exists mysqltest;drop table if exists t1,t2;reset master;reset master;create database mysqltest;use mysqltest;create table t1 (a int primary key) engine=ndb;create table t2 (a int primary key) engine=ndb;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	create database mysqltestmaster-bin1.000001	#	Query	#	#	use `mysqltest`; create table t1 (a int primary key) engine=ndbmaster-bin1.000001	#	Query	#	#	use `test`; create table t2 (a int primary key) engine=ndbshow binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000001	#	Query	#	#	create database mysqltestmaster-bin.000001	#	Query	#	#	use `mysqltest`; create table t1 (a int primary key) engine=ndbmaster-bin.000001	#	Query	#	#	use `test`; create table t2 (a int primary key) engine=ndbreset master;reset master;alter table t2 add column (b int);show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	BEGINmaster-bin1.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Query	#	#	COMMITmaster-bin1.000001	#	Query	#	#	use `test`; alter table t2 add column (b int)reset master;reset master;ALTER DATABASE mysqltest CHARACTER SET latin1;drop table mysqltest.t1;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000001	#	Query	#	#	ALTER DATABASE mysqltest CHARACTER SET latin1master-bin.000001	#	Query	#	#	BEGINmaster-bin.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin.000001	#	Write_rows	#	#	master-bin.000001	#	Query	#	#	COMMITmaster-bin.000001	#	Query	#	#	use `mysqltest`; drop table `t1`reset master;reset master;use test;insert into t2 values (1,2);drop database mysqltest;create table t1 (a int primary key) engine=ndb;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	BEGINmaster-bin1.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Table_map	#	#	test.t2master-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Query	#	#	COMMITmaster-bin1.000001	#	Query	#	#	drop database mysqltestmaster-bin1.000001	#	Query	#	#	use `test`; create table t1 (a int primary key) engine=ndbdrop table t2;reset master;reset master;CREATE LOGFILE GROUP lg1ADD UNDOFILE 'undofile.dat'INITIAL_SIZE 16MUNDO_BUFFER_SIZE = 1MENGINE=NDB;ALTER LOGFILE GROUP lg1ADD UNDOFILE 'undofile02.dat'INITIAL_SIZE = 4M ENGINE=NDB;CREATE TABLESPACE ts1ADD DATAFILE 'datafile.dat'USE LOGFILE GROUP lg1INITIAL_SIZE 12MENGINE NDB;ALTER TABLESPACE ts1ADD DATAFILE 'datafile02.dat'INITIAL_SIZE = 4M ENGINE=NDB;ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB;ALTER TABLESPACE ts1 DROP DATAFILE 'datafile02.dat' ENGINE = NDB;DROP TABLESPACE ts1 ENGINE = NDB;DROP LOGFILE GROUP lg1 ENGINE =NDB;drop table t1;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	CREATE LOGFILE GROUP lg1ADD UNDOFILE 'undofile.dat'INITIAL_SIZE 16MUNDO_BUFFER_SIZE = 1MENGINE=NDBmaster-bin1.000001	#	Query	#	#	ALTER LOGFILE GROUP lg1ADD UNDOFILE 'undofile02.dat'INITIAL_SIZE = 4M ENGINE=NDBmaster-bin1.000001	#	Query	#	#	CREATE TABLESPACE ts1ADD DATAFILE 'datafile.dat'USE LOGFILE GROUP lg1INITIAL_SIZE 12MENGINE NDBmaster-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1ADD DATAFILE 'datafile02.dat'INITIAL_SIZE = 4M ENGINE=NDBmaster-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDBmaster-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1 DROP DATAFILE 'datafile02.dat' ENGINE = NDBmaster-bin1.000001	#	Query	#	#	DROP TABLESPACE ts1 ENGINE = NDBmaster-bin1.000001	#	Query	#	#	DROP LOGFILE GROUP lg1 ENGINE =NDBmaster-bin1.000001	#	Query	#	#	BEGINmaster-bin1.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Query	#	#	COMMITmaster-bin1.000001	#	Query	#	#	use `test`; drop table `t1`

ndb_binlog_ddl_multi.result - 源码说明

本页面展示了「开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip」中的 ndb_binlog_ddl_multi.result 源码文件，采用 RESULT 编程语言编写，共 126 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与MySQL相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?