Re: Alter all tables in a Database

[Jay Alverson]

You mean the commands are created -- is that what you mean by "happens" ?

Then next step is to put them into a .SQL file, then execute the .SQL file
via the MYSQL.exe program.

If you don't know how to do that then make sure you read the Chapter 4 in the help file under MYSQL Programs. It'll show you how to use MYSQL.exe and how to run a .SQL file either thru the SOURCE command or by < file.sql on the command line.

Make sure you run the .SQL file under a login that has the correct privileges.

Run a "short version" of the commands maybe only change 2 or 3 tables.

>

Thanks, Jay