What will be the database query?

Question

I have a table as shown and I am trying to insert the data to it but I am constantly getting error . Can anyone suggest what should be the query ??

Here's my table structure:

My insert query:

INSERT INTO country (id, country_name, iso_code, country_pic_url, rank, created_time, updated_time, deleted_time) VALUES(1, 'Afghanistan', 'AF', null, 0, '2013-09-04 13:30:00', '2013-09-04 13:30:00', '2013-09-04 13:30:00')

Try to share the query and the error in the actual question, correctly formatted as text — Evert, Jul 11 '20 at 06:15
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-R — Strawberry, Jul 11 '20 at 06:36

Anurag Dhadse · Answer 1 · 2020-07-11T06:28:35.550

-1

Don't use null instead Put NULL in your syntax or either leave it blank.

Check if the rank you are trying to put is a string, so instead of just using 0, put '0' in your query.

edited Jul 11 '20 at 06:28

answered Jul 11 '20 at 06:15

Anurag Dhadse

1,722
1
13
26

Thank you for the reply .. but this is also not working and giving the same error. – Neeraj N Jul 11 '20 at 06:19
provide the written code of the query to create this table. – Anurag Dhadse Jul 11 '20 at 06:20
I have edited the question and added the query over there – Neeraj N Jul 11 '20 at 06:26
@NeerajN if the value is `DEFAULT NULL` you don't need to explicitly use null at all leave it blank – Anurag Dhadse Jul 11 '20 at 06:31
I replaced my null value to some string value , but it is still giving me the same error – Neeraj N Jul 11 '20 at 06:50

What will be the database query?

1 Answers1