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 (15)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 (57)UDP (4)ufw (4)Un*x (5)vidéo (6)vintage computing (4)virtualisation (3)VPN (10)VPS (1)Windows (6)Wordpress (18)zsync (1)
Archives
Articles récents
- How to live stream video from webcam on Linux
- What are useful CLI tools for Linux system admins ?
- How to analyze and view Apache web server logs interactively on Linux
- 4 Useful Tools to Find and Delete Duplicate Files in Linux
- How to measure packets per second or throughput on high speed network interface