lihaiyong92的博客

Excel 快速生成 SQL

从 bd_house 查询 houseId, houseName, 插入 bd_house_customerDROP PROCEDURE IF EXISTS insert_extra_column_test;DELIMITER //CREATE PROCEDURE insert_extra_column_test()BEGIN -- 声明变量 DECLARE newId LONG; DECLARE houseId LONG; DECLARE houseName VARCHAR...

DROP PROCEDURE IF EXISTS pro_AddColumn;DELIMITER $$CREATE PROCEDURE pro_AddColumn( IN bdname VARCHAR(50), IN tablename VARCHAR(50), IN colname VARCHAR(50), IN coltype VARCHAR(20), IN coldesc VARCHAR(50) )BEGIN if not exists(select 1 from in.