SELECT * FROM `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 | |
---|---|---|---|---|---|---|---|---|---|---|
sakila | payment | payment_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 16050 | 0.2449 | |
sakila | category | category_id | tinyint | tinyint(3) unsigned | 0 | 1 | 255 | 17 | 0.0667 | |
sakila | language | language_id | tinyint | tinyint(3) unsigned | 0 | 1 | 255 | 6 | 0.0235 | |
sakila | film | film_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 1001 | 0.0153 | |
sakila | address | address_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 605 | 0.0092 | |
sakila | city | city_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 600 | 0.0092 | |
sakila | customer | customer_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 599 | 0.0091 | |
sakila | staff | staff_id | tinyint | tinyint(3) unsigned | 0 | 1 | 255 | 2 | 0.0078 | |
sakila | store | store_id | tinyint | tinyint(3) unsigned | 0 | 1 | 255 | 2 | 0.0078 | |
sakila | actor | actor_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 200 | 0.0031 | |
sakila | country | country_id | smallint | smallint(5) unsigned | 0 | 1 | 65535 | 110 | 0.0017 | |
sakila | inventory | inventory_id | mediumint | mediumint(8) unsigned | 0 | 1 | 16777215 | 4582 | 0.0003 | |
Table_insertion | pilote | Id_pilote | int | int(11) | 1 | 0 | 2147483647 | 30 | 0.0000 | |
sakila | rental | rental_id | int | int(11) | 1 | 0 | 2147483647 | 16050 | 0.0000 | |
Table_insertion | ecurie | Id_ecurie | int | int(11) | 1 | 0 | 2147483647 | 4 | 0.0000 | |
test19 | pilote | Id_pilote | int | int(11) | 1 | 0 | 2147483647 | 30 | 0.0000 | |
Table_insertion | voiture | Id_voiture | int | int(11) | 1 | 0 | 2147483647 | 14 | 0.0000 | |
test19 | ecurie | Id_ecurie | int | int(11) | 1 | 0 | 2147483647 | 4 | 0.0000 | |
Table_insertion | rallye | Id_rallye | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 | |
test19 | voiture | Id_voiture | int | int(11) | 1 | 0 | 2147483647 | 14 | 0.0000 | |
world | City | ID | int | int(11) | 1 | 0 | 2147483647 | 4080 | 0.0000 | |
test19 | rallye | Id_rallye | int | int(11) | 1 | 0 | 2147483647 | 2 | 0.0000 | |
test19 | speciale | Id_speciale | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 | |
vedettfak | fa | azon | int | int(4) | 1 | 0 | 2147483647 | 1259 | 0.0000 | |
Stefano | vulcano | codice | int | int(10) | 1 | 0 | 2147483647 | 4 | 0.0000 |
|