mysql版本 8.0.20
ide：Navicat15
按下面陳述句創建視圖
create or replace view v_test as
select * from
(select 1 a1 from dual) t1,
(select 1 a2 from dual) t2,
(select 1 a3 from dual) t3,
(select 1 a4 from dual) t4
;
通過系統工具查看創建陳述句
用默認工具美化之后
SELECT
`t1`.`a1` AS `a1`,
`t2`.`a2` AS `a2`,
`t3`.`a3` AS `a3`,
`t4`.`a4` AS `a4`
FROM
((((
SELECT
1 AS `a1`
) `t1`
JOIN ( SELECT 1 AS `a2` ) `t2`
)
JOIN ( SELECT 1 AS `a3` ) `t3`
)
JOIN ( SELECT 1 AS `a4` ) `t4`)
可以看到mysql一共做了四件事
1.將所有關鍵字轉換為大寫
2.將所有非常量加上引號
3.自動更改陳述句結構至標準語法
4.將陳述句壓縮為一行
這四點我都想取消，分別應該怎么做
最終想要的結果是，創建陳述句怎么存的，讀取的時候就要怎么拿回來
uj5u.com熱心網友回復：
show create view XXXX。 不要用圖形化工具的uj5u.com熱心網友回復：
一樣的，甚至information_schema.views中的資訊也是如此
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/243009.html
標籤：MySQL
上一篇：根據b表修改a表資料怎么寫
下一篇：python