it copies a row from one table to another.
ex. :insert into tabel_A (id_A, desc_A, price_A, hari, pDate, pUser) select id, desc, price, ‘Rabu’, CURRENT_DATE, ‘user_yg_masukin’ from tabel_A where id_A=’1′;
About ummi hasya
copy row from one table to another
http://www.mysql.com/doc/en/INSERT_SELECT.html
it copies a row from one table to another.
ex. :insert into tabel_A (id_A, desc_A, price_A, hari, pDate, pUser) select id, desc, price, ‘Rabu’, CURRENT_DATE, ‘user_yg_masukin’ from tabel_A where id_A=’1′;
it copies a row from one table to another.
ex. :insert into tabel_A (id_A, desc_A, price_A, hari, pDate, pUser) select id, desc, price, ‘Rabu’, CURRENT_DATE, ‘user_yg_masukin’ from tabel_A where id_A=’1′;
0 comments:
Post a Comment