Toad World® Forums

CREATE VIEW for MYSQL, missing "AS"


#1

Create view for Mysql 5 is missing “AS” in generated SQL script.

http://dev.mysql.com/doc/refman/5.1/en/create-view.html

“AS” is mandatory.


#2

Hello arki,

Current Beta 3.0.12 :
You have to write AS on the SQL tab of the View so as it is generated in final SQL script.

In next Beta:
If you do not write AS on the SQL tab of the View, it will be automatically generated in final SQL script.
Nevertheless, we recommend to write it in any case.

Regards,

Vladka