gg_130的博客

实例  UPDATE product_order po  INNER JOIN product_customer pc ON pc.product_id = po.pro_id INNER JOIN customer c ON c.id = pc.customer_id SET po.product_time = DATE_SUB(po.delivery_date,INTERV

语法 INSERT INTO a(a1,a2)  SELECT  b1,b2 FROM b 实例 INSERT INTO pur_material ( NAME, price, amount, money, comedate, origin ) SELECT `name`, order_price, order_amount, order_money, come_