MySQL - Issue with running the INSERT INTO query

Question

Can someone tell me what did I do wrong on this insert statement:

INSERT INTO inventory (typer, prodid, Description, Loc, Price, Total, Available) 
Values('Head', 'H001', 'KosMom - Blue', 'G:\Tesd\', '48.00', 5, 5);


inventory table:
uid - int - key
typer - varchar 255
prodid - varchar 255
Description - varchar 255
Loc - text
Price - text
Total - int
Available - int

Error when run the query:

INSERT INTO inventory (typer, prodid, Description, Loc, Price, Total, Available) 
Values('Head', 'H001', 'KosMom - Blue', 'G:\Tesd\', '48.00', 5, 5);
> 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 
'48.00', 5, 5)' at line 2
> Time: 0s

It's odd to store prices as text

Strawberry
– Strawberry

2020-06-28 11:20:58 +00:00
Commented Jun 28, 2020 at 11:20 — Strawberry
– Strawberry, Commented Jun 28, 2020 at 11:20

Gordon Linoff · Accepted Answer · 2020-06-28 10:34:28Z

2

Backslashes are escape characters. Try doubling them:

Values('Head', 'H001', 'KosMom - Blue', 'G:\\Tesd\\', '48.00', 5, 5);

answered Jun 28, 2020 at 10:34

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

John Hang Over a year ago

That worked. I didn’t think that would be the problem.

Strawberry Over a year ago

@JohnHang or use "

Collectives™ on Stack Overflow

MySQL - Issue with running the INSERT INTO query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related