On 04.04.2001 16:42:28 ?iso-8859-1?Q?Ren=E9_Tegel?= wrote:
> not for speed, but i defitively prefer your second query. Reason for this is
> simple: you name the field you want to insert.
Yes, you are right. But I prefer a third way altogether:
INSERT INTO Tbl SET Field=42;
The reason for this is, that it is very easy to change this to an UPDATE query
like:
UPDATE TBL SET Field=42;
While you may hardly ever need to change INSERT <-> UPDATE, I find it nice that
both those statements which do similiar tasks have the same syntax.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
