select order_no, `status`, transmit_flg from orders;
update orders set transmit_flg = 0 ;
select order_no,`status`, transmit_flg from orders;
select order_no, `status`, transmit_flg from orders where `status`=39;
http://www.mitene.or.jp/~rnk/TIPS_ORCL_UPDATE.htm
http://www.mitene.or.jp/~rnk/index.htm
不错的博客,有关VB和SQL文的