📄 rpl_loadfile.result

📁 开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

💻 RESULT

字号:

stop slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;reset master;reset slave;drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;start slave;DROP PROCEDURE IF EXISTS test.p1;DROP TABLE IF EXISTS test.t1;CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a));INSERT INTO test.t1  VALUES(1,'test');UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=1;create procedure test.p1()beginINSERT INTO test.t1  VALUES(2,'test');UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;end|CALL test.p1();SELECT * FROM test.t1 ORDER BY blob_column;a	blob_column1	abaseabasedabasementabasementsabasesabashabashedabashesabashingabasingabateabatedabatementabatementsabaterabatesabatingAbbaabbeabbeyabbeysabbotabbotsAbbottabbreviateabbreviatedabbreviatesabbreviatingabbreviationabbreviationsAbbyabdomenabdomensabdominalabductabductedabductionabductionsabductorabductorsabductsAbeabedAbelAbelianAbelsonAberdeenAbernathyaberrantaberration2	abaseabasedabasementabasementsabasesabashabashedabashesabashingabasingabateabatedabatementabatementsabaterabatesabatingAbbaabbeabbeyabbeysabbotabbotsAbbottabbreviateabbreviatedabbreviatesabbreviatingabbreviationabbreviationsAbbyabdomenabdomensabdominalabductabductedabductionabductionsabductorabductorsabductsAbeabedAbelAbelianAbelsonAberdeenAbernathyaberrantaberrationSELECT * FROM test.t1 ORDER BY blob_column;a	blob_column1	abaseabasedabasementabasementsabasesabashabashedabashesabashingabasingabateabatedabatementabatementsabaterabatesabatingAbbaabbeabbeyabbeysabbotabbotsAbbottabbreviateabbreviatedabbreviatesabbreviatingabbreviationabbreviationsAbbyabdomenabdomensabdominalabductabductedabductionabductionsabductorabductorsabductsAbeabedAbelAbelianAbelsonAberdeenAbernathyaberrantaberration2	abaseabasedabasementabasementsabasesabashabashedabashesabashingabasingabateabatedabatementabatementsabaterabatesabatingAbbaabbeabbeyabbeysabbotabbotsAbbottabbreviateabbreviatedabbreviatesabbreviatingabbreviationabbreviationsAbbyabdomenabdomensabdominalabductabductedabductionabductionsabductorabductorsabductsAbeabedAbelAbelianAbelsonAberdeenAbernathyaberrantaberrationDROP PROCEDURE IF EXISTS test.p1;DROP TABLE test.t1;

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -