id	code	name
1	1	Tim
2	1	Monty
3	2	David
4	2	Erik
5	3	Sasha
6	3	Jeremy
7	4	Matt
id	code	name
2	1	Monty
3	2	David
4	2	Erik
5	3	Sasha
6	3	Jeremy
7	4	Matt
8	1	Sinisa
id	code	name
3	2	David
4	2	Erik
5	3	Sasha
6	3	Jeremy
7	4	Matt
8	1	Sinisa
12	1	Ralph
id	parent_id	level
8	102	2
9	102	2
15	102	2
id	parent_id	level
1001	100	0
1002	101	1
1003	101	1
1004	101	1
1005	101	1
1006	101	1
1007	101	1
1008	102	2
1009	102	2
1015	102	2
1016	103	2
1017	103	2
1018	103	2
1019	103	2
1020	103	2
1021	104	2
1022	104	2
1024	104	2
1025	105	2
1026	105	2
1027	105	2
1028	105	2
1029	105	2
1030	105	2
1031	106	2
1032	106	2
1033	106	2
1034	106	2
1035	106	2
1036	107	2
1037	107	2
1038	107	2
1040	107	2
1157	100	0
1179	105	2
1183	104	2
1193	105	2
1202	107	2
1203	107	2
id	parent_id	level
1001	100	0
1002	101	1
1003	101	1
1004	101	1
1005	101	1
1006	101	1
1007	101	1
1008	102	2
1010	102	2
1015	102	2
1016	103	2
1017	103	2
1018	103	2
1019	103	2
1020	103	2
1021	104	2
1023	104	2
1024	104	2
1025	105	2
1026	105	2
1027	105	2
1028	105	2
1029	105	2
1030	105	2
1031	106	2
1032	106	2
1033	106	2
1034	106	2
1035	106	2
1036	107	2
1037	107	2
1039	107	2
1041	107	2
1158	100	0
1180	105	2
1184	104	2
1194	105	2
1202	107	2
1204	107	2
id	parent_id	level
1008	102	2
1010	102	2
1015	102	2
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ref	level	level	1	const	12	where used; Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ref	level	level	1	const	12	where used; Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ref	level	level	1	const	12	where used
level	id
1	1002
1	1003
1	1004
1	1005
1	1006
1	1007
level	id	parent_id
1	1002	101
1	1003	101
1	1004	101
1	1005	101
1	1006	101
1	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	87	NULL	NULL	
t1	1	parent_id	1	parent_id	A	43	NULL	NULL	
t1	1	level	1	level	A	8	NULL	NULL	
gesuchnr	benutzer_id
1	1
2	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	status	OK
a	b
2	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
1	
n	after rollback
n	after commit
4	after commit
n	after commit
4	after commit
5	after commit
n
4
5
6
afterbegin_id	afterbegin_nom
1	hamdouni
afterrollback_id	afterrollback_nom
afterautocommit0_id	afterautocommit0_nom
2	mysql
afterrollback_id	afterrollback_nom
id	val
id	val
pippo	12
id	val
ID	NAME
1	Jochen
_userid
marc@anyware.co.uk
_userid
marc@anyware.co.uk
user_id	name	phone	ref_email	detail
10292	sanjeev	29153373	sansh777@hotmail.com	xxx
10292	shirish	2333604	shirish@yahoo.com	ddsds
10292	sonali	323232	sonali@bolly.com	filmstar
user_id	name	phone	ref_email	detail
10292	sanjeev	29153373	sansh777@hotmail.com	xxx
10292	shirish	2333604	shirish@yahoo.com	ddsds
10292	sonali	323232	sonali@bolly.com	filmstar
user_id	name	phone	ref_email	detail
10292	sanjeev	29153373	sansh777@hotmail.com	xxx
10292	shirish	2333604	shirish@yahoo.com	ddsds
10292	sonali	323232	sonali@bolly.com	filmstar
10293	shirish	2333604	shirish@yahoo.com	ddsds
user_id	name	phone	ref_email	detail
10293	shirish	2333604	shirish@yahoo.com	ddsds
user_id	name	phone	ref_email	detail
10291	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	1
2	3
3	4
4	4
5	2
col1	col2
1	1
2	3
3	4
4	7
5	2
col1	col2	co3
1	1	0
2	3	0
3	4	0
4	7	0
5	2	0
col1	col2	co3
1	1	0
2	9	0
3	4	0
4	7	0
5	2	0
a	b
1	3
2	3
3	3
a	b
1	3
2	3
3	3
a	b
a	b
1	3
2	3
3	3
a	b
1	3
2	3
3	3
id	ggid	email	passwd
1	test1		xxx
id	ggid	email	passwd
1	test1		xxx
id	ggid	email	passwd
2	test2		yyy
id	ggid	email	passwd
1	this will work		
4	test2		this will work
id	ggid	email	passwd
1	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
8	102	2
9	102	2
15	102	2
id	parent_id	level
1001	100	0
1003	101	1
1004	101	1
1008	102	2
1024	102	2
1017	103	2
1022	104	2
1024	104	2
1028	105	2
1029	105	2
1030	105	2
1031	106	2
1032	106	2
1033	106	2
1203	107	2
1202	107	2
1020	103	2
1157	100	0
1193	105	2
1040	107	2
1002	101	1
1015	102	2
1006	101	1
1034	106	2
1035	106	2
1016	103	2
1007	101	1
1036	107	2
1018	103	2
1026	105	2
1027	105	2
1183	104	2
1038	107	2
1025	105	2
1037	107	2
1021	104	2
1019	103	2
1005	101	1
1179	105	2
id	parent_id	level
1002	100	0
1004	101	1
1005	101	1
1009	102	2
1025	102	2
1018	103	2
1023	104	2
1025	104	2
1029	105	2
1030	105	2
1031	105	2
1032	106	2
1033	106	2
1034	106	2
1204	107	2
1203	107	2
1021	103	2
1158	100	0
1194	105	2
1041	107	2
1003	101	1
1016	102	2
1007	101	1
1035	106	2
1036	106	2
1017	103	2
1008	101	1
1037	107	2
1019	103	2
1027	105	2
1028	105	2
1184	104	2
1039	107	2
1026	105	2
1038	107	2
1022	104	2
1020	103	2
1006	101	1
1180	105	2
id	parent_id	level
1009	102	2
1025	102	2
1016	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
1	1004
1	1005
1	1003
1	1007
1	1008
1	1006
level	id	parent_id
1	1004	101
1	1005	101
1	1003	101
1	1007	101
1	1008	101
1	1006	101
level	id
1	1003
1	1004
1	1005
1	1006
1	1007
1	1008
id	parent_id	level
1002	100	0
1009	102	2
1025	102	2
1018	103	2
1023	104	2
1025	104	2
1029	105	2
1030	105	2
1031	105	2
1032	106	2
1033	106	2
1034	106	2
1204	107	2
1203	107	2
1021	103	2
1158	100	0
1194	105	2
1041	107	2
1016	102	2
1035	106	2
1036	106	2
1017	103	2
1037	107	2
1019	103	2
1027	105	2
1028	105	2
1184	104	2
1039	107	2
1026	105	2
1038	107	2
1022	104	2
1020	103	2
1180	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	2	NULL	NULL	
i	j
1	2
i	j
1	2
MIN(B)	MAX(b)
1	1
a
1
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	range	PRIMARY	PRIMARY	4	NULL	1	where used
id
0
1
2
id
0
1
2
id
0
1
2
id	id3
0	0
1	1
2	2
100	2
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` char(20) default NULL,
  KEY `a` (`a`)
) TYPE=InnoDB
a
1
2
4
a	b
1	NULL
2	NULL
4	NULL
id	name	value	uid
1	one	one value	101
3	three	three value	103
6	two	other value	102
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	NULL	PRIMARY	4	NULL	4	
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	NULL	b	4	NULL	4	
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ALL	NULL	NULL	NULL	NULL	4	Using filesort
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	NULL	PRIMARY	4	NULL	4	Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	NULL	b	4	NULL	4	Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	NULL	b	4	NULL	4	Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	index	NULL	b	4	NULL	4	Using index
table	type	possible_keys	key	key_len	ref	rows	Extra
t1	ALL	NULL	NULL	NULL	NULL	4	
Field	Type	Null	Key	Default	Extra
testint	int(11)			1