Gecko [ www.jdcpatala.org ]

Name	Size	Permission
all_sys_objects_exist.result	4.66 KB	-rw-r--r--
fn_extract_schema_from_file_na...	261 B	-rw-r--r--
fn_extract_table_from_file_nam...	256 B	-rw-r--r--
fn_format_bytes.result	993 B	-rw-r--r--
fn_format_path.result	1.04 KB	-rw-r--r--
fn_format_statement.result	627 B	-rw-r--r--
fn_format_time.result	1.45 KB	-rw-r--r--
fn_list_add.result	1 KB	-rw-r--r--
fn_list_drop.result	1.27 KB	-rw-r--r--
fn_ps_is_account_enabled.resul...	541 B	-rw-r--r--
fn_ps_is_consumer_enabled.resu...	1.94 KB	-rw-r--r--
fn_ps_is_instrument_default_en...	2.28 KB	-rw-r--r--
fn_ps_is_instrument_default_ti...	2.22 KB	-rw-r--r--
fn_ps_is_thread_instrumented.r...	558 B	-rw-r--r--
fn_ps_thread_account.result	370 B	-rw-r--r--
fn_ps_thread_id.result	273 B	-rw-r--r--
fn_ps_thread_trx_info.result	4.58 KB	-rw-r--r--
fn_quote_identifier.result	531 B	-rw-r--r--
fn_sys_get_config.result	294 B	-rw-r--r--
mysqldump.result	2.4 KB	-rw-r--r--
pr_create_synonym_db.result	1.66 KB	-rw-r--r--
pr_diagnostics.result	883 B	-rw-r--r--
pr_execute_prepared_stmt.resul...	674 B	-rw-r--r--
pr_ps_setup_reset_to_default.r...	2.58 KB	-rw-r--r--
pr_ps_setup_show_disabled.resu...	6.77 KB	-rw-r--r--
pr_ps_setup_show_disabled_cons...	612 B	-rw-r--r--
pr_ps_setup_show_disabled_inst...	1.75 KB	-rw-r--r--
pr_ps_setup_show_enabled.resul...	14.27 KB	-rw-r--r--
pr_ps_setup_show_enabled_consu...	751 B	-rw-r--r--
pr_ps_setup_show_enabled_instr...	5.8 KB	-rw-r--r--
pr_ps_trace_statement_digest.r...	1.28 KB	-rw-r--r--
pr_statement_performance_analy...	12.39 KB	-rw-r--r--
pr_table_exists.result	822 B	-rw-r--r--
t_sys_config.result	1.69 KB	-rw-r--r--
v_host_summary.result	1.06 KB	-rw-r--r--
v_host_summary_by_file_io.resu...	403 B	-rw-r--r--
v_host_summary_by_file_io_type...	586 B	-rw-r--r--
v_host_summary_by_stages.resul...	562 B	-rw-r--r--
v_host_summary_by_statement_la...	889 B	-rw-r--r--
v_host_summary_by_statement_ty...	998 B	-rw-r--r--
v_innodb_buffer_stats_by_schem...	658 B	-rw-r--r--
v_innodb_buffer_stats_by_table...	710 B	-rw-r--r--
v_innodb_lock_waits.result	2.23 KB	-rw-r--r--
v_io_by_thread_by_latency.resu...	794 B	-rw-r--r--
v_io_global_by_file_by_bytes.r...	821 B	-rw-r--r--
v_io_global_by_file_by_latency...	915 B	-rw-r--r--
v_io_global_by_wait_by_bytes.r...	1.12 KB	-rw-r--r--
v_io_global_by_wait_by_latency...	1.21 KB	-rw-r--r--
v_latest_file_io.result	495 B	-rw-r--r--
v_memory_by_host_by_current_by...	704 B	-rw-r--r--
v_memory_by_thread_by_current_...	794 B	-rw-r--r--
v_memory_by_user_by_current_by...	704 B	-rw-r--r--
v_memory_global_by_current_byt...	730 B	-rw-r--r--
v_memory_global_total.result	283 B	-rw-r--r--
v_metrics.result	202 B	-rw-r--r--
v_processlist.result	2.21 KB	-rw-r--r--
v_ps_check_lost_instrumentatio...	199 B	-rw-r--r--
v_ps_digest_95th_percentile_by...	718 B	-rw-r--r--
v_ps_digest_avg_latency_distri...	652 B	-rw-r--r--
v_ps_schema_table_statistics_i...	1.96 KB	-rw-r--r--
v_schema_auto_increment_column...	8.04 KB	-rw-r--r--
v_schema_index_statistics.resu...	1.06 KB	-rw-r--r--
v_schema_object_overview.resul...	189 B	-rw-r--r--
v_schema_redundant_indexes.res...	1.29 KB	-rw-r--r--
v_schema_table_lock_waits.resu...	2.73 KB	-rw-r--r--
v_schema_table_statistics.resu...	1.64 KB	-rw-r--r--
v_schema_table_statistics_with...	2.2 KB	-rw-r--r--
v_schema_tables_with_full_tabl...	2.2 KB	-rw-r--r--
v_schema_unused_indexes.result	213 B	-rw-r--r--
v_session.result	2.19 KB	-rw-r--r--
v_session_ssl_status.result	259 B	-rw-r--r--
v_statement_analysis.result	1.93 KB	-rw-r--r--
v_statements_with_errors_or_wa...	998 B	-rw-r--r--
v_statements_with_full_table_s...	4.18 KB	-rw-r--r--
v_statements_with_runtimes_in_...	1.45 KB	-rw-r--r--
v_statements_with_sorting.resu...	1.22 KB	-rw-r--r--
v_statements_with_temp_tables....	1.09 KB	-rw-r--r--
v_user_summary.result	1.06 KB	-rw-r--r--
v_user_summary_by_file_io.resu...	403 B	-rw-r--r--
v_user_summary_by_file_io_type...	574 B	-rw-r--r--
v_user_summary_by_stages.resul...	562 B	-rw-r--r--
v_user_summary_by_statement_la...	883 B	-rw-r--r--
v_user_summary_by_statement_ty...	998 B	-rw-r--r--
v_version.result	55 B	-rw-r--r--
v_wait_classes_global_by_avg_l...	681 B	-rw-r--r--
v_wait_classes_global_by_laten...	665 B	-rw-r--r--
v_waits_by_host_by_latency.res...	630 B	-rw-r--r--
v_waits_by_user_by_latency.res...	630 B	-rw-r--r--
v_waits_global_by_latency.resu...	572 B	-rw-r--r--
version_functions.result	222 B	-rw-r--r--

Code Editor : v_schema_auto_increment_columns.result

DESC sys.schema_auto_increment_columns;
Field	Type	Null	Key	Default	Extra
table_schema	varchar(64)	NO			
table_name	varchar(64)	NO			
column_name	varchar(64)	NO			
data_type	varchar(64)	NO			
column_type	longtext	NO		NULL	
is_signed	int(1)	NO		0	
is_unsigned	int(1)	NO		0	
max_value	bigint(21) unsigned	YES		NULL	
auto_increment	bigint(21) unsigned	YES		NULL	
auto_increment_ratio	decimal(25,4) unsigned	YES		NULL	
SELECT * FROM sys.schema_auto_increment_columns;
CREATE DATABASE auto_incs;
CREATE TABLE auto_incs.tinyintcol (
id TINYINT AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.tinyintcol (foo) VALUES (100);
INSERT INTO auto_incs.tinyintcol (foo) (SELECT foo FROM auto_incs.tinyintcol);
INSERT INTO auto_incs.tinyintcol (foo) (SELECT foo FROM auto_incs.tinyintcol);
INSERT INTO auto_incs.tinyintcol (foo) (SELECT foo FROM auto_incs.tinyintcol);
INSERT INTO auto_incs.tinyintcol (foo) (SELECT foo FROM auto_incs.tinyintcol);
CREATE TABLE auto_incs.tinyintcolunsigned (
id TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.tinyintcolunsigned (foo) (SELECT foo FROM auto_incs.tinyintcol);
CREATE TABLE auto_incs.smallintcol (
id SMALLINT AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.smallintcol (foo) VALUES (200);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
INSERT INTO auto_incs.smallintcol (foo) (SELECT foo FROM auto_incs.smallintcol);
CREATE TABLE auto_incs.smallintcolunsigned (
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.smallintcolunsigned (foo) (SELECT foo FROM auto_incs.smallintcol);
CREATE TABLE auto_incs.mediumintcol (
id MEDIUMINT AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.mediumintcol (foo) VALUES (300);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
INSERT INTO auto_incs.mediumintcol (foo) (SELECT foo FROM auto_incs.mediumintcol);
CREATE TABLE auto_incs.mediumintcolunsigned (
id MEDIUMINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.mediumintcolunsigned (foo) (SELECT foo FROM auto_incs.mediumintcol);
CREATE TABLE auto_incs.intcol (
id INT AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.intcol (foo) VALUES (400);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
INSERT INTO auto_incs.intcol (foo) (SELECT foo FROM auto_incs.intcol);
CREATE TABLE auto_incs.intcolunsigned (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.intcolunsigned (foo) (SELECT foo FROM auto_incs.intcol);
CREATE TABLE auto_incs.bigintcol (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.bigintcol (foo) VALUES (500);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
INSERT INTO auto_incs.bigintcol (foo) (SELECT foo FROM auto_incs.bigintcol);
CREATE TABLE auto_incs.bigintcolunsigned (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
foo INT
);
INSERT INTO auto_incs.bigintcolunsigned (foo) (SELECT foo FROM auto_incs.bigintcol);
SELECT * FROM sys.schema_auto_increment_columns;
table_schema	table_name	column_name	data_type	column_type	is_signed	is_unsigned	max_value	auto_increment	auto_increment_ratio
auto_incs	tinyintcol	id	tinyint	tinyint(4)	1	0	127	28	0.2205
auto_incs	tinyintcolunsigned	id	tinyint	tinyint(3) unsigned	0	1	255	32	0.1255
auto_incs	smallintcol	id	smallint	smallint(6)	1	0	32767	4085	0.1247
auto_incs	smallintcolunsigned	id	smallint	smallint(5) unsigned	0	1	65535	4096	0.0625
auto_incs	mediumintcol	id	mediumint	mediumint(9)	1	0	8388607	262126	0.0312
auto_incs	mediumintcolunsigned	id	mediumint	mediumint(8) unsigned	0	1	16777215	196606	0.0117
auto_incs	intcol	id	int	int(11)	1	0	2147483647	262126	0.0001
auto_incs	intcolunsigned	id	int	int(10) unsigned	0	1	4294967295	196606	0.0000
auto_incs	bigintcol	id	bigint	bigint(20)	1	0	9223372036854775807	262126	0.0000
auto_incs	bigintcolunsigned	id	bigint	bigint(20) unsigned	0	1	18446744073709551615	196606	0.0000
DROP DATABASE auto_incs;

${this.title}

Code Editor : v_schema_auto_increment_columns.result