How to check the character set of all tables in mysql?

You can use the following statement to query the character set of all tables in the MySQL database:

SELECT table_name, table_collation
FROM information_schema.tables
WHERE table_schema = 'your_database_name';

Replace your_database_name with the name of the database you want to query. This will return the names of all tables and character sets in that database.