MySQL + Change all tables to another engine using command line

As the blog post title suggest, below is the way you can make your life easier.

FOR /F  "skip=1" %G IN ('"mysql -u root -pMyPassword -e "SHOW TABLES IN world;""') DO mysql -u root -pMyPassword world -e "ALTER TABLE %G ENGINE=InnoDB;"

Source : FOR, InnoDB and Here

Caution!! Do at your own risk.

till then…

Keep Going…Each step may get harder But don’t stop! The view is beautiful at the top !

Posted in SQL/ETL | No Comments »

MySQL + Solution for SELECT INTO

MySQL Server doesn’t support the SELECT INTO TABLE syntax. Instead, MySQL Server supports the INSERT INTO … SELECT. Below syntax is equivalent with SELECT INTO in MySQL.

CREATE TABLE mynewtable (
SELECT f2,f3,f4 from tableA,tableB
where tableA.f1 = tableB.f1
);

Hope it helps,

Till then…adioss

Posted in Database, Tips & Tricks | No Comments »