MySQL Forums
Forum List  »  General

Re: Alter all tables in a Database
Posted by: Jay Alverson
Date: January 27, 2009 02:35PM

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

Options: ReplyQuote

Written By
Re: Alter all tables in a Database
January 27, 2009 02:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.