稻香的专栏

直接上代码 package Test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Tes

CREATE VIEW  CASHPOINTOTHER    as  SELECT pay_log_cash.*, '1' as 'payType'  FROM pay_log_cash     UNION ALL SELECT pay_log_other.*,  '2' as 'payType'  FROM pay_log_other UNION ALL SELECT pay_

DROP PROCEDURE test_insert ; DELIMITER ;; CREATE PROCEDURE test_insert () BEGIN DECLARE i INT DEFAULT 0; WHILE i DO INSERT INTO   pay_log_1 ( order_key,  cms_order_key,  userkey,