绝对小白写的,真是不知道从哪儿下手纠错:
delimiter $
CREATE PROCEDURE MEMORY2(IN count int)
BEGIN
DECLARE i integer(11);
DECLARE count integer(11);
DECLARE sqlstr VARCHAR(2560);
DECLARE siteCount integer(11);
DECLARE sqlinsert VARCHAR(2560);
set i = 1;
WHILE (i-1)<count DO
SET @sqlstr = CONCAT('CREATE TABLE memory',`@i`,'(
id int(10) not null auto_increment,
Time varchar(100),
EventType varchar(100),
EventTime int(50),
PackageName varchar(100),
ClassName varchar(100),
Text varchar(100),
ContentDescription varchar(100),
bounds varchar(100),
primary key(id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8');
prepare stmt from @sqlstr;
execute stmt;
SET @sqlinsert = CONCAT('
load data local infile "c:/txt/',`@i`,'.txt" into table memory',`@i`,'(Time,EventType,EventTime,PackageName,ClassName,Text,ContentDescription,bounds)'
);
prepare stmt from @sqlinsert;
execute stmt;
SET i= i+1;
END WHILE;
END
$
下面是调用:
delimiter $
set @count=3;
call MEMORY2(@count);
$
求大神们看看,急!
delimiter $
CREATE PROCEDURE MEMORY2(IN count int)
BEGIN
DECLARE i integer(11);
DECLARE count integer(11);
DECLARE sqlstr VARCHAR(2560);
DECLARE siteCount integer(11);
DECLARE sqlinsert VARCHAR(2560);
set i = 1;
WHILE (i-1)<count DO
SET @sqlstr = CONCAT('CREATE TABLE memory',`@i`,'(
id int(10) not null auto_increment,
Time varchar(100),
EventType varchar(100),
EventTime int(50),
PackageName varchar(100),
ClassName varchar(100),
Text varchar(100),
ContentDescription varchar(100),
bounds varchar(100),
primary key(id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8');
prepare stmt from @sqlstr;
execute stmt;
SET @sqlinsert = CONCAT('
load data local infile "c:/txt/',`@i`,'.txt" into table memory',`@i`,'(Time,EventType,EventTime,PackageName,ClassName,Text,ContentDescription,bounds)'
);
prepare stmt from @sqlinsert;
execute stmt;
SET i= i+1;
END WHILE;
END
$
下面是调用:
delimiter $
set @count=3;
call MEMORY2(@count);
$
求大神们看看,急!
解决方案 »
- mysql日期计算
- mysql文件拷贝产生的安全性问题?
- mysql enterprise monitor 中不显示CPU,内存信息
- 请问有没有xml和数据库(mysql)间数据转换的程序或组件等?
- 急!求Linux下用C对MySQL进行数据更新、插入、删除操作的函数
- 请问各位大哥,怎样在新装的MYSQL里新建一个用户,很急,请各位帮忙,感谢你们~!~~!~~! :(
- CSV格式文件数据导入新数据库后自动生成主键外键
- [求组]db2中的with ... as (...) 在mysql中应该如何表示
- 关于主外键和主键自增的问题
- 【求助】mysql查询用户的参数信息中参数列显示问题,请教。
- VS2012连接数据库时更改数据源找不到mysql的数据源
- 求解数据库原子操作
load data local infile "c:/txt/',`@i`,'.txt" into table memory',`@i`,'(Time,EventType,EventTime,PackageName,ClassName,Text,ContentDescription,bounds)'
c盘根目录下存在1.txt这样的文档且里面有数据,为什么没有数据导入到数据库呢
SET @sqlinsert = CONCAT('
load data local infile "c:/',i,'.txt" into table memory',i,' (Time,EventType,EventTime,PackageName,ClassName,Text,ContentDescription,bounds)'
);
prep
先运行drop table memory1;drop table memory2; ....drop table memoryN;
再重新call MEMORY2(@count);
还有建表不是临时的,如果drop掉不是用不了吗