-- 创建用户
CREATE USER user_kfm IDENTIFIED  
	WITH mysql_native_password BY '123456';
GRANT ALL PRIVILEGES ON *.* TO user_kfm@'%' WITH GRANT OPTION;  -- 授权

FLUSH PRIVILEGES;
-- 创建数据库
CREATE DATABASE DB_USER;
-- 切换当前数据库
USE DB_USER;
-- 创建表
-- drop TABLE T_User;
CREATE TABLE T_User(
  id INT AUTO_INCREMENT	 PRIMARY KEY,
  NAME	VARCHAR(10) NOT NULL,
  idCard CHAR(18) NOT NULL,
  mob CHAR(11)	NOT NULL UNIQUE
);

CREATE TABLE Provice(
	
);
INSERT INTO t_user (NAME, idCard, mob)
VALUES
  ('name', 'idCard', 'mob')

DELETE
FROM
  t_user
WHERE id = 'id';

UPDATE
  t_user
SET
  NAME = 'name',
  idCard = 'idCard',
  mob = 'mob'
WHERE id = 'id';


SELECT
  id,
  NAME,
  idCard,
  mob
FROM
  t_user