我有一个日期时间类型的列,我在存储过程中使用它,将两个局部变量声明为@From datetime and @To datetime,但是无论我做什么,我都会得到错误,或者它只是运行存储过程而不返回任何记录set @mySql ='
select * from abc where (MyDATE between '''+ cast(@From as datetime) +''' and '''+ cast
enter code here
set @s = Concat("select datetime , element NODE,",@data," RESULTS fromloas");
INSERT INTO KPI_results(date_time,node_name,results) values(execute STMT
SET @tableName := 'de-Table'在MariaDB中,这个错误是隐秘的,并且(像往常一样)根本没有帮助:
/* SQL Errorthe manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT * FROM