.

Friday, June 21, 2013

How to convert MyIsam to InnoDB for all table LIKE "tb_%"

SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=InnoDB;')
FROM information_schema.tables
WHERE engine = 'MyISAM' and table_name LIKE "tb_%";

No comments:

Setting DeepCool AK400 Digital CPU fan di Manjaro Linux

  Baru rakit PC dan pakai AK400 Digital untuk CPU fannya, setelah install linux ternyata tulisan digitalnya gak tampil, cari-cari di interne...