Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select field1 count(*)
- from table_name
- group by field1
- having count(*) > 1
- CREATE TABLE Dummy(
- `f1` INT(11) NULL DEFAULT NULL,
- `f2` INT(11) NULL DEFAULT NULL,
- `f3` INT(11) NULL DEFAULT NULL,
- `f4` VARCHAR(254) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
- `f5` VARCHAR(254) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
- `f6` VARCHAR(8) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
- `f7` DATETIME NULL DEFAULT NULL,
- `f8` BIGINT(20) NULL DEFAULT NULL,
- `f9` BIGINT(20) NULL DEFAULT NULL,
- `f10` DATETIME NULL DEFAULT NULL,
- `f11` DATETIME NULL DEFAULT NULL,
- `f12` BIGINT(20) NULL DEFAULT NULL,
- `f13` DOUBLE NULL DEFAULT NULL,
- `f14` INT(11) NULL DEFAULT NULL,
- `f15` INT(11) NULL DEFAULT NULL
- INDEX `idxF2F3` (`f2`, `f3`)
- )
- COLLATE='utf8_unicode_ci'
- ENGINE=InnoDB
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement