Mysql timestamp query insert

Question

What is the problem with this query?

INSERT INTO acfrac (username,id,count,time) VALUES ("John Smith", 10, 0,2006-06-07 09:44:33.0)

It gives me the following error: 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 '09:44:33.0)' at line 1

In addition to quoting problems, count is reserved word. You almost certainly need to escape it. ie enclose it in back tics. — Leigh
– Leigh, Commented May 18, 2012 at 6:46

Reza S · Accepted Answer · 2012-05-17 06:56:07Z

2

You need to quote your time stamp. In mysql, if the field you're entering is not an integer, it must be quoted.

answered May 17, 2012 at 6:56

Reza S

9,8045 gold badges58 silver badges91 bronze badges

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

Comments

somnath · Accepted Answer · 2012-05-17 06:57:42Z

1

Try this:

INSERT INTO acfrac (username,id,count,time) VALUES ("John Smith", 10, 0,'2006-06-07 09:44:33.0')

The date and datetime values need to be enclosed in single quotes.

answered May 17, 2012 at 6:57

somnath

1,3351 gold badge9 silver badges13 bronze badges

Comments

Crean Culty · Accepted Answer · 2023-09-26 14:38:55Z

1

I just encounter the same problem with you, I just saw the comment and add quotes with my time-stamp data type column and finally it going to work. It helps me a lot.

answered Sep 26, 2023 at 14:38

Crean Culty

113 bronze badges

Collectives™ on Stack Overflow

Mysql timestamp query insert

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related