我想创建一个在其中包含变量的存储过程,所以我创建了以下代码BEGINEND#1064- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versionfor the right syntax to use near '@var INT' at line 3
我已经尝试了stackov
当我从mysql控制台或MySQL工作台更改定界符时,我没有得到任何错误,但当我在ruby on rails中嵌入相同的代码时,我得到了错误mysql>ActiveRecord::Base.connection.execute(%Q{})ActiveRecord::StatementInvalid: Mysql
我正在尝试创建我的第一个mysql存储过程,并且尝试几乎直接从文档中复制一些示例,但它不起作用:mysql> CREATE PROCEDURE ghost.testERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL这几乎等
DELIMITER $$
BEGIN WHILE (i <= 100) DOINSERT INTO VISITS VALUES ("C9YAoq", "2022-05-03 00:00:00"); END WHILE;错误
You have an error in your SQL syntax; check