MySQL – éviter les doublons dans un SELECT
Il suffit d’utiliser la clause DISTINCT entre SELECT et les champs.
Exemple :
SELECT DISTINCT id,nom,prenom FROM matable
Les commentaires sont fermés.
Tags
administration (67)Apache (37)Apple (57)apt-get (11)aptitude (5)attacks (31)backup (18)bash (21)batch (5)benchmark (7)brute-force (5)cluster (13)commands (82)crontab (8)database (54)DDoS (36)debian (14)dpkg (6)duplicates (1)fail2ban (16)Firefox (4)firewall (151)flood (13)ftp (1)geoiplookup (4)geolocation (5)Google (6)hack (4)htaccess (10)HTTP (28)installation (6)intrusion (7)iOS (3)iPhone (10)ipset (4)iptables (143)knockd (5)linux (22)logs (9)Mac OS X (61)Mail (11)monitoring (25)mot de passe (7)munin (7)MySQL (74)mysql performance tuning (9)navigateur (5)netfilter (58)OpenVPN (4)password (7)performance (34)php (11)Postfix (8)proxy (5)psad (1)Raspberry PI (9)remote access (5)replication (20)reporting (5)routage (12)rsync (14)rsyslog (6)sauvegarde (14)scripting (19)securite (99)shell (135)SNMP (4)SPAM (4)ssh (40)ssl (4)stress test (4)supervision (13)TARPIT (6)TCP (6)tunneling (6)Ubuntu (56)UDP (4)ufw (4)Un*x (5)vidéo (6)vintage computing (4)virtualisation (3)VPN (10)VPS (1)Windows (6)Wordpress (18)