mysql: [ERROR] unknown option '--CREATE TABLE users (id INT, name CHAR);'

Question

I tried to create a table named users by CREATE TABLE users (id INT, name CHAR);. Now, I can't start mysql from console, the error is as follows:

mysql: [ERROR] unknown option '--CREATE TABLE users (id INT, name CHAR);'.

It looks like you are single quoting users - this is not valid in mysql - you should use backticks or nothing at all. — P.Salmon, Aug 02 '20 at 07:41
Does this answer your question? [When to use single quotes, double quotes, and backticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) — P.Salmon, Aug 02 '20 at 07:41
What command are you using to start the mysql command line client? — Honeyboy Wilson, Aug 02 '20 at 20:15

score -1 · Answer 1 · answered Aug 02 '20 at 05:38

The CREATE TABLE statement is used to create a table in MySQL.

NOT NULL - Each row must contain a value for that column, null values are not allowed

DEFAULT value - Set a default value that is added when no other value is passed

UNSIGNED - Used for number types, limits the stored data to positive numbers and zero

AUTO INCREMENT - MySQL automatically increases the value of the field by 1 each time a new record is added

PRIMARY KEY - Used to uniquely identify the rows in a table. The column with PRIMARY KEY setting is often an ID number, and is often used with AUTO_INCREMENT

Each table should have a primary key column (in this case: the "id" column). Its value must be unique for each record in the table.

CREATE TABLE users(
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL
)

The primary key for a table is not necessary and is optional. — Majid Hajibaba, Aug 02 '20 at 05:39

mysql: [ERROR] unknown option '--CREATE TABLE users (id INT, name CHAR);'

1 Answers1