ps_7ndb.result

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

insert into t2 (b,a) 
select @duplicate, sum(first.a) from t1 first, t1 second
where first.a <> @5 and second.b = first.b
and second.b <> @five
group by second.b
having sum(second.a) > @2
union
select b, a + @100 from t1
where (a,b) in ( select sqrt(a+@1)+CAST(@float AS signed),b 
from t1);
affected rows: 3
info: Records: 3  Duplicates: 0  Warnings: 0
select a,b from t2 order by a ;
a	b
3	duplicate 
4	duplicate 
103	three
delete from t2 ;
prepare stmt1 from ' insert into t2 (b,a) 
select ?, sum(first.a)
  from t1 first, t1 second 
  where first.a <> ? and second.b = first.b and second.b <> ?
  group by second.b
  having sum(second.a) > ?
union
select b, a + ? from t1
  where (a,b) in ( select sqrt(a+?)+CAST(? AS signed),b 
                 from t1 ) ' ;
execute stmt1 using @duplicate, @5, @five, @2, @100, @1, @float ;
affected rows: 3
info: Records: 3  Duplicates: 0  Warnings: 0
select a,b from t2 order by a ;
a	b
3	duplicate 
4	duplicate 
103	three
drop table t2;
drop table if exists t5 ;
set @arg01= 8;
set @arg02= 8.0;
set @arg03= 80.00000000000e-1;
set @arg04= 'abc' ;
set @arg05= CAST('abc' as binary) ;
set @arg06= '1991-08-05' ;
set @arg07= CAST('1991-08-05' as date);
set @arg08= '1991-08-05 01:01:01' ;
set @arg09= CAST('1991-08-05 01:01:01' as datetime) ;
set @arg10= unix_timestamp('1991-01-01 01:01:01');
set @arg11= YEAR('1991-01-01 01:01:01');
set @arg12= 8 ;
set @arg12= NULL ;
set @arg13= 8.0 ;
set @arg13= NULL ;
set @arg14= 'abc';
set @arg14= NULL ;
set @arg15= CAST('abc' as binary) ;
set @arg15= NULL ;
create table t5 as select
8                           as const01, @arg01 as param01,
8.0                         as const02, @arg02 as param02,
80.00000000000e-1           as const03, @arg03 as param03,
'abc'                       as const04, @arg04 as param04,
CAST('abc' as binary)       as const05, @arg05 as param05,
'1991-08-05'                as const06, @arg06 as param06,
CAST('1991-08-05' as date)  as const07, @arg07 as param07,
'1991-08-05 01:01:01'       as const08, @arg08 as param08,
CAST('1991-08-05 01:01:01'  as datetime) as const09, @arg09 as param09,
unix_timestamp('1991-01-01 01:01:01')    as const10, @arg10 as param10,
YEAR('1991-01-01 01:01:01') as const11, @arg11 as param11, 
NULL                        as const12, @arg12 as param12,
@arg13 as param13,
@arg14 as param14,
@arg15 as param15;
show create table t5 ;
Table	Create Table
t5	CREATE TABLE `t5` (
  `const01` bigint(1) NOT NULL default '0',
  `param01` bigint(20) default NULL,
  `const02` decimal(2,1) unsigned NOT NULL default '0.0',
  `param02` decimal(65,30) default NULL,
  `const03` double NOT NULL default '0',
  `param03` double default NULL,
  `const04` varchar(3) NOT NULL default '',
  `param04` longtext,
  `const05` varbinary(3) NOT NULL default '',
  `param05` longblob,
  `const06` varchar(10) NOT NULL default '',
  `param06` longtext,
  `const07` date default NULL,
  `param07` longblob,
  `const08` varchar(19) NOT NULL default '',
  `param08` longtext,
  `const09` datetime default NULL,
  `param09` longblob,
  `const10` int(10) NOT NULL default '0',
  `param10` bigint(20) default NULL,
  `const11` int(4) default NULL,
  `param11` bigint(20) default NULL,
  `const12` binary(0) default NULL,
  `param12` bigint(20) default NULL,
  `param13` decimal(65,30) default NULL,
  `param14` longtext,
  `param15` longblob
) ENGINE=MyISAM DEFAULT CHARSET=latin1
select * from t5 ;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def	test	t5	t5	const01	const01	8	1	1	N	32769	0	63
def	test	t5	t5	param01	param01	8	20	1	Y	32768	0	63
def	test	t5	t5	const02	const02	246	3	3	N	33	1	63
def	test	t5	t5	param02	param02	246	67	32	Y	0	30	63
def	test	t5	t5	const03	const03	5	17	1	N	32769	31	63
def	test	t5	t5	param03	param03	5	23	1	Y	32768	31	63
def	test	t5	t5	const04	const04	253	3	3	N	1	0	8
def	test	t5	t5	param04	param04	252	4294967295	3	Y	16	0	8
def	test	t5	t5	const05	const05	253	3	3	N	129	0	63
def	test	t5	t5	param05	param05	252	4294967295	3	Y	144	0	63
def	test	t5	t5	const06	const06	253	10	10	N	1	0	8
def	test	t5	t5	param06	param06	252	4294967295	10	Y	16	0	8
def	test	t5	t5	const07	const07	10	10	10	Y	128	0	63
def	test	t5	t5	param07	param07	252	4294967295	10	Y	144	0	63
def	test	t5	t5	const08	const08	253	19	19	N	1	0	8
def	test	t5	t5	param08	param08	252	4294967295	19	Y	16	0	8
def	test	t5	t5	const09	const09	12	19	19	Y	128	0	63
def	test	t5	t5	param09	param09	252	4294967295	19	Y	144	0	63
def	test	t5	t5	const10	const10	3	10	9	N	32769	0	63
def	test	t5	t5	param10	param10	8	20	9	Y	32768	0	63
def	test	t5	t5	const11	const11	3	4	4	Y	32768	0	63
def	test	t5	t5	param11	param11	8	20	4	Y	32768	0	63
def	test	t5	t5	const12	const12	254	0	0	Y	128	0	63
def	test	t5	t5	param12	param12	8	20	0	Y	32768	0	63
def	test	t5	t5	param13	param13	246	67	0	Y	0	30	63
def	test	t5	t5	param14	param14	252	4294967295	0	Y	16	0	8
def	test	t5	t5	param15	param15	252	4294967295	0	Y	144	0	63
const01	8
param01	8
const02	8.0
param02	8.000000000000000000000000000000
const03	8
param03	8
const04	abc
param04	abc
const05	abc
param05	abc
const06	1991-08-05
param06	1991-08-05
const07	1991-08-05
param07	1991-08-05
const08	1991-08-05 01:01:01
param08	1991-08-05 01:01:01
const09	1991-08-05 01:01:01
param09	1991-08-05 01:01:01
const10	662680861
param10	662680861
const11	1991
param11	1991
const12	NULL
param12	NULL
param13	NULL
param14	NULL
param15	NULL
drop table t5 ;
test_sequence
------ data type conversion tests ------
delete from t1 ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
insert into t1 values (3,'three');
insert into t1 values (4,'four');
commit ;
delete from t9 ;
insert into t9
set c1= 1, c2= 1, c3= 1, c4= 1, c5= 1, c6= 1, c7= 1, c8= 1, c9= 1,
c10= 1, c11= 1, c12 = 1,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=true, c20= 'a', c21= '123456789a', 
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='one', c32= 'monday';
insert into t9
set c1= 9, c2= 9, c3= 9, c4= 9, c5= 9, c6= 9, c7= 9, c8= 9, c9= 9,
c10= 9, c11= 9, c12 = 9,
c13= '2004-02-29', c14= '2004-02-29 11:11:11', c15= '2004-02-29 11:11:11',
c16= '11:11:11', c17= '2004',
c18= 1, c19=false, c20= 'a', c21= '123456789a', 
c22= '123456789a123456789b123456789c', c23= 'tinyblob', c24= 'tinytext',
c25= 'blob', c26= 'text', c27= 'mediumblob', c28= 'mediumtext',
c29= 'longblob', c30= 'longtext', c31='two', c32= 'tuesday';
commit ;
insert into t9 set c1= 0, c15= '1991-01-01 01:01:01' ;
select * from t9 order by c1 ;
c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15	c16	c17	c18	c19	c20	c21	c22	c23	c24	c25	c26	c27	c28	c29	c30	c31	c32
0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
9	9	9	9	9	9	9	9	9	9	9.0000	9.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	0	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	two	tuesday
test_sequence
------ select @parameter:= column ------
prepare full_info from "select @arg01, @arg02, @arg03, @arg04,
       @arg05, @arg06, @arg07, @arg08,
       @arg09, @arg10, @arg11, @arg12,
       @arg13, @arg14, @arg15, @arg16,
       @arg17, @arg18, @arg19, @arg20,
       @arg21, @arg22, @arg23, @arg24,
       @arg25, @arg26, @arg27, @arg28,
       @arg29, @arg30, @arg31, @arg32" ;
select @arg01:=  c1, @arg02:=  c2, @arg03:=  c3, @arg04:=  c4,
@arg05:=  c5, @arg06:=  c6, @arg07:=  c7, @arg08:=  c8,
@arg09:=  c9, @arg10:= c10, @arg11:= c11, @arg12:= c12,
@arg13:= c13, @arg14:= c14, @arg15:= c15, @arg16:= c16,
@arg17:= c17, @arg18:= c18, @arg19:= c19, @arg20:= c20,
@arg21:= c21, @arg22:= c22, @arg23:= c23, @arg24:= c24,
@arg25:= c25, @arg26:= c26, @arg27:= c27, @arg28:= c28,
@arg29:= c29, @arg30:= c30, @arg31:= c31, @arg32:= c32
from t9 where c1= 1 ;
@arg01:=  c1	@arg02:=  c2	@arg03:=  c3	@arg04:=  c4	@arg05:=  c5	@arg06:=  c6	@arg07:=  c7	@arg08:=  c8	@arg09:=  c9	@arg10:= c10	@arg11:= c11	@arg12:= c12	@arg13:= c13	@arg14:= c14	@arg15:= c15	@arg16:= c16	@arg17:= c17	@arg18:= c18	@arg19:= c19	@arg20:= c20	@arg21:= c21	@arg22:= c22	@arg23:= c23	@arg24:= c24	@arg25:= c25	@arg26:= c26	@arg27:= c27	@arg28:= c28	@arg29:= c29	@arg30:= c30	@arg31:= c31	@arg32:= c32
1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
execute full_info ;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					@arg01	253	20	1	Y	128	0	63
def					@arg02	253	20	1	Y	128	0	63
def					@arg03	253	20	1	Y	128	0	63
def					@arg04	253	20	1	Y	128	0	63
def					@arg05	253	20	1	Y	128	0	63
def					@arg06	253	20	1	Y	128	0	63
def					@arg07	253	23	1	Y	128	31	63
def					@arg08	253	23	1	Y	128	31	63
def					@arg09	253	23	1	Y	128	31	63
def					@arg10	253	23	1	Y	128	31	63
def					@arg11	253	67	6	Y	128	30	63
def					@arg12	253	67	6	Y	128	30	63
def					@arg13	253	8192	10	Y	128	31	63
def					@arg14	253	8192	19	Y	128	31	63
def					@arg15	253	8192	19	Y	128	31	63
def					@arg16	253	8192	8	Y	128	31	63
def					@arg17	253	20	4	Y	128	0	63
def					@arg18	253	20	1	Y	128	0	63
def					@arg19	253	20	1	Y	128	0	63
def					@arg20	253	8192	1	Y	0	31	8
def					@arg21	253	8192	10	Y	0	31	8
def					@arg22	253	8192	30	Y	0	31	8
def					@arg23	253	8192	8	Y	128	31	63
def					@arg24	253	8192	8	Y	0	31	8
def					@arg25	253	8192	4	Y	128	31	63
def					@arg26	253	8192	4	Y	0	31	8
def					@arg27	253	8192	10	Y	128	31	63
def					@arg28	253	8192	10	Y	0	31	8
def					@arg29	253	8192	8	Y	128	31	63
def					@arg30	253	8192	8	Y	0	31	8
def					@arg31	253	8192	3	Y	0	31	8
def					@arg32	253	8192	6	Y	0	31	8
@arg01	@arg02	@arg03	@arg04	@arg05	@arg06	@arg07	@arg08	@arg09	@arg10	@arg11	@arg12	@arg13	@arg14	@arg15	@arg16	@arg17	@arg18	@arg19	@arg20	@arg21	@arg22	@arg23	@arg24	@arg25	@arg26	@arg27	@arg28	@arg29	@arg30	@arg31	@arg32
1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
select @arg01:=  c1, @arg02:=  c2, @arg03:=  c3, @arg04:=  c4,
@arg05:=  c5, @arg06:=  c6, @arg07:=  c7, @arg08:=  c8,
@arg09:=  c9, @arg10:= c10, @arg11:= c11, @arg12:= c12,
@arg13:= c13, @arg14:= c14, @arg15:= c15, @arg16:= c16,
@arg17:= c17, @arg18:= c18, @arg19:= c19, @arg20:= c20,
@arg21:= c21, @arg22:= c22, @arg23:= c23, @arg24:= c24,
@arg25:= c25, @arg26:= c26, @arg27:= c27, @arg28:= c28,
@arg29:= c29, @arg30:= c30, @arg31:= c31, @arg32:= c32
from t9 where c1= 0 ;
@arg01:=  c1	@arg02:=  c2	@arg03:=  c3	@arg04:=  c4	@arg05:=  c5	@arg06:=  c6	@arg07:=  c7	@arg08:=  c8	@arg09:=  c9	@arg10:= c10	@arg11:= c11	@arg12:= c12	@arg13:= c13	@arg14:= c14	@arg15:= c15	@arg16:= c16	@arg17:= c17	@arg18:= c18	@arg19:= c19	@arg20:= c20	@arg21:= c21	@arg22:= c22	@arg23:= c23	@arg24:= c24	@arg25:= c25	@arg26:= c26	@arg27:= c27	@arg28:= c28	@arg29:= c29	@arg30:= c30	@arg31:= c31	@arg32:= c32
0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
execute full_info ;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					@arg01	253	20	1	Y	128	0	63
def					@arg02	253	20	0	Y	128	0	63
def					@arg03	253	20	0	Y	128	0	63
def					@arg04	253	20	0	Y	128	0	63
def					@arg05	253	20	0	Y	128	0	63
def					@arg06	253	20	0	Y	128	0	63
def					@arg07	253	23	0	Y	128	31	63
def					@arg08	253	23	0	Y	128	31	63
def					@arg09	253	23	0	Y	128	31	63
def					@arg10	253	23	0	Y	128	31	63
def					@arg11	253	67	0	Y	128	30	63
def					@arg12	253	67	0	Y	128	30	63
def					@arg13	253	8192	0	Y	128	31	63
def					@arg14	253	8192	0	Y	128	31	63
def					@arg15	253	8192	19	Y	128	31	63
def					@arg16	253	8192	0	Y	128	31	63
def					@arg17	253	20	0	Y	128	0	63
def					@arg18	253	20	0	Y	128	0	63
def					@arg19	253	20	0	Y	128	0	63
def					@arg20	253	8192	0	Y	0	31	8
def					@arg21	253	8192	0	Y	0	31	8
def					@arg22	253	8192	0	Y	0	31	8
def					@arg23	253	8192	0	Y	128	31	63
def					@arg24	253	8192	0	Y	0	31	8
def					@arg25	253	8192	0	Y	128	31	63
def					@arg26	253	8192	0	Y	0	31	8
def					@arg27	253	8192	0	Y	128	31	63
def					@arg28	253	8192	0	Y	0	31	8
def					@arg29	253	8192	0	Y	128	31	63
def					@arg30	253	8192	0	Y	0	31	8
def					@arg31	253	8192	0	Y	0	31	8
def					@arg32	253	8192	0	Y	0	31	8
@arg01	@arg02	@arg03	@arg04	@arg05	@arg06	@arg07	@arg08	@arg09	@arg10	@arg11	@arg12	@arg13	@arg14	@arg15	@arg16	@arg17	@arg18	@arg19	@arg20	@arg21	@arg22	@arg23	@arg24	@arg25	@arg26	@arg27	@arg28	@arg29	@arg30	@arg31	@arg32
0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
prepare stmt1 from "select 
       @arg01:=  c1, @arg02:=  c2, @arg03:=  c3, @arg04:=  c4,
       @arg05:=  c5, @arg06:=  c6, @arg07:=  c7, @arg08:=  c8,
       @arg09:=  c9, @arg10:= c10, @arg11:= c11, @arg12:= c12,
       @arg13:= c13, @arg14:= c14, @arg15:= c15, @arg16:= c16,
       @arg17:= c17, @arg18:= c18, @arg19:= c19, @arg20:= c20,
       @arg21:= c21, @arg22:= c22, @arg23:= c23, @arg24:= c24,
       @arg25:= c25, @arg26:= c26, @arg27:= c27, @arg28:= c28,
       @arg29:= c29, @arg30:= c30, @arg31:= c31, @arg32:= c32
from t9 where c1= ?" ;
set @my_key= 1 ;
execute stmt1 using @my_key ;
@arg01:=  c1	@arg02:=  c2	@arg03:=  c3	@arg04:=  c4	@arg05:=  c5	@arg06:=  c6	@arg07:=  c7	@arg08:=  c8	@arg09:=  c9	@arg10:= c10	@arg11:= c11	@arg12:= c12	@arg13:= c13	@arg14:= c14	@arg15:= c15	@arg16:= c16	@arg17:= c17	@arg18:= c18	@arg19:= c19	@arg20:= c20	@arg21:= c21	@arg22:= c22	@arg23:= c23	@arg24:= c24	@arg25:= c25	@arg26:= c26	@arg27:= c27	@arg28:= c28	@arg29:= c29	@arg30:= c30	@arg31:= c31	@arg32:= c32
1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
execute full_info ;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					@arg01	253	20	1	Y	128	0	63
def					@arg02	253	20	1	Y	128	0	63
def					@arg03	253	20	1	Y	128	0	63
def					@arg04	253	20	1	Y	128	0	63
def					@arg05	253	20	1	Y	128	0	63
def					@arg06	253	20	1	Y	128	0	63
def					@arg07	253	23	1	Y	128	31	63
def					@arg08	253	23	1	Y	128	31	63
def					@arg09	253	23	1	Y	128	31	63
def					@arg10	253	23	1	Y	128	31	63
def					@arg11	253	67	6	Y	128	30	63
def					@arg12	253	67	6	Y	128	30	63
def					@arg13	253	8192	10	Y	128	31	63
def					@arg14	253	8192	19	Y	128	31	63
def					@arg15	253	8192	19	Y	128	31	63
def					@arg16	253	8192	8	Y	128	31	63
def					@arg17	253	20	4	Y	128	0	63
def					@arg18	253	20	1	Y	128	0	63
def					@arg19	253	20	1	Y	128	0	63
def					@arg20	253	8192	1	Y	0	31	8
def					@arg21	253	8192	10	Y	0	31	8
def					@arg22	253	8192	30	Y	0	31	8
def					@arg23	253	8192	8	Y	128	31	63
def					@arg24	253	8192	8	Y	0	31	8
def					@arg25	253	8192	4	Y	128	31	63
def					@arg26	253	8192	4	Y	0	31	8
def					@arg27	253	8192	10	Y	128	31	63
def					@arg28	253	8192	10	Y	0	31	8
def					@arg29	253	8192	8	Y	128	31	63
def					@arg30	253	8192	8	Y	0	31	8
def					@arg31	253	8192	3	Y	0	31	8
def					@arg32	253	8192	6	Y	0	31	8
@arg01	@arg02	@arg03	@arg04	@arg05	@arg06	@arg07	@arg08	@arg09	@arg10	@arg11	@arg12	@arg13	@arg14	@arg15	@arg16	@arg17	@arg18	@arg19	@arg20	@arg21	@arg22	@arg23	@arg24	@arg25	@arg26	@arg27	@arg28	@arg29	@arg30	@arg31	@arg32
1	1	1	1	1	1	1	1	1	1	1.0000	1.0000	2004-02-29	2004-02-29 11:11:11	2004-02-29 11:11:11	11:11:11	2004	1	1	a	123456789a	123456789a123456789b123456789c	tinyblob	tinytext	blob	text	mediumblob	mediumtext	longblob	longtext	one	monday
set @my_key= 0 ;
execute stmt1 using @my_key ;
@arg01:=  c1	@arg02:=  c2	@arg03:=  c3	@arg04:=  c4	@arg05:=  c5	@arg06:=  c6	@arg07:=  c7	@arg08:=  c8	@arg09:=  c9	@arg10:= c10	@arg11:= c11	@arg12:= c12	@arg13:= c13	@arg14:= c14	@arg15:= c15	@arg16:= c16	@arg17:= c17	@arg18:= c18	@arg19:= c19	@arg20:= c20	@arg21:= c21	@arg22:= c22	@arg23:= c23	@arg24:= c24	@arg25:= c25	@arg26:= c26	@arg27:= c27	@arg28:= c28	@arg29:= c29	@arg30:= c30	@arg31:= c31	@arg32:= c32
0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
execute full_info ;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					@arg01	253	20	1	Y	128	0	63
def					@arg02	253	20	0	Y	128	0	63
def					@arg03	253	20	0	Y	128	0	63
def					@arg04	253	20	0	Y	128	0	63
def					@arg05	253	20	0	Y	128	0	63
def					@arg06	253	20	0	Y	128	0	63
def					@arg07	253	23	0	Y	128	31	63
def					@arg08	253	23	0	Y	128	31	63
def					@arg09	253	23	0	Y	128	31	63
def					@arg10	253	23	0	Y	128	31	63
def					@arg11	253	67	0	Y	128	30	63
def					@arg12	253	67	0	Y	128	30	63
def					@arg13	253	8192	0	Y	128	31	63
def					@arg14	253	8192	0	Y	128	31	63
def					@arg15	253	8192	19	Y	128	31	63
def					@arg16	253	8192	0	Y	128	31	63
def					@arg17	253	20	0	Y	128	0	63
def					@arg18	253	20	0	Y	128	0	63
def					@arg19	253	20	0	Y	128	0	63
def					@arg20	253	8192	0	Y	0	31	8
def					@arg21	253	8192	0	Y	0	31	8
def					@arg22	253	8192	0	Y	0	31	8
def					@arg23	253	8192	0	Y	128	31	63
def					@arg24	253	8192	0	Y	0	31	8
def					@arg25	253	8192	0	Y	128	31	63
def					@arg26	253	8192	0	Y	0	31	8
def					@arg27	253	8192	0	Y	128	31	63
def					@arg28	253	8192	0	Y	0	31	8
def					@arg29	253	8192	0	Y	128	31	63
def					@arg30	253	8192	0	Y	0	31	8
def					@arg31	253	8192	0	Y	0	31	8
def					@arg32	253	8192	0	Y	0	31	8
@arg01	@arg02	@arg03	@arg04	@arg05	@arg06	@arg07	@arg08	@arg09	@arg10	@arg11	@arg12	@arg13	@arg14	@arg15	@arg16	@arg17	@arg18	@arg19	@arg20	@arg21	@arg22	@arg23	@arg24	@arg25	@arg26	@arg27	@arg28	@arg29	@arg30	@arg31	@arg32
0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1991-01-01 01:01:01	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
prepare stmt1 from "select ? := c1 from t9 where c1= 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 ':= c1 from t9 where c1= 1' at line 1
test_sequence
------ select column, .. into @parm,.. ------
select c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12,
c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24,
c25, c26, c27, c28, c29, c30, c31, c32
into @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07, @arg08,
@arg09, @arg10, @arg11, @arg12, @arg13, @arg14, @arg15, @arg16,
@arg17, @arg18, @arg19, @arg20, @arg21, @arg22, @arg23, @arg24,
@arg25, @arg26, @arg27, @arg28, @arg29, @arg30, @arg31, @arg32
from t9 where c1= 1 ;
execute full_info ;
Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
def					@arg01	253	20	1	Y	128	0	63
def					@arg02	253	20	1	Y	128	0	63
def					@arg03	253	20	1	Y	128	0	63
def					@arg04	253	20	1	Y	128	0	63
def					@arg05	253	20	1	Y	128	0	63
def					@arg06	253	20	1	Y	128	0	63
def					@arg07	253	23	1	Y	128	31	63
def					@arg08	253	23	1	Y	128	31	63
def					@arg09	253	23	1	Y	128	31	63
def					@arg10	253	23	1	Y	128	31	63
def					@arg11	253	67	6	Y	128	30	63
def					@arg12	253	67	6	Y	128	30	63
def					@arg13	253	8192	10	Y	128	31	63
def					@arg14	253	8192	19	Y	128	31	63
def					@arg15	253	8192	19	Y	128	31	63
def					@arg16	253	8192	8	Y	128	31	63
def					@arg17	253