MySQL server version : Mysql error while inserting into the table

Question

INSERT INTO project_categories (id, category_id, project_id, company_id, created_at, updated_at) VALUES (385, 1, 88, NULL, now(), now());

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 'INSERT INTO project_categories (id, category_id, project_id, company_id, c' at line 1

Can you check your insert statement? It is not closed at the end and might be cut aswell — davidev, Apr 13 '20 at 12:43
Updated ``` INSERT INTO project_categories (id, category_id, project_id, company_id, created_at, updated_at) VALUES (385, 1, 88, NULL, now(), now()); ``` — Bhupendra Singh Rautela, Apr 13 '20 at 12:45
That doesn't look like the statement from before Mysql never adds ’ with a NOW() — nbk, Apr 13 '20 at 12:46
INSERT INTO project_categories VALUES (385, 1, 88, NULL,'2020-04-03 18:14:01.000000', '2020-04-03 18:14:01.000000'); — Bhupendra Singh Rautela, Apr 13 '20 at 12:47
Do you use some statement which includes more than one query? — Akina, Apr 13 '20 at 12:54
Your code [works fine](https://dbfiddle.uk/?rdbms=mysql_5.7&fiddle=c0b7378a808297ed3db5d57c871908a2). Please provide a minimum reproducible example that demonstrates the issue. — GMB, Apr 13 '20 at 13:08

nbk · Answer 1 · 2020-04-13T13:30:54.630

1

Instead of

’2020-04-03 18:14:01.000000’

Use

'2020-04-03 18:14:01.000000'

Please read

This works see

It is your query, only without the now part that should work anyway.

INSERT INTO project_categories (id, category_id, project_id, company_id, created_at, updated_at) VALUES (385, 1, 88, NULL,'2020-04-03 18:14:01.000000', '2020-04-03 18:14:01.000000');

edited Apr 13 '20 at 13:30

answered Apr 13 '20 at 12:44

nbk

45,398
8
30
47

Not helpful this way. – Bhupendra Singh Rautela Apr 13 '20 at 12:49
Yes it does see picture – nbk Apr 13 '20 at 12:58
Send me this query please. – Bhupendra Singh Rautela Apr 13 '20 at 12:59
added in answer – nbk Apr 13 '20 at 13:31

MySQL server version : Mysql error while inserting into the table

1 Answers1