Re: SHOW CREATE TABLE on one line?

2003-10-13 Thread Paul DuBois
At 14:48 -0500 10/13/03, Adam Clauss wrote: 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

RE: SHOW CREATE TABLE on one line?

2003-10-13 Thread Adam Clauss
If (create != str) recreate table Adam Clauss [EMAIL PROTECTED] -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 13, 2003 3:15 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: Re: SHOW CREATE TABLE on one line? At 14:48 -0500 10

RE: SHOW CREATE TABLE on one line?

2003-10-13 Thread Keith C. Ivey
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