常用的MySQL语句

2023/06/24 MySQL 3506

1.查找单个字段重复的数据

SELECT account FROM accountinfo GROUP BY account HAVING COUNT(account) > 1;

2.创建数据库语句

CREATE DATABASE 数据库名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;