Mariadb SQL syntax error while creating table

Question

Manually creating a table while in mariadb console;
got the following error:

MariaDB [mysql]> CREATE TABLE learningdb(command varchar(255) text2disp varchar(255));

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 'varchar(255))' at line 1

MariaDB [mysql]> CREATE TABLE learningdb(command varchar(2048) text2disp varchar(2048));

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 'varchar(2048))' at line 1

Cannot find out the correct syntax.

Have you tried separating each field declaration by a comma? tutorialspoint.com/mariadb/mariadb_create_tables.htm I'm no MariaDB expert but I guess that you need a primary key too. — RubioRic
– RubioRic, Commented Jun 12, 2018 at 7:03
Isn't this pretty much the definition of a typographical error? — Gordon Linoff
– Gordon Linoff, Commented Jun 12, 2018 at 11:46

Ravinder Reddy · Accepted Answer · 2018-06-12 07:21:54Z

2

Dont you think a comma separator is required between each of type definition!?

Example:

CREATE TABLE learningdb(command varchar(255),  -- <--- this comma was missing
                        text2disp varchar(255));

Refer to Documentation:

Create Table - Syntax

CREATE [OR REPLACE] [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
 (create_definition,...) ...

Tutorial Point: MariaDB - Create Tables
- ... Multiple columns separated by commas ...

edited Jun 12, 2018 at 7:21

answered Jun 12, 2018 at 7:10

Ravinder Reddy

24.1k6 gold badges54 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mariadb SQL syntax error while creating table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related