我有想给 id(471-541)中的没一个用户增加一条相同数据,请问mysql中怎么写这个循环语句
解决方案 »
- 问一个关于mysql 表级锁 页级锁 行级锁 的问题
- mysql设置外键来查询与不设置外键建立联合查询有什么不同?
- mysql with rollup 多组统计 如何去掉子项汇总,保留最后条汇总?
- postgresql 使用索引进行查询的用法
- mysql在like中关键字设定的问题
- 请教mysql存储过程的分页写法?谢谢
- mysql存储过程支持类似return,exit 的返回语句吗?语法是怎样的?谢谢!
- ERROR 1045:不能用mysql操作数据库,可以用mysql-front操作,怎么回事?
- 请教一下,取本周日对应的日期,怎么计算呢
- mysql如何去除重复的关系对
- rand by order如何检索掉某些ID为空的数据条?
- 从mysql 中取出 最后十条 msg = 101 的记录
(
id int not null auto_increment primary key,
flag bit
) auto_increment=471 ENGINE=MEMORY;INSERT INTO seqnumber(flag)
SELECT 0 FROM information_schemas.COLUMNS LIMIT 70;CREATE TEMPORARY TABLE tmp_tb ENGINE=MEMORY
AS
SELECT
A.id,'username' AS username
FROM seqnumber AS A
LEFT JOIN tb AS B
ON A.id=B.id
WHERE B.id IS NULL;INSERT tb(id,username) SELECT * FROM tmp_tb;
drop procedure if exists ff $$
CREATE /*[DEFINER = { user | CURRENT_USER }]*/
PROCEDURE `rr`.`ff`()
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN
declare i integer;
set i=1;
while i<=100 do
begin
操作
end;
end while; END$$DELIMITER ;
drop procedure if exists ff $$
CREATE PROCEDURE `rr`.`ff`()
BEGIN
declare i integer;
set i=471;
while i <=541 do
begin
操作
SET I=I+1;
end;
end while; END$$DELIMITER ;
You have an error in your SQL syntax:check the manual tahe coprresponds to your MySQL server verion for the right synrax to user near' DELIMITER $$
drop procedure if exists ff $$
CREATE PROCEDURE `rr`.`ff`()'
at line 1
那个操作那点我想写的是 insert into localtest(name,author) values('默认相册',????); name='默认相册',是固定的;author 就是要循环的那个i的值,可以写完整下吗,谢谢,mysql 才开始弄
DELIMITER $$DROP PROCEDURE IF EXISTS `rr`.`ff`$$CREATE DEFINER=`root`@`localhost` PROCEDURE `ff`()
BEGIN
declare i integer;
set i=1;
while i<=100 do
begin
insert into localtest(name,author) values('默认相册',i);
SET I=I+1;
end;
end while;
END$$DELIMITER ;