+ 2

MYSQL

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

21st Jul 2022, 2:50 AM
Knowledge Is Power
Knowledge Is Power - avatar
1 Answer
+ 2
query seems fine check for column name and the database collation for case sensitiveness
17th Mar 2023, 6:22 PM
Harsha S
Harsha S - avatar