CREATE OR REPLACE VIEW post_user AS SELECT
posts.* ,users."name"
FROM
posts
left join users on posts.user_id = users.id
更多推荐
[数据库实战]sql创建一个view视图
CREATE OR REPLACE VIEW post_user AS SELECT
posts.* ,users."name"
FROM
posts
left join users on posts.user_id = users.id
更多推荐
[数据库实战]sql创建一个view视图
发布评论