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
esday, April 04, 2001 3:19 PM
Subject: fastest queries
> I'm working on a MySQL db and I was just curious what type of query was
> faster.
>
> e.g.
> I have this table1
> id (auto# primary key) | date| Name | address | email
>
> I want to insert a new name into the DB.
>
I'm working on a MySQL db and I was just curious what type of query was
faster.
e.g.
I have this table1
id (auto# primary key) | date| Name | address | email
I want to insert a new name into the DB.
Which method would be faster?
1.
INSERT INTO table1 VALUES(null,null,'Bryan',null,null);
2.
INS