Bug #111481 Make AS keyword optional on CREATE VIEW
Submitted: 19 Jun 2023 8:40 Modified: 19 Jun 2023 12:07
Reporter: Markus Zeller Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: FeatureRequest

[19 Jun 2023 8:40] Markus Zeller
Description:
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
Make the AS keyword optional in CREATE VIEW the same like in CREATE TABLE

How to repeat:
AS keyword is mandatory

Suggested fix:
Make AS keyword optional
[19 Jun 2023 12:07] MySQL Verification Team
Hi Mr. Zeller,

Thank you for your bug report, although it is in fact only a feature request.

However, we can not change VIEW syntax, since we must follow SQL standard , more precisely clause 11.32.

Not a bug.