I'm currently writing a program that will make use of the SHOW CREATE TABLE statement to verify that existing tables are correct (if not, it drops them and recreates). Why is it though that the SHOW CREATE TABLE statement returns the answer on multiple lines? Why not just one line? And is it possible to make it return the result on just one line?
The statement looks better if you print it.
Why does it matter to your program what it looks like, especially if you're just executing the statement? It's a single string, so it should be a legal statement in any API.
Thanks, Adam Clauss [EMAIL PROTECTED]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
