-3
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

RiggsFolly
  • 89,708
  • 20
  • 100
  • 143

0 Answers0