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
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
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