MySQL error while "insert" command

Question

The following is the schema of my table (name->add_to_cart);

add_to_cart_id   int(10) PK
created_date     timestamp
ip_address       varchar(17)
customer_id      int(11)
session_id       varchar(1024)
brand_id           int(11)
product_id       int(11)
sales_event_id   int(11)
quantity         int(11)
referer          varchar(1024)
user_agent       varchar(1024)

But whenever I am trying to do execute the following query

INSERT INTO `add_to_cart` (add_to_cart_id,created_date,ip_address,customer_id,session_id,sku_id,product_id,sales_event_id,quantity,referer,user_agent) VALUES (1,2011-02-24 20:40:34,66.65.135.89,70154,qbk5r0rg9sl2ndiimquvnsab46,83791,308933,10105,2,https://www.onekingslane.com/product/10105/308933,Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_5; en-us) AppleWebKit/533.19.4 (KHTML);

I get the following error

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 '20:40:34,66.65.135.89,70154,qbk5r0rg9sl2ndiimquvnsab46,83791,308933,10105,2,http' at line 1 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 'U' at line 1 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 'Intel Mac OS X 10_6_5' at line 1 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 'en-us) AppleWebKit/533.19.4 (KHTML)' at line 1

What am i doing wrong. Thanks.

Joe · Accepted Answer · 2011-09-14 21:55:40Z

7

You need to quote string values

INSERT INTO `add_to_cart`
(
    add_to_cart_id,
    created_date,
    ip_address,
    customer_id,
    session_id,
    sku_id,
    product_id,
    sales_event_id,
    quantity,
    referer,
    user_agent
)
VALUES
(
    1,
    '2011-02-24 20:40:34',
    '66.65.135.89',
    70154,
    'qbk5r0rg9sl2ndiimquvnsab46',
    83791,
    308933,
    10105,
    2,
    'https://www.onekingslane.com/product/10105/308933,Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_5; en-us) AppleWebKit/533.19.4 (KHTML);'
)

answered Sep 14, 2011 at 21:55

Joe

15.8k4 gold badges52 silver badges84 bronze badges

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

4 Comments

TehShrike Over a year ago

What Joe said - strings go in single-quotes, numbers do not. Escape your strings, don't escape your numbers.

frazman Over a year ago

Hey.. Yeah.. stackoverflow asks me to wait for sometime before i accept an answer.. :P

Joe Over a year ago

No worries, it does do that :P Cheers

KNU Over a year ago

the mistake is as common as missing a ; (semi-colon) in C/C++/Java and other high-level languages

Collectives™ on Stack Overflow

MySQL error while "insert" command

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related