Table12.18Information Functions Name Description BENCHMARK() Repeatedly execute an expression CHARSET() Return the character set of the argument COERCIBILITY() Return the collation coercibility value of the string argument COLLATION() Return the col...

2018-06-17 22:59:59

MySQL是多用户多线程的DBMS，默认支持的存储机制是 InnoDB，InnoDB 通过建立行级锁保证事务的完整性，通过共享锁处理 select 语句，以提供事务安全的存储机制。 引擎管理和处理数据，MySQL支持多种引擎： InnoDB ：提供可靠的事务处理，但不支持全文本搜索。 MyISAM ：...

2018-06-17 22:59:52

MySQL Cursor Summary: in this tutorial, you will learn how to useMySQL cursorin stored procedures to iterate through a result set returned by a SELECT statement. Introduction to MySQL cursor To handle a result set inside astored procedure, you use a...

2018-06-17 22:59:56

http://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html GET [CURRENT | STACKED] DIAGNOSTICS{ statement_information_item [, statement_information_item ] ... | CONDITION condition_number condition_information_item [, condition_information_item ] ....

2018-06-17 22:59:53

http://pymssql.org/en/latest/pymssql_examples.html Example scripts using pymssql module. Basic features (strict DB-API compliance) from os import getenv import pymssql server = getenv ( "PYMSSQL_TEST_SERVER" ) user = getenv ( "PYMSSQL_TEST_USERNAME"...

2018-06-17 22:59:46

http://www.cnblogs.com/qixuejia/archive/2010/12/21/1913203.html sql server中变量要先申明后赋值： 局部变量用一个@标识，全局变量用两个@（常用的全局变量一般都是已经定义好的）； 申明局部变量语法：declare @变量名 数据类型；例如：declare @num int； 赋值：...

2018-06-17 22:59:50

优点： 索引是对数据库表中一列或多列的值进行排序的一种结构，使用索引可快速访问数据库表中的特定信息。 普通查询，必须遍历整张表，知道找到该值，如果在该列上建立了索引，即可在索引中查找，由于索引是经过算法优化过的，因而查找次数要少的多。可见，索引是用来...

2018-06-17 22:59:49

http://www.mysqltutorial.org/mysql-signal-resignal/ Summary : in this tutorial, you will learn how to use SIGNAL and RESIGNAL statements to raise error conditions inside stored procedures. MySQL SIGNAL statement You use the SIGNAL statement to retur...

2018-06-17 22:59:45

http://blog.csdn.net/crazylaa/article/details/5368421 有时候，不希望存储过程抛出错误中止执行，而是希望返回一个错误码。MySQL支持异常处理，通过定义CONTINUE/EXIT异常处理的HANDLER来捕获SQLWARNING/NOT FOUND/SQLEXCEPTION（警告/无数据/其他异常）。其中，FOR...

2018-06-17 22:59:40

Summary: this tutorial shows you how to use MySQL handler to handle exceptions or errors encountered in stored procedures. When an error occurs inside a stored procedure, it is important to handle it appropriately, such as continuing or exiting the...

2018-06-17 22:59:37