php - mysql php查询CREATE VIEW多表成一张表
问题描述
如何命名四个表制作一个表
Name table = (ID), (post_title)
sku table = (meta_id), (post_id), (meta_key), (meta_value)
Price table = (meta_id), (post_id), (meta_key), (meta_value)
stock table = (meta_id), (post_id), (meta_key), (meta_value)
此查询失败
CREATE VIEW fortress AS
SELECT name.ID, name.post_title, price.meta_value, sku.meta_value, stock.meta_value
FROM name
INNER JOIN price ON (name.ID = price.meta_id)
INNER JOIN key ON (name.ID = sku.meta_id)
INNER JOIN stock ON (name.ID = stock.meta_id)
发生此错误
1060 - 重复的列名“元值”
你的解决方案是什么?
解决方案
您需要给aliases
具有重复名称的列:
示例:
CREATE VIEW fortress AS
SELECT name.ID, name.post_title, price.meta_value AS price_meta_value,
key.meta_value AS key_meta_value, stock.meta_value AS AS stock_meta_value
FROM name`enter code here`
INNER JOIN price ON (name.ID = price.meta_id)
INNER JOIN key ON (name.ID = s.k.u.meta_id)
INNER JOIN stock ON (name.ID = stock.meta_id)
推荐阅读
- javascript - 如何将 v-model 设置为 v-for 循环中子属性的子值?
- flutter - 检查是否已将 Flutter Web 应用程序 (PWA) 添加到主屏幕?
- groovy - 输入消息不适用于提交者值
- ios - AudioKit 5 延迟时间 - 更改时导致数字点击
- node.js - 如何在 adonis 模型中给出默认值。我正在使用阿多尼斯打字稿
- java - 在 Java 中忽略输入
- .net - 使用自定义 SCIM 应用程序进行 AAD 用户配置
- excel - 基于列名的 Excel SUMIFS 公式
- javascript - 如果用户在执行时启动操作并关闭浏览器,服务器是否会完成异步请求的执行?
- mysql - How to make union all SQL-SQLite query by case statement?