简单数据库迁移存储过程(一)
CREATE DEFINER=`root`@`localhost` PROCEDURE `first`()
BEGIN
#Routine body goes here...
-- 迁移同库用户表
INSERT users(username,password,email)
SELECT uname,upassword,uemail FROM t_users;
-- 同服务器下跨数据库表迁移
INSERT admin(username,mbrAccount,password,truename,add_time,gid,gname,status)
SELECT username,mbrAccount,password,truename,add_time,gid,gname,status FROM dev.admin;
END