MySQL Forums
Forum List  »  MySQL Shell

mySQL - error 1064
Posted by: Dominik Jancarik
Date: October 23, 2021 09:57AM

Hello all,
can not help why durring create simple table in MySQL showing me this error? whats wrong? please help I am a begginer


mysql> create table friends
-> (lastname varchar(15) not null,
-> firstname varchar(15) not null,
-> callprefix number(9) null,
-> phone varchar(10) null,
-> region char(2) not null,
-> zip varchar(5) null);
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 'number(9) null,
phone varchar(10) null,
region char(2) not null,
zip' at line 4
mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
mySQL - error 1064
642
October 23, 2021 09:57AM
368
October 23, 2021 12:24PM
266
October 24, 2021 02:27AM
361
October 24, 2021 10:43AM
268
October 26, 2021 02:31AM
282
October 26, 2021 03:58AM
318
October 26, 2021 05:03AM
291
October 26, 2021 09:40AM
282
October 26, 2021 09:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.