sql语句创建表

CREATE TABLE users(
　　id INT PRIMARY KEY,
　　`name` VARCHAR(40),
　　`password` VARCHAR(40),
　　email VARCHAR(60),
　　birthday DATE
);

插入数据

INSERT INTO users (`id`, `name`, `password`, `email`, `birthday`)
VALUES (1, '张三', '123456', 'zs@126.com', '2000-12-12');

INSERT INTO `jdbc`.`users` (`id`, `name`, `password`, `email`, `birthday`)
VALUES (2, '李四', '123456', 'xib@qq.com', '2021-03-19');
INSERT INTO users (`id`, `name`, `password`, `email`, `birthday`)
VALUES (3, '王五', '123456', 'ls@126.com', '2000-12-12');
INSERT INTO users (`id`, `name`, `password`, `email`, `birthday`)
VALUES (4, '赵六', '123456', 'ww@126.com', '2000-12-12');

插入数据的时候注意单引号和飘的转换

SELECT * FROM users;