Mysql function select into不能给变量赋值
我在myqsl的function中写了这么一句:
SELECT COUNT(*) into intWorkDays from bf_Calendar where date between CAST('2009-01-14 15:23:36' AS datetime) and CAST('2009-01-16 15:00:00' AS datetime) and workday='0';
可是我在下面调用intWorkDays 变量时,intWorkDays =0,并没有得到我想要的值
整个function的代码如下:
CREATE DEFINER=`root`@`localhost` FUNCTION `NewFunction`(Timefrom DateTime,TimeTo DateTime) RETURNS int(11)
BEGIN
DECLARE intWorkDays int;
DECLARE intMinutes int;
DECLARE WorkDay char(1);
DECLARE Time800 datetime;
DECLARE Time1200 datetime;
DECLARE Time1700 datetime;
DECLARE Time1300 datetime;
DECLARE TimefromDate dateTime;
DECLARE TimeToDate dateTime;
DECLARE TimefromTime dateTime;
DECLARE TimeToTime dateTime;
DECLARE AMMinues int;
DECLARE PMMinutes int ;
set TimefromDate= cast( date(Timefrom) as datetime);
set TimefromTime= from_UNIXTIME( UNIX_TIMESTAMP(Timefrom) - UNIX_TIMESTAMP(TimefromDate));
set TimeToDate= cast( date(TimeTo) as datetime);
set TimeToTime= from_UNIXTIME( UNIX_TIMESTAMP(TimeTo) - UNIX_TIMESTAMP(TimeT
相关问答:
我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("数据库连接失败") ......
有个winform程序,使用c#+mysql,需要在一个窗体设置mysql自动删除功能,包括自动删除多少天之前的数据以及是否开启自动删除功能,我程序退出后,还怎么控制Mysql自己删除啊?是不是要用mysql的event来实现?c#可以调用mysq ......
SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
我开发ASP.net时
插入外文乱码
SHOW VARIABLES LIKE 'character%';
这个时候
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
想请教一个问题,ASP+mysql 会不会有连接默认时间。
我遇到一个问题:我在页面上按一个Save按钮,这个按钮是循环运行100篇 insert数据的存储过程。 asp代码应该没有错的,数据我是放在一个数组的如果我只保存50个是 ......