对mysql不是很熟。。
DROP PROCEDURE IF EXISTS InsertUserInfo;
create PROCEDURE InsertUserInfo()
BEGIN
DECLARE i int DEFAULT 0;
START TRANSACTION;
DECLARE username VARCHAR(20);
WHILE i<600000 DO
set username= concat('test', i);
INSERT INTO userinfo
(
CompanyId,LoginName,Password,UserType,SurName,GivenName,Gender,DOB,
IDCardNum,TelOffice,TelMobile,Email,IM1,IM2,Fax,LastLoginTime,LoginCount,
Status,Notes,Flag,CreateUser,CreateTime,CreateIP
)
VALUES
(
0,username,'e10adc3949ba59abbe56e057f20f883e',30,'test','test','M',
'2010-12-16 00:00:00','440921198406082356','0750-88888888','1369999999','[email protected]','222222',
'222222','0750-5555555555','2010-12-16 00:00:00',20,1,'test','M',1,'2010-12-16 00:00:00','192.168.1.90'
); set i=i+1;
END WHILE;
COMMIT;
END
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE @username VARCHAR(20);
WHILE i<600000 DO
set @u' at line 5
DROP PROCEDURE IF EXISTS InsertUserInfo;
create PROCEDURE InsertUserInfo()
BEGIN
DECLARE i int DEFAULT 0;
START TRANSACTION;
DECLARE username VARCHAR(20);
WHILE i<600000 DO
set username= concat('test', i);
INSERT INTO userinfo
(
CompanyId,LoginName,Password,UserType,SurName,GivenName,Gender,DOB,
IDCardNum,TelOffice,TelMobile,Email,IM1,IM2,Fax,LastLoginTime,LoginCount,
Status,Notes,Flag,CreateUser,CreateTime,CreateIP
)
VALUES
(
0,username,'e10adc3949ba59abbe56e057f20f883e',30,'test','test','M',
'2010-12-16 00:00:00','440921198406082356','0750-88888888','1369999999','[email protected]','222222',
'222222','0750-5555555555','2010-12-16 00:00:00',20,1,'test','M',1,'2010-12-16 00:00:00','192.168.1.90'
); set i=i+1;
END WHILE;
COMMIT;
END
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE @username VARCHAR(20);
WHILE i<600000 DO
set @u' at line 5
解决方案 »
- Lost connection to MySQL server during query
- SQL性能(REPLACE/SELECT+INSERT+UPDATE/INSERT...ON DUPLICATE KEY)
- mysql可以直接用文件做数据备份吗?
- MySQL写取字段名语句
- excel导入mysql问题
- mssql中同一张表中如何删除相同的纪录???
- 数据库里的一个小问题^_^
- 关于mysqldump的问题
- 关于Limit 的问题?不知是MySQL的bug?
- 新手提问:求SQL语句 取得最新的记录
- 关于Information_schema和Mysql库的问题.
- mysql中能在C程序中通过嵌入式SQL(Embedded SQL)访问数据库么?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE username VARCHAR(20);
WHILE i<600000 DO
SET use' at line 5
create PROCEDURE InsertUserInfo()
BEGIN
DECLARE i int DEFAULT 0;
DECLARE username VARCHAR(20);
START TRANSACTION;
===
DECLARE 必须放在其它语句之前。
DROP PROCEDURE IF EXISTS InsertUserInfo $$
CREATE PROCEDURE InsertUserInfo()
BEGIN
DECLARE i INTEGER DEFAULT 0;
DECLARE username VARCHAR(20);
START TRANSACTION;
WHILE i<600000 DO
SET username=CONCAT('test', i);
INSERT INTO userinfo
(
CompanyId,LoginName,PASSWORD,UserType,SurName,GivenName,Gender,DOB,
IDCardNum,TelOffice,TelMobile,Email,IM1,IM2,Fax,LastLoginTime,LoginCount,
STATUS,Notes,Flag,CreateUser,CreateTime,CreateIP
)
VALUES
(
0,username,'e10adc3949ba59abbe56e057f20f883e',30,'test','test','M',
'2010-12-16 00:00:00','440921198406082356','0750-88888888','1369999999','[email protected]','222222',
'222222','0750-5555555555','2010-12-16 00:00:00',20,1,'test','M',1,'2010-12-16 00:00:00','192.168.1.90'
); SET i=i+1;
END WHILE;
COMMIT;
END $$
DELIMITER ;