execute `alter table` for a lot of tables

[sevmax]

Hello, community.
You piece of advice will be very useful for me!
How to execute "ALTER TABLE" for a lot of tables in database? I'm going to change engine from MyISAM to NDBCLUSTER. There are several hundreds of tables in database.
Command like

ALTER TABLE * ENGINE=NDBCLUSTER

isn't working.
I believe in your help!

Regards,
sevmax

[jim1944]

I'm not an SQL expert but I know enough to not expect

ALTER TABLE * ENGINE=NDBCLUSTER

to work.

This isn't really a Fedora issue or even a Linux issue. You might be better off looking for a forum dedicated to database stuff.

Jim

[nico80]

the mysql forum would be a better place to ask...

anyway it's easily done with a simple php script that executes

SHOW TABLES

to get the tables names and then cycles through each result to do alter the table

[kromberg]

You can also write a simple stored procedure to do this.