DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
find duplicate keys in mysql
SELECT
col
,
COUNT
(
col
)
FROM
table_name
GROUP
BY
col
HAVING
COUNT
(
col
)
>
1
;
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#find
#duplicate
#keys
#mysql
ADD COMMENT
Topic
COMMENT
Name
3+9 =
Submit