Re: [LA-discussions] mysql
[
Thread Index
|
Date Index
|
More linuxarverne.org/discussions Archives
]
To
:
discussions@xxxxxxxxxxxxxxxx
Subject
: Re: [LA-discussions] mysql
From
: Matthieu <
matthieuy@xxxxxxxxx
>
Date
: Sat, 28 Nov 2009 13:01:48 +0100
Dkim-signature
: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:content-type; bh=EBp7qzlsvTfTckzpbuIdBRJ42LYIbnAXGynI4N6ospY=; b=VryvuVXPPoRjDCuQjh7Z1htMxTeDGujSmV08C1nSyfax/HgvAPyyIFhHqXmgC8iDLe o59CDGJcDDD6f2g51NhuBtAC5I/MgeoTCytSwYKhJZW8pN7zDQvavnda2ComLhdXZZM6 dImIq5C5cnAJ9C+MypfQ+YLpCiG01/JvZy0NE=
Domainkey-signature
: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; b=T//iRUe4UgxjoppynN685OsONT9sK/MPO7PK2NinkT05rtMFO1jPfYGgBi8wmIwPt/ ++V5gS1++Nmxi6Du8bQcsOPSAlc/3WqschsNKzj/56XYqKcOL3M0z64FE9C+dN+5/jJt VtPKZHsrw/iTIpQJeonDySlCvcuJk2ttJcvys=
Salut,
Merci KewlCat, un peu rappel ne fais pas de mal
J'en profite pour me glisser dans la discussion.
Tu utilise la clause WHERE pour joindre les 2 tables comme ceci :
SELECT u.pseudo, c.nom, c.prenom, c.mail, c.etc
FROM jos_users u, jos_comprofiler c
WHERE
u.id
=
c.id
;
Euh... J'ai toujours utilisé ceci :
SELECT u.pseudo, c.nom, c.prenom, c.mail, c.etc
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c ON
c.id
=
u.id
;
Quel est la différence ? Y'a t-il une méthode plus rapide ou meilleurs que l'autre ?
--
Matthieu
Follow-Ups
:
Re: [LA-discussions] mysql
From:
Romain Tartière
Re: [LA-discussions] mysql
From:
KewlCat
References
:
[LA-discussions] mysql
From:
Pascal à la Poste
Re: [LA-discussions] mysql
From:
KewlCat
Messages sorted by:
[
date
|
thread
]
Prev by Date:
Re: [LA-discussions] mysql
Next by Date:
Re: [LA-discussions] foire humus chateldon et logiciel libre
Previous by thread:
Re: [LA-discussions] mysql
Next by thread:
Re: [LA-discussions] mysql
Mail converted by
MHonArc
2.6.19+
http://listengine.tuxfamily.org/