The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.4.21-MariaDB]You have an error in your SQL syntax

Please assist, where is the error in this code?

CREATE TABLE App_menu_filters9( uid BIGINT NULL, tenant_uid INT NULL, label VARCHAR(50) NULL, sub_copy VARCHAR(300) NULL, opt_order INT NULL, level INT NULL, icon VARCHAR(100) NULL, header VARCHAR(50) NULL, parent_uid INT NULL, minimum_stock_balance numeric(10, 2) NULL, atp_percent numeric(10, 2) NULL, margin_percent numeric(10, 4) NULL, partner VARCHAR(50) NULL, datetime_updated datetime NULL, status VARCHAR(1) NULL)

TITLE: Microsoft Visual Studio ------------------------------

The table cannot be created.

------------------------------ ADDITIONAL INFORMATION:

ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.4.21-MariaDB]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 'CREATE TABLE App_menu_filters9( uid BIGINT NULL, tenant_uid INT NULL, ...' at line 4 (myodbc8a.dll)

------------------------------ BUTTONS:

OK ------------------------------

Answer Answered by Marko Mäkelä in this comment.

I tested the statement in MariaDB 10.4.21, and it works just fine. Note: "level" is a semi-reserved word. You might want to enclose that column name in quotes.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.