MariaDB [lab10]> CREATE VIEW "Customer C123" AS SELECT * FROM tblCustomer WHERE custID = 'c123';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"Customer C123" AS SELECT * FROM tblCustomer WHERE custID = 'c123'' at line 1
MariaDB [lab10]> CREATE VIEW 'Customer C123' AS SELECT * FROM tblCustomer WHERE custID = 'c123';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Customer C123' AS SELECT * FROM tblCustomer WHERE custID = 'c123'' at line 1
MariaDB [lab10]> CREATE VIEW [Customer C123] AS SELECT * FROM tblCustomer WHERE custID = 'c123';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[Customer C123] AS SELECT * FROM tblCustomer WHERE custID = 'c123'' at line 1