mysql 基本操作

1.创建表(table)：

    create table location(id varchar(20) primary key AUTO_INCREMENT, name varchar(20));//主键设置及自增

    create table department(id varchar(20) primary key AUTO_INCREMENT, name varchar(20), locationid varchar(20),

    FOREIGN KEY (locationid)REFERENCEStablename(id)));//外键设置

2.插入数据

    insert into tablename(colunm1,column2) values('11','22');

3.查询

    select * from tablename;

4.查询表中的重复字段

  SELECT id,COUNT(*) AS COUNT FROM tableName GROUP BY id HAVING COUNT>1;

5.查询总条数

  select count(*) from tablename;