ps_1general.result

这是linux下运行的mysql软件包,可用于linux 下安装 php + mysql + apach 的网络配置

prepare stmt4 from ' show columns from t2 where field in (select ?) ';
SET @arg00="a";
execute stmt4 using @arg00;
Field	Type	Null	Key	Default	Extra
a	int(11)	NO	PRI		
SET @arg00="b";
execute stmt4 using @arg00;
Field	Type	Null	Key	Default	Extra
b	char(10)	YES		NULL	
SET @arg00=1;
execute stmt4 using @arg00;
Field	Type	Null	Key	Default	Extra
prepare stmt4 from ' show columns from t2 from test like ''a%'' ';
execute stmt4;
Field	Type	Null	Key	Default	Extra
a	int(11)	NO	PRI		
create index t2_idx on t2(b);
prepare stmt4 from ' show index from t2 from test ';
execute stmt4;
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Comment
t2	0	PRIMARY	1	a	A	0	NULL	NULL		BTREE	
t2	1	t2_idx	1	b	A	NULL	NULL	NULL	YES	BTREE	
prepare stmt4 from ' show table status from test like ''t2%'' ';
execute stmt4;
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t2	MyISAM	10	Fixed	0	0	0	#	1024	0	NULL	#	#	#	latin1_swedish_ci	NULL		
prepare stmt4 from ' show table status from test like ''t9%'' ';
execute stmt4;
Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment
t9	MyISAM	10	Dynamic	2	216	432	#	2048	0	NULL	#	#	#	latin1_swedish_ci	NULL		
prepare stmt4 from ' show status like ''Threads_running'' ';
execute stmt4;
Variable_name	Value
Threads_running	1
prepare stmt4 from ' show variables like ''sql_mode'' ';
execute stmt4;
Variable_name	Value
sql_mode	
prepare stmt4 from ' show engine bdb logs ';
execute stmt4;
prepare stmt4 from ' show grants for user ';
prepare stmt4 from ' show create table t2 ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt4 from ' show master status ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt4 from ' show master logs ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt4 from ' show slave status ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt4 from ' show warnings limit 20 ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt4 from ' show errors limit 20 ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt4 from ' show storage engines ';
execute stmt4;
Engine	Support	Comment
MyISAM	YES/NO	Default engine as of MySQL 3.23 with great performance
MEMORY	YES/NO	Hash based, stored in memory, useful for temporary tables
InnoDB	YES/NO	Supports transactions, row-level locking, and foreign keys
BerkeleyDB	YES/NO	Supports transactions and page-level locking
BLACKHOLE	YES/NO	/dev/null storage engine (anything you write to it disappears)
EXAMPLE	YES/NO	Example storage engine
ARCHIVE	YES/NO	Archive storage engine
CSV	YES/NO	CSV storage engine
ndbcluster	YES/NO	Clustered, fault-tolerant, memory-based tables
FEDERATED	YES/NO	Federated MySQL storage engine
MRG_MYISAM	YES/NO	Collection of identical MyISAM tables
ISAM	YES/NO	Obsolete storage engine
drop table if exists t5;
prepare stmt1 from ' drop table if exists t5 ' ;
execute stmt1 ;
Warnings:
Note	1051	Unknown table 't5'
prepare stmt1 from ' drop table t5 ' ;
execute stmt1 ;
ERROR 42S02: Unknown table 't5'
prepare stmt1 from ' SELECT @@version ' ;
execute stmt1 ;
@@version
<version>
prepare stmt_do from ' do @var:=  (1 in (select a from t1)) ' ;
prepare stmt_set from ' set @var= (1 in (select a from t1)) ' ;
execute stmt_do ;
content of @var is:
1
execute stmt_set ;
content of @var is:
1
execute stmt_do ;
content of @var is:
1
execute stmt_set ;
content of @var is:
1
execute stmt_do ;
content of @var is:
1
execute stmt_set ;
content of @var is:
1
drop table if exists t5 ;
create table t5 (a int) ;
prepare stmt_do from ' do @var:=  (1 in (select a from t5)) ' ;
prepare stmt_set from ' set @var= (1 in (select a from t5)) ' ;
execute stmt_do ;
content of @var is:
0
execute stmt_set ;
content of @var is:
0
execute stmt_do ;
content of @var is:
0
execute stmt_set ;
content of @var is:
0
execute stmt_do ;
content of @var is:
0
execute stmt_set ;
content of @var is:
0
drop table t5 ;
deallocate prepare stmt_do ;
deallocate prepare stmt_set ;
prepare stmt1 from ' prepare stmt2 from '' select 1 ''  ' ;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' select 1 '' at line 1
prepare stmt1 from ' execute stmt2 ' ;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stmt2' at line 1
prepare stmt1 from ' deallocate prepare never_prepared ' ;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'never_prepared' at line 1
prepare stmt4 from ' use test ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt3 from ' create database mysqltest ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
create database mysqltest ;
prepare stmt3 from ' drop database mysqltest ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
drop database mysqltest ;
prepare stmt3 from ' describe t2 ';
execute stmt3;
Field	Type	Null	Key	Default	Extra
a	int(11)	NO	PRI		
b	char(10)	YES	MUL	NULL	
drop table t2 ;
execute stmt3;
ERROR 42S02: Table 'test.t2' doesn't exist
prepare stmt3 from ' lock tables t1 read ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt3 from ' unlock tables ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' load data infile ''data.txt''
into table t1 fields terminated by ''\t'' ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' select * into outfile ''data.txt'' from t1 ';
execute stmt1 ;
prepare stmt1 from ' optimize table t1 ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' analyze table t1 ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' checksum table t1 ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' repair table t1 ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' restore table t1 from ''data.txt'' ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' handler t1 open ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt3 from ' commit ' ;
prepare stmt3 from ' rollback ' ;
prepare stmt4 from ' SET sql_mode=ansi ';
execute stmt4;
select 'a' || 'b' ;
'a' || 'b'
ab
prepare stmt4 from ' SET sql_mode="" ';
execute stmt4;
select '2' || '3' ;
'2' || '3'
1
prepare stmt5 from ' select ''2'' || ''3'' ' ;
execute stmt5;
'2' || '3'
1
SET sql_mode=ansi;
execute stmt5;
'2' || '3'
1
SET sql_mode="";
prepare stmt1 from ' flush local privileges ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' reset query cache ' ;
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' KILL 0 ';
ERROR HY000: This command is not supported in the prepared statement protocol yet
prepare stmt1 from ' explain select a from t1 order by b ';
execute stmt1;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					id	8	3	1	N	32929	0	63
def					select_type	253	19	6	N	1	31	8
def					table	253	64	2	Y	0	31	8
def					type	253	10	3	Y	0	31	8
def					possible_keys	253	4096	0	Y	0	31	8
def					key	253	64	0	Y	0	31	8
def					key_len	253	4096	0	Y	128	31	63
def					ref	253	1024	0	Y	0	31	8
def					rows	8	10	1	Y	32928	0	63
def					Extra	253	255	14	N	1	31	8
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	4	Using filesort
SET @arg00=1 ;
prepare stmt1 from ' explain select a from t1 where a > ? order by b ';
execute stmt1 using @arg00;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					id	8	3	1	N	32929	0	63
def					select_type	253	19	6	N	1	31	8
def					table	253	64	2	Y	0	31	8
def					type	253	10	5	Y	0	31	8
def					possible_keys	253	4096	7	Y	0	31	8
def					key	253	64	7	Y	0	31	8
def					key_len	253	4096	1	Y	128	31	63
def					ref	253	1024	0	Y	0	31	8
def					rows	8	10	1	Y	32928	0	63
def					Extra	253	255	27	N	1	31	8
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	3	Using where; Using filesort
drop table if exists t2;
create table t2 (id smallint, name varchar(20)) ;
prepare stmt1 from ' insert into t2 values(?, ?) ' ;
set @id= 9876 ;
set @arg00= 'MySQL - Open Source Database' ;
set @arg01= "'" ;
set @arg02= '"' ;
set @arg03= "my'sql'" ;
set @arg04= 'my"sql"' ;
insert into t2 values ( @id , @arg00 );
Warnings:
Warning	1265	Data truncated for column 'name' at row 1
insert into t2 values ( @id , @arg01 );
insert into t2 values ( @id , @arg02 );
insert into t2 values ( @id , @arg03 );
insert into t2 values ( @id , @arg04 );
prepare stmt1 from ' select * from t2 where id= ? and name= ? ';
execute stmt1 using @id, @arg00 ;
id	name
execute stmt1 using @id, @arg01 ;
id	name
9876	'
execute stmt1 using @id, @arg02 ;
id	name
9876	"
execute stmt1 using @id, @arg03 ;
id	name
9876	my'sql'
execute stmt1 using @id, @arg04 ;
id	name
9876	my"sql"
drop table t2;
test_sequence
------ create/drop/alter/rename tests ------
drop table if exists t2, t3;
prepare stmt_drop from ' drop table if exists t2 ' ;
execute stmt_drop;
prepare stmt_create from ' create table t2 (
                             a int primary key, b char(10)) ';
execute stmt_create;
prepare stmt3 from ' create table t3 like t2 ';