1. 创建数据库表
tb_post 帖子表
-- Table: public.tb_post
-- DROP TABLE public.tb_post;
CREATE TABLE public.tb_post
(
post_id integer NOT NULL DEFAULT nextval('tb_post_post_id_seq'::regclass),
title character varying(254) COLLATE pg_catalog."default" NOT NULL,
content text COLLATE pg_catalog."default",
create_time timestamp(4) without time zone NOT NULL,
user_id integer NOT NULL,
CONSTRAINT tb_post_pkey PRIMARY KEY (post_id)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.tb_post
OWNER to postgres;
COMMENT ON TABLE public.tb_post
IS '帖子信息表';
插入数据:
INSERT INTO tb_post(post_id, title, content, create_time, user_id)
VALUES(1, 'MyBatis关联数据查询', '在实际项目中,经常使用关联表的查询,比如:多对一,一对多等。这些查询是如何处理的呢,这一讲就讲这个问题。我们首先创建一个 post 表,并初始化数据。', CURRENT_TIMESTAMP, 1);
INSERT INTO tb_post(post_id, title, content, create_time, user_id)
VALUES(2, 'MyBatis开发环境搭建', '为了方便学习,这里直接建立java 工程,但一般都是开发 Web 项目。', CURRENT_TIMESTAMP, 1);
INSERT INTO tb_post(post_id, title, content, create_time, user_id)