1.新建一个数据库,在数据库里面新建一张user表
新建数据表的语句是:
CREATE TABLE `user` (
`user_id` bigint(20) NOT NULL,
`user_name` varchar(20) DEFAULT NULL,
`user_age` int(11) DEFAULT NULL,
`user_password` varchar(20) DEFAULT NULL,
`user_money` double DEFAULT NULL,
`user_create_time` datetime DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
新增数据:
insert into user(user_id, user_name, user_age, user_password, user_money, user_create_time)
values('1', '张三', '21', '123456', '12', '2018-08-27 16:31:25'),
('2', '李四', '23', '123456', '34', '2018-08-21 00:00:00'),
('3', '王五', '25', '123456', '56', '2018-08-21 00:00:00'),
('4