MYSQL

Question

My Model table column MOD_WAIT_CHG has same datatype numeric since I am dropping & sign.
My charter table has column CHAR_WAIT_CHG which is also numeric.
I have to copy the data from MOD_WAIT_CHG to CHAR_WAIT_CHG

I used the statement
INSERT INTO CHARTER(CHAR_WAIT_CHG) SELECT MOD_WAIT_CHG FROM MODEL
WHERE MOD_WAIT_CHG = 100
I m getting an error red line under CHAR_WAIT_CHG when I hover my mouse the error is invalid column

Answer 1

query seems fine
check for column name and the database collation for case sensitiveness