MySQL数据库

开发平台：
Visual C++

innobase.result：源码内容
							id	code	name
1	Tim
1	Monty
2	David
2	Erik
3	Sasha
3	Jeremy
4	Matt
id	code	name
1	Monty
2	David
2	Erik
3	Sasha
3	Jeremy
4	Matt
1	Sinisa
id	code	name
2	David
2	Erik
3	Sasha
3	Jeremy
4	Matt
1	Sinisa
1	Ralph
id	parent_id	level
102	2
102	2
102	2
id	parent_id	level
100	0
101	1
101	1
101	1
101	1
101	1
101	1
102	2
102	2
102	2
103	2
103	2
103	2
103	2
103	2
104	2
104	2
104	2
105	2
105	2
105	2
105	2
105	2
105	2
106	2
106	2
106	2
106	2
106	2
107	2
107	2
107	2
107	2
100	0
105	2
104	2
105	2
107	2
107	2
id	parent_id	level
100	0
101	1
101	1
101	1
101	1
101	1
101	1
102	2
102	2
102	2
103	2
103	2
103	2
103	2
103	2
104	2
104	2
104	2
105	2
105	2
105	2
105	2
105	2
105	2
106	2
106	2
106	2
106	2
106	2
107	2
107	2
107	2
107	2
100	0
105	2
104	2
105	2
107	2
107	2
id	parent_id	level
102	2
102	2
102	2
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	level	level	1	NULL	39	where used; Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	level	level	1	NULL	39	where used; Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ref	level	level	1	const	12	
level	id
1002
1003
1004
1005
1006
1007
level	id	parent_id
1002	101
1003	101
1004	101
1005	101
1006	101
1007	101
Table	Op	Msg_type	Msg_text
test.t1	optimize	error	The handler for the table doesn't support check/repair
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Comment
t1	0	PRIMARY	1	id	A	2	NULL	NULL	
t1	1	parent_id	1	parent_id	A	4	NULL	NULL	
t1	1	level	1	level	A	4	NULL	NULL	
gesuchnr	benutzer_id
1
1
Table	Op	Msg_type	Msg_text
test.t1	optimize	error	The handler for the table doesn't support check/repair
a
2
Table	Op	Msg_type	Msg_text
test.t1	check	error	The handler for the table doesn't support check/repair
a	b
testing
Table	Op	Msg_type	Msg_text
test.t1	analyze	error	The handler for the table doesn't support check/repair
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Comment
t1	1	skr	1	a	A	3	NULL	NULL	
a	b

n	after rollback
n	after commit
after commit
n	after commit
after commit
after commit
n
4
5
6
afterbegin_id	afterbegin_nom
hamdouni
afterrollback_id	afterrollback_nom
afterautocommit0_id	afterautocommit0_nom
mysql
afterrollback_id	afterrollback_nom
id	val
id	val
pippo	12
id	val
ID	NAME
Jochen
_userid
marc@anyware.co.uk
_userid
marc@anyware.co.uk
user_id	name	phone	ref_email	detail
sanjeev	29153373	sansh777@hotmail.com	xxx
shirish	2333604	shirish@yahoo.com	ddsds
sonali	323232	sonali@bolly.com	filmstar
user_id	name	phone	ref_email	detail
sanjeev	29153373	sansh777@hotmail.com	xxx
shirish	2333604	shirish@yahoo.com	ddsds
sonali	323232	sonali@bolly.com	filmstar
user_id	name	phone	ref_email	detail
sanjeev	29153373	sansh777@hotmail.com	xxx
shirish	2333604	shirish@yahoo.com	ddsds
sonali	323232	sonali@bolly.com	filmstar
shirish	2333604	shirish@yahoo.com	ddsds
user_id	name	phone	ref_email	detail
shirish	2333604	shirish@yahoo.com	ddsds
user_id	name	phone	ref_email	detail
sanjeev	29153373	sansh777@hotmail.com	xxx
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Comment
t1	0	PRIMARY	1	a	A	NULL	NULL	NULL	
t1	0	PRIMARY	2	b	A	0	NULL	NULL	
t1	0	b	1	b	A	0	NULL	NULL	
t1	0	c	1	c	A	0	NULL	NULL	
t1	1	a	1	a	A	NULL	NULL	NULL	
t1	1	a_2	1	a	A	NULL	NULL	NULL	
col1	col2
1
3
4
4
2
col1	col2
1
3
4
7
2
col1	col2	co3
1	0
3	0
4	0
7	0
2	0
col1	col2	co3
1	0
9	0
4	0
7	0
2	0
a	b
3
3
3
a	b
3
3
3
a	b
a	b
3
3
3
a	b
3
3
3
id	ggid	email	passwd
test1		xxx
id	ggid	email	passwd
test1		xxx
id	ggid	email	passwd
test2		yyy
id	ggid	email	passwd
this will work		
test2		this will work
id	ggid	email	passwd
this will work		
id	ggid	email	passwd
user_name	password	subscribed	user_id	quota	weight	access_date	access_time	approved	dummy_primary_key
user_0	somepassword	N	0	0	0	2000-09-07	23:06:59	2000-09-07 23:06:59	1
user_1	somepassword	Y	1	1	1	2000-09-07	23:06:59	2000-09-07 23:06:59	2
user_2	somepassword	N	2	2	1.4142135623731	2000-09-07	23:06:59	2000-09-07 23:06:59	3
user_3	somepassword	Y	3	3	1.7320508075689	2000-09-07	23:06:59	2000-09-07 23:06:59	4
user_4	somepassword	N	4	4	2	2000-09-07	23:06:59	2000-09-07 23:06:59	5
id	parent_id	level
102	2
102	2
102	2
id	parent_id	level
100	0
101	1
101	1
102	2
102	2
103	2
104	2
104	2
105	2
105	2
105	2
106	2
106	2
106	2
107	2
107	2
103	2
100	0
105	2
107	2
101	1
102	2
101	1
106	2
106	2
103	2
101	1
107	2
103	2
105	2
105	2
104	2
107	2
105	2
107	2
104	2
103	2
101	1
105	2
id	parent_id	level
100	0
101	1
101	1
102	2
102	2
103	2
104	2
104	2
105	2
105	2
105	2
106	2
106	2
106	2
107	2
107	2
103	2
100	0
105	2
107	2
101	1
102	2
101	1
106	2
106	2
103	2
101	1
107	2
103	2
105	2
105	2
104	2
107	2
105	2
107	2
104	2
103	2
101	1
105	2
id	parent_id	level
102	2
102	2
102	2
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ref	level	level	1	const	6	where used; Using index
level	id
1004
1005
1003
1007
1008
1006
level	id	parent_id
1004	101
1005	101
1003	101
1007	101
1008	101
1006	101
level	id
1003
1004
1005
1006
1007
1008
id	parent_id	level
100	0
102	2
102	2
103	2
104	2
104	2
105	2
105	2
105	2
106	2
106	2
106	2
107	2
107	2
103	2
100	0
105	2
107	2
102	2
106	2
106	2
103	2
107	2
103	2
105	2
105	2
104	2
107	2
105	2
107	2
104	2
103	2
105	2
count(*)
1
count(*)
1
count(*)
2
count(*)
1
count(*)
0
count(*)
1
count(*)
1
sca_pic
NULL
NULL
a
1
2
3
a
2
3
5
a	b
world	2
hello	1
Table	Op	Msg_type	Msg_text
test.t1	optimize	error	The handler for the table doesn't support check/repair
Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Comment
t1	0	PRIMARY	1	a	A	1	NULL	NULL	
i	j
2
i	j
2
MIN(B)	MAX(b)
1

						