Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: information-schema

Need help to understand how information_schema.TABLES get updated

By adminPosted on January 31, 2023

Question : I created large innodb table mysql> select count(*) from big_data; +———-+ | count(*) | +———-+ | 23822336 | […]

Display only table names with psql

By adminPosted on January 23, 2023

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”?

By adminPosted on January 13, 2023

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

By adminPosted on January 4, 2023

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

By adminPosted on December 30, 2022

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?

By adminPosted on December 17, 2022

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

By adminPosted on December 13, 2022

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?

By adminPosted on December 12, 2022

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

By adminPosted on December 7, 2022

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

By adminPosted on November 29, 2022

Question : Quote from MariaDB 10.2 CHECK and DEFAULT clauses: Another limitation is that CHECK metadata are not accessible via […]

  • 1
  • 2
  • 3
  • …
  • 9

Recent Posts

  • Using postgres to select a filtered array
  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding