SELECT * FROM `COLUMNS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | GENERATION_EXPRESSION | SRS_ID | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | Diplom 2023 | Arxiv 2023 | AD nomeri | 5 | NULL | NO | varchar | 15 | 60 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(15) | select,insert,update,references | NULL | |||||
def | Diplom 2023 | Arxiv 2023 | Ati | 3 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | Diplom 2023 | Arxiv 2023 | Diplom No | 6 | NULL | NO | varchar | 25 | 100 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(25) | select,insert,update,references | NULL | |||||
def | Diplom 2023 | Arxiv 2023 | Familyasi | 2 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | Diplom 2023 | Arxiv 2023 | ID | 1 | NULL | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(11) | select,insert,update,references | NULL | |||||
def | Diplom 2023 | Arxiv 2023 | Otechestva | 4 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | KINO | KINO | dawamiyliwgi (min) | 4 | NULL | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(11) | select,insert,update,references | NULL | |||||
def | KINO | KINO | ID | 1 | NULL | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(11) | select,insert,update,references | NULL | |||||
def | KINO | KINO | janr | 2 | NULL | NO | varchar | 25 | 100 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(25) | select,insert,update,references | NULL | |||||
def | KINO | KINO | rejesior | 3 | NULL | NO | varchar | 30 | 120 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | varchar(30) | select,insert,update,references | NULL | |||||
def | Suporte | manutenção | marca | 2 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | Suporte | manutenção | memoria | 4 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | Suporte | manutenção | nome | 1 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | Suporte | manutenção | patrimonio | 3 | NULL | NO | text | 65535 | 65535 | NULL | NULL | NULL | utf8mb4 | utf8mb4_0900_ai_ci | text | select,insert,update,references | NULL | |||||
def | information_schema | CHARACTER_SETS | CHARACTER_SET_NAME | 1 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | NULL | |||||
def | information_schema | CHARACTER_SETS | DEFAULT_COLLATE_NAME | 2 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | NULL | |||||
def | information_schema | CHARACTER_SETS | DESCRIPTION | 3 | NULL | NO | varchar | 2048 | 6144 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(2048) | select | NULL | |||||
def | information_schema | CHARACTER_SETS | MAXLEN | 4 | NULL | NO | int | NULL | NULL | 10 | 0 | NULL | NULL | NULL | int(10) unsigned | select | NULL | |||||
def | information_schema | CHECK_CONSTRAINTS | CHECK_CLAUSE | 4 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_bin | longtext | select | NULL | |||||
def | information_schema | CHECK_CONSTRAINTS | CONSTRAINT_CATALOG | 1 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_bin | varchar(64) | select | NULL | |||||
def | information_schema | CHECK_CONSTRAINTS | CONSTRAINT_NAME | 3 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_tolower_ci | varchar(64) | select | NULL | |||||
def | information_schema | CHECK_CONSTRAINTS | CONSTRAINT_SCHEMA | 2 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_bin | varchar(64) | select | NULL | |||||
def | information_schema | COLLATIONS | CHARACTER_SET_NAME | 2 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | NULL | |||||
def | information_schema | COLLATIONS | COLLATION_NAME | 1 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_general_ci | varchar(64) | select | NULL | |||||
def | information_schema | COLLATIONS | ID | 3 | 0 | NO | bigint | NULL | NULL | 20 | 0 | NULL | NULL | NULL | bigint(20) unsigned | select | NULL |
|