Follow me:
Archives
- ajax
- apache
- array
- attachement
- attachementphp
- best practice
- branch
- case
- cmd
- comment
- convert
- css
- csv
- curl
- curl_init
- date
- db
- download
- duplicate
- editor
- encoding
- entities
- error
- export
- form
- git
- htaccess
- html entities
- IDE
- if clause
- imp
- import
- javascript
- jquery
- login
- mcv
- merge
- microtime
- multiple select
- mysql
- NetBeans
- notepad
- outlook
- php
- phpdoc
- phpmyadmin
- posts_per_page
- query_posts
- regex
- request
- rewrite
- se
- serializing
- server
- server variables
- service
- service class
- smarty
- sql
- standards
- string
- superglobals
- text edit
- time
- timestamp
- tools
- update
- utilities
- wkhtmltopdf
- wordpress
- xampp
- zend
Tag Archives: duplicate
Find duplicate values in database table
Description: Detect fields that have duplicate values in a database table. Solution: For finding duplicate values, the COUNT condition can be used, specifying the column name that we require. Example: SELECT customer_idFROM customers_tableGROUP BY customer_idHAVING count( * ) > 1; Also … Continue reading
justbugs 