SELECT *, DATE_FORMAT(dt_insert, '%d/%m/%Y %H:%i' ) AS jour_insert, DATE_FORMAT(dt_maj, '%d/%m/%Y %H:%i' ) AS jour_maj FROM js_reference ORDER BY IDfather, name
SELECT * FROM js_navigateur ORDER BY ordre
SELECT * FROM js_version ORDER BY ID
SELECT * FROM js_reference WHERE phpfile="htmlelement.firstchild"
UPDATE js_reference SET nb_visi=nb_visi+1, nb_visi_delai=nb_visi_delai+1 WHERE ID='292'
SELECT * FROM js_navigateur ORDER BY ordre
SELECT js_equivalent_ressource.*, js_equivalent_language.language, js_equivalent_language.favico
FROM js_equivalent_ressource, js_equivalent_language
WHERE js_equivalent_ressource.idLanguage = js_equivalent_language.id
AND js_equivalent_ressource.etat=1
AND js_equivalent_language.etat=1
AND js_equivalent_ressource.typeof='REF'
AND js_equivalent_ressource.idRessource="292"
SELECT * FROM js_exemple WHERE ID='292' ORDER BY ordre
SELECT * FROM js_url WHERE ID='292' ORDER BY ordre
SELECT * FROM js_url WHERE ID='269' ORDER BY ordre
Réduit la sélection au premier élément.
En savoir plus
