D
D
Dvorak2016-09-21 21:42:14
linux
Dvorak, 2016-09-21 21:42:14

Why can't create a table?

Ran mysql, use bd_name, trying to make a table:

create table passport(id INT(50) NOT NULL AUTO_INTCREMENT PRIMARY KEY, name VARCHAR(35), pass VARCHAR(50));

And I get
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_INTCREMENT PRIMARY KEY, name VARCHAR(35), pass VARCHAR(50))' at line 1
Where is the error?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
sts, 2016-09-21
@allishappy

AUTO_IN ***T****CREMENT -- letter T is extra

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question