Back (Current repo: scraps)

random scraps and notes that are useful to me
To clone this repository:
git clone https://git.viktor1993.net/scraps.git
Log | Download | Files | Refs

change_collation_all_tables_and_columns.sql (233B)

SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA, '.', TABLE_NAME," CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;") AS executethis FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA="some_schema" AND TABLE_TYPE="BASE TABLE";