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.将语句压缩为一行
这四点我都想取消,分别应该怎么做
最终想要的结果是,创建语句怎么存的,读取的时候就要怎么拿回来