On 13 Oct 2003 at 16:59, Adam Clauss wrote: > Well the issue wasn't so much with my program at runtime, but at > design time (now). What I am doing is hardcoding the string that > creates the table into the program. Program then calls SHOW CREATE > TABLE and compares the two strings to see if they are the same. If > not, it drops and recreates. > > What I have to do everytime I add a table and want to hardcode it in, > is run SHOW CREATE TABLE myself when I know the table is correct and > then copy that string into my program. That copying part is where I > am having difficulty. It is taking a while for me to figure out where > linebreaks, spaces, etc. are in it. [...]
You can hardly expect MySQL to change its behavior to accommodate your particular situation. How many other people do you are think are doing what you're doing? Far fewer than would be annoyed by having the "CREATE TABLE" statement scrunched into one long line, I'd bet. How about saving the "SHOW CREATE TABLE" output to a file and keeping that around? Then your program can read the file, check the existing table structure against that, and if it's changed issue a warning message and re-create the file with the new output. Seems a lot better than hand-coding. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]