Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT( 'ALTER TABLE `', t.`TABLE_SCHEMA` , '`.`', t.`TABLE_NAME` , '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) AS sqlcode
- FROM `information_schema`.`TABLES` t
- WHERE 1
- AND t.`TABLE_SCHEMA` = 'jiradb_prooftechit'
- ORDER BY 1
- LIMIT 0 , 90
- даст набор команд которые потом нужно исполнить
Add Comment
Please, Sign In to add comment