Last answered:

08 Mar 2021

Posted on:

06 Mar 2021


How do insert data in a null field of an existing row

I reviewed the IF NULL and COALESCE lessons but it creates only a duplicate column that fills in the null value. How do insert a value in an existing row indicated as null in an existing column? I tried INSERT INTO but I don't know how to insert in an existing row, only how to create a new row. I tried adding a WHERE clause but it gives me a syntax error.

1 answers ( 0 marked as helpful)
Posted on:

08 Mar 2021


Hi Helen!

Thanks for reaching out.

That's what an INSERT statement does - it inserts a new record. Otherwise, you can use an UPDATE statement.
Please feel free to provide an example of a table/a state of a table, so that we can assist you more specifically.

Hope this helps.

Submit an answer