Friday, June 29th, 2012
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.
Keep Going…Each step may get harder But don’t stop! The view is beautiful at the top !
Sunday, June 10th, 2012
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,