小弟在学习存储过程,没发现这个错误在呢阿CREATE PROCEDURE P8()
BEGIN
DECLARE a INT;
DECLARE b INT;
SET a = 5;
SET b = 5;
INSERT INTO t VALUES (a);
SELECT s1 * a FROM t WHERE s1>=b;
END;
BEGIN
DECLARE a INT;
DECLARE b INT;
SET a = 5;
SET b = 5;
INSERT INTO t VALUES (a);
SELECT s1 * a FROM t WHERE s1>=b;
END;
解决方案 »
- A/B表为1对多关系,要求联合查询B表只提取一条与A记录关联的记录
- Mysql中有没有方法知道当前表已经被锁定。
- mysql 能不能像SQLServer一样 添加外联服务器
- 一条简单语句错在哪
- mysql已经指定主键了,为什么用phpMyAdmin插入的时候,主键设置为空也不报错啊?
- 模糊匹配!!!!!!
- 如何进行分析SHOW INNODB STATUS
- mysql+odbc3.51+asp不能addnew插入问题,百分求解!
- 在J2EE中,如何连到Mysql数据库,平台是Linux
- 求助!各位高手,用DELPHI7的ADOQUERY查询MYSQL数据厍时出现class eacessviocation whit message access violation at address 100072 in m
- 很急,高人进,mySql数据库定时自动计算,存贮数据表功能。
- mysql数据库数问题,为什么数据库连接数会大于我设置的值
另外你的表T中到底几个字段? s1 哪来的?建议列出你的 create table t .. 的语句。
select * from t where s1>=b;
什么错误信息
BEGIN
DECLARE a INT;
DECLARE b INT;
SET a = 5;
SET b = 5;
as
INSERT INTO t VALUES (a);
SELECT s1 * a FROM t WHERE s1>=b;
END;
mysql> CREATE PROCEDURE P8()
-> BEGIN
-> DECLARE a INT;
-> DECLARE b INT;
-> SET a = 5;
-> SET b = 5;
-> INSERT INTO t VALUES (a);
-> SELECT s1 * a FROM t WHERE s1>=b;
-> END $$
Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;
执行成功!
mysql> create table t (s1 int);
Query OK, 0 rows affected (0.13 sec)mysql> delimiter //
mysql> CREATE PROCEDURE P8()
-> BEGIN
-> DECLARE a INT;
-> DECLARE b INT;
-> SET a = 5;
-> SET b = 5;
-> INSERT INTO t VALUES (a);
-> SELECT s1 * a FROM t WHERE s1>=b;
-> END//
Query OK, 0 rows affected (0.31 sec)mysql> delimiter ;
mysql> call P8();
+--------+
| s1 * a |
+--------+
| 25 |
+--------+
1 row in set (0.09 sec)Query OK, 0 rows affected (0.09 sec)mysql>
这个必须加吗? 我用phpadminmysql在写阿