How to fix MySQL INSERT INTO (Syntax Error)?

Question

This is my code

USE `es_extended`;

INSERT INTO `users` (
  `license` varchar(50),
  `money` int(11),
  `bank` int(11),
  `permission_level` int(11)
);

And every time I try to import it to my database I got this error

#1064 - 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 'varchar(50),
  `money` int(11),
  `bank` int(11),
  `permission_level` int(11)
)' at line 2

First thing you need to do before asking question here is read the basics of you want to use: mysqltutorial.org/mysql-insert-statement.aspx — ikiK
– ikiK, Commented Sep 16, 2020 at 19:35
Probably reading a SQL book will be a good start. Even I don't know what you are trying to do. — Eric
– Eric, Commented Sep 16, 2020 at 19:52

Svein Terje Gaup · Accepted Answer · 2020-09-16 19:54:40Z

2

This will create your table:

Create table `users` ( `license` varchar(50), `money` int(11), `bank` int(11), `permission_level` int(11) );

To insert you could do:

Insert into  `users` ( `license`, `money`, `bank`, `permission_level`) values ('test', 123, 456, 789)

edited Sep 16, 2020 at 19:54

answered Sep 16, 2020 at 19:49

Svein Terje Gaup

1,6182 gold badges17 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

How to fix MySQL INSERT INTO (Syntax Error)?

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