148.216.95.41 / mysql wampserver / mysql / proc

Table: proc"Stored Procedures"

#	Name	Type	Collation	Attributes	Null	Default	Extra	Action
1	db	char(64)	utf8_bin		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
2	name	char(64)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	type	enum('FUNCTION', 'PROCEDURE')	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	specific_name	char(64)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	language	enum('SQL')	utf8_general_ci		No	SQL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	sql_data_access	enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', '	utf8_general_ci		No	CONTAINS_SQL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	is_deterministic	enum('YES', 'NO')	utf8_general_ci		No	NO		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	security_type	enum('INVOKER', 'DEFINER')	utf8_general_ci		No	DEFINER		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	param_list	blob			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	returns	longblob			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	body	longblob			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	definer	char(77)	utf8_bin		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	created	timestamp		on update CURRENT_TIMESTAMP	No	CURRENT_TIMESTAMP	ON UPDATE CURRENT_TIMESTAMP	Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	modified	timestamp			No	0000-00-00 00:00:00		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	sql_mode	set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOT	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	comment	text	utf8_bin		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	character_set_client	char(32)	utf8_bin		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	collation_connection	char(32)	utf8_bin		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	db_collation	char(32)	utf8_bin		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	body_utf8	longblob			Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values

Check AllWith selected:

Print view

Propose table structure

Move columns

Action	Keyname	Type	Unique	Packed	Column	Cardinality	Null	Comment
Edit	Drop	PRIMARY	BTREE	Yes	No	db	A	No
name		A	No
type	0	A	No

Information

Space usage
Data	0	B
Index	2	KiB
Total	2	KiB

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	0
Creation	Mar 14, 2014 at 01:30 PM
Last update	May 01, 2014 at 09:06 AM