Hi all, I want to send some columns values from one table to other in mysql.
table1 = courses1
table2 = courses
each table has primary key courseID.
when i used
insert into courses(courseID) select courseID from courses1
it works properly.../// courseID is a primary key..
but when I used the similar kind statement by changing the column names its not working and showing the error as
how to pass these values ?