智享笔记 MySQL
-
常用的MySQL语句
1.查找单个字段重复的数据SELECT account FROM accountinfo GROUP BY account HAVING COUNT(account) > 1;2.创建数据库语句CREATE DATABASE 数据库名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
1.查找单个字段重复的数据SELECT account FROM accountinfo GROUP BY account HAVING COUNT(account) > 1;2.创建数据库语句CREATE DATABASE 数据库名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;