Skip to content
Advertisement

Tag: information-schema

List of all table and column level privileges for a MySQL database

What is the easiest way to list all table-level and column-level privileges for a MySQL database? I need to know what level of customized access has been granted for a specific database and which users have fine-tuned access to certain tables and/or columns. Answer To list table level privileges, you can query the INFORMATION_SCHEMA.TABLE_PRIVILEGES table. The TABLE_PRIVILEGES table has these

Generate CREATE statements for all MySql Tables

I want All CREATE statements of MySql Tables in 1 query result. For example, INFORMATION_SCHEMA contains all table names,comments etc. but where are the CREATE statements are stored in MySql ? can it be retrieved in one query for all tables ? Currently i am retrieving TABLE ddl as below for 1 table. I have 100’s of tables so i

Advertisement