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 fo
not for speed, but i defitively prefer your second query. Reason for this is
simple: you name the field you want to insert.
with your first query, if you'd ever alter the table you would have to check
all your source code that interacts with this table.
speed difference should be very minimal an