Ide: Navicat15
According to the following statement create a view
The create or replace the 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
;
By system tool to view the create statement
With the default tool after beautification
SELECT
` t1 `. ` a1 ` AS ` a1 `,
` t2 `. ` a2 ` AS ` a2 `,
` t3 `. ` a3 ` AS ` a3 `,
` t4 `. ` a4 ` AS ` a4 `
The FROM
((((
SELECT
1 the AS ` a1 `
) ` t1 `
The JOIN (SELECT 1 AS ` a2 `) ` t2 `
)
The JOIN (SELECT 1 AS ` a3 `) ` t3 `
)
The JOIN (SELECT 1 AS ` a4 `) ` t4 `)
Were identified as you can see the mysql four things
1. All the keywords into capital
2. Will all very quantity with quotes
3. Automatically change sentence structure to standard syntax
4. To squeeze the statement for a line of
I want to cancel, at four o 'clock this respectively should do
Ultimately want as a result, how to save and create statements read time is how to bring it back
CodePudding user response:
Show the create view XXXX, do not use the graphical toolsCodePudding user response: