From: Date: July 30 2004 3:09pm
Subject: Re: Ignoring or filtering ' char
List-Archive: http://lists.mysql.com/win32/15286
Message-Id: <002f01c47636$862e2860$6401a8c0@ns>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

> Here is a tip for you, try to make all your inserts statements
> declaring all the fields, like this:
> insert into tablename (field1, field2) values (value1, value2)
I prefer this
insert into tablename set field1=value1, field2=value2
This syntax is more well-arranged :-)

Petr Vileta, Czech republic