我有一个表格,里面就两种产品,ipod1代和2代,如何将他们提取出来后存储倒新得table中去?能否在一个程序中完成?就是不知道怎么在程序中建表格并把数据添加进去,下面是一个错误得代码,但是表达了我一点思路,请高手指点!!!急~~非常感谢!!!DELIMITER $$DROP PROCEDURE IF EXISTS `alatest`.`second` $$
CREATE PROCEDURE `alatest`.`second` ()
BEGIN
SELECT * FROM ipod
where productname like "%2nd%" or (productname like "%second%")
or (productname like "%2.G%") or (productname like "%IW270%") or (productname like "%do%")
(
CREATE TABLE `alatest`.`2ndGen` (
`productname` VARCHAR(900) NOT NULL DEFAULT '',
`al_id` VARCHAR(45) NOT NULL DEFAULT '',
`Source_id` INTEGER UNSIGNED NOT NULL DEFAULT 0
)
ENGINE = InnoDB;
) ;END $$DELIMITER ;
CREATE PROCEDURE `alatest`.`second` ()
BEGIN
SELECT * FROM ipod
where productname like "%2nd%" or (productname like "%second%")
or (productname like "%2.G%") or (productname like "%IW270%") or (productname like "%do%")
(
CREATE TABLE `alatest`.`2ndGen` (
`productname` VARCHAR(900) NOT NULL DEFAULT '',
`al_id` VARCHAR(45) NOT NULL DEFAULT '',
`Source_id` INTEGER UNSIGNED NOT NULL DEFAULT 0
)
ENGINE = InnoDB;
) ;END $$DELIMITER ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货