Nobody explain that you have to put the same name of the column
Example:
table car2(
idcar
model
window
color
power
)
table car1(
idcar
model
)
now yo want to copy some data from car1 to car2
you only have to do this:
Code:
insert into car2(idcar,model,color,power) select idcar,model,'Black'
Leave a comment: