Kamis, 06 September 2012

SQL: Insert Into Table From Other Table

if you find error when executing:
 "insert into yourtable values(select col1,col2,col3 from yourothertable)"

use this statement instead of this:
 "insert into yourtable select col1,col2,col3 from yourtable"

you don't need to add values on your SQL.

thanks.
-ok-

Tidak ada komentar: