/dports/databases/akonadi/akonadi-21.12.3/src/server/storage/ |
H A D | dbintrospector_impl.cpp | 114 #define KEY_COLUMN_USAGE "information_schema.key_column_usage" in foreignKeyConstraints() macro 121 … QStringLiteral(KEY_COLUMN_USAGE ".constraint_catalog")); in foreignKeyConstraints() 124 … QStringLiteral(KEY_COLUMN_USAGE ".constraint_schema")); in foreignKeyConstraints() 127 QStringLiteral(KEY_COLUMN_USAGE ".constraint_name")); in foreignKeyConstraints() 153 qb.addColumn(QStringLiteral(KEY_COLUMN_USAGE ".column_name")); in foreignKeyConstraints() 158 qb.addJoin(QueryBuilder::LeftJoin, QStringLiteral(KEY_COLUMN_USAGE), keyColumnUsageCondition); in foreignKeyConstraints() 165 #undef KEY_COLUMN_USAGE in foreignKeyConstraints()
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage_embedded.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/funcs_1/r/ |
H A D | is_key_column_usage.result | 1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE'; 2 Tables_in_information_schema (KEY_COLUMN_USAGE) 3 KEY_COLUMN_USAGE 10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE; 15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE; 19 SELECT * FROM information_schema.KEY_COLUMN_USAGE; 27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout 29 DESCRIBE information_schema.KEY_COLUMN_USAGE; 43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE; 45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` ( [all …]
|