mysql数据库

mysql异常处理.sql

DROP PROCEDURE IF EXISTS demo;
CREATE PROCEDURE demo()
BEGIN
	DECLARE EXIT HANDLER FOR SQLWARNING,NOT FOUND,SQLEXCEPTION 
	BEGIN
		set @o_ret=-1; 
		SELECT -2;
		ROLLBACK;
	END;
	START TRANSACTION;		
		UPDATE inhospitalrecord 
		set nDirectionsId = 1
		WHERE sInHospitalId = 1;

/*ROW_COUNT() ==0 不会抛出异常*/

	COMMIT;
END;

call demo();

sort varhar as int.sql

ORDER BY CAST(`pic_number` AS SIGNED)
ORDER BY CAST(`pic_number` AS SIGNED) DESC
// output : 1; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7; 11; 14; 14a; 16;
// not : 1; 11; 14; 14a; 16; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7;

// http://dev.mysql.com/doc/refman/5.7/en/cast-functions.html#function_cast
// http://www.kreci.net/web-development/sort-varchar-as-int-in-mysql-query/