Answer the question
In order to leave comments, you need to log in
What is wrong in mysql syntax?
Here is the request
INSERT INTO `articles_post` (`id`,`created_at`,`updated_at`,`user_id`,`title`,`content`,`excerpt`,`status`,`media_id`) VALUES
(`1`,`2017-12-11 11:31:22`,`2017-12-11 11:31:25`,`5`,`Test12`,``,``,`draft`,NULL);;;
Answer the question
In order to leave comments, you need to log in
Backticks `
denote database names, tables, fields, aliases, and so on. Strings are denoted by straight single '
or double "
quotes.
Well, to the above from Rsa97, I give the request itself, what it should be like in the end, pay attention to the direct single quotes:
INSERT INTO `articles_post` (
`id`,
`created_at`,
`updated_at`,
`user_id`,
`title`,
`content`,
`excerpt`,
`status`,
`media_id`
) VALUES (
'1',
'2017-12-11 11:31:22',
'2017-12-11 11:31:25',
'5',
'Test12',
'',
'',
'draft',
NULL
);
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question