在前面的3.1章节中,我们学习了如何利用Navicat Premium15创建基于mysql的数据库连接,如下图:
1、我创建了一个TP6的数据库连接,在连接下面我又重新创建了一个thinkphp6的数据库。
2、在thinkphp6数据库里面,我创建了一个student表,并插入了5条内容,代码如下:
CREATE TABLE student
(
id
int(12) NOT NULL,
name
varchar(100) NOT NULL,
age
int(12) NOT NULL,
create_time
datetime(6),
update_time
datetime(6),
delete_time
datetime(6),
PRIMARY KEY (id
)
) ENGINE = InnoDB CHARACTER SET = utf8mb4;
插入内容:
INSERT INTO student
VALUES (1, ‘张三’, 10, ‘2021-07-07 14:57:13.000000’, ‘2021-07-07 14:57:19.000000’, NULL);
INSERT INTO student
VALUES (2, ‘李四’, 15, ‘2021-07-06 14:57:53.000000’, ‘2021-07-06 14:57:58.000000’, NULL);
INSERT INTO student
VALUES (3, ‘王五’, 25, ‘2021-07-01 14:58:15.000000’, ‘2021-07-01 14:58:27.000000’, NULL);
INSERT INTO student
VALUES (4, ‘赵六’, 30, ‘2021-07-06 14:59:07.000000’, ‘2021-07-06 14:59:12.000000’, NULL);
INSERT INTO student
VALUES (5, ‘马八’, 27, ‘2021-07-02 14:59:57.000000’, ‘2021-07-02 15:00:02.000000’, NULL);