Re: fastest queries

2001-04-05 Thread alexander . skwar
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

Re: fastest queries

2001-04-04 Thread René Tegel
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