Question : I created large innodb table mysql> select count(*) from big_data; +———-+ | count(*) | +———-+ | 23822336 | […]
Tag: information-schema
Display only table names with psql
Question : How can I get the table names without a header or footer or anything else from a specified […]
“show create table” output with out “show”?
Question : What I’d like to be able to get the SQL statement by ‘show create table’ as something I […]
Does this query always correctly retrieve the types of array parameters
Question : The following query seems to work, but I am not sure that it is the best/always correct way: […]
mysqldump, preserve update_time and modify_time attributes as listed by show table status from
Question : Does mysqldump preserve the create_time and update_time attributes that are output by show table status from? If not, […]
How can I list all tables without a primary key?
Question : I’ve seen a ton of queries to list primary and foreign keys but how can I query for […]
postgres system catalog query columns from table
Question : I am building an integration test against an app that provisions a database for a user. The User […]
Why do information_schema queries scan all databases?
Question : I’m building a PHP application that looks up the last modified date of all databases using information_schema. A […]
List all columns for a specified table
Question : I’m looking for a precise piece of information in a database which I have no knowledge about. The […]
where are the infos from ‘SHOW CREATE TABLE’ coming from? It’s not INFORMATION_SCHEMA
Question : Quote from MariaDB 10.2 CHECK and DEFAULT clauses: Another limitation is that CHECK metadata are not accessible via […]