Re: Alter Table Syntax - Ignatius Reilly - com.mysql.lists.win32

3 messages in com.mysql.lists.win32Re: Alter Table Syntax

From	Sent On	Attachments
Anthony Johnston . Antix	23 Oct 2002 03:02
Ignatius Reilly	23 Oct 2002 03:07
Mark Armer	23 Oct 2002 05:13

Subject:	Re: Alter Table Syntax
From:	Ignatius Reilly (igna...@free.fr)
Date:	10/23/2002 03:07:56 AM
List:	com.mysql.lists.win32

Hi,

apparently you want to enable a user script to alter a table? This is highly unusual, and probably suggests a defect in your data model (poor normalization).

My advice would be to review your data model (1NF: no repeated fields).

Ignatius

____________________________________________

Hi, Does any one know how I can do this

if not table exists then create *can do else if table exists then alter if not field exists then create

in SQL, can't find anything in the manual.

Thanks, Ant :)

______________________________________________ Merry Christmas from the Snowman http://www.chrimbo.com