|
摘要：
語法PREPARE statement_name FROM sql_text /*定義*/EXECUTE statement_name [USING variable [,variable...]] /*執行預處理語句*/DEALLOCATE PREPARE statement_name /*刪除定 阅读全文
posted @ 2018-04-30 18:10
ecwork
阅读(229)
评论(0)
推荐(0)
摘要：
Transactions A transaction is a set of statements all of which need to complete or none of which should complete. In many complex cases, it's impossib 阅读全文
posted @ 2018-04-25 07:42
ecwork
阅读(285)
评论(0)
推荐(0)
摘要：
Now that we understand functions and procedures and how to use them, it's a good time to talk about Triggers. A trigger is a set of sql statements whi 阅读全文
posted @ 2018-04-10 12:54
ecwork
阅读(167)
评论(0)
推荐(0)
摘要：
安装环境centos 7 64bit，puppet 5版本 1. 安装master端 在puppet的网站查找需要安装的yum repository，https://puppet.com/docs/puppet/5.5/puppet_platform.html#yum-based-systems 确 阅读全文
posted @ 2018-03-27 06:44
ecwork
阅读(605)
评论(0)
推荐(0)
摘要：
Handling Errors(条件处理(Condition Handling) / 错误、异常处理)Declaring a handler To declare a handler, you use the DECLARE HANDLER statement as follows: DECLARE 阅读全文
posted @ 2018-03-20 06:39
ecwork
阅读(278)
评论(0)
推荐(0)
摘要：
MySQL Programming is more than just writing stored procedures and functions. It's about designing the entire table structure to best fit the applicati 阅读全文
posted @ 2018-03-07 07:56
ecwork
阅读(162)
评论(0)
推荐(0)
摘要：
SQL Mode Modes affect the SQL syntax MySQL supports and the data validation checks it performs. This makes it easier to use MySQL in different environ 阅读全文
posted @ 2018-02-25 15:53
ecwork
阅读(188)
评论(0)
推荐(0)
摘要：
CREATE PROCEDURE 由括号包围的参数列必须总是存在。如果没有参数，也该使用一个空参数列()。每个参数 默认都是一个IN参数。要指定为其它参数，可在参数名之前使用关键词 OUT或INOUT 注意: 指定参数为IN, OUT, 或INOUT 只对PROCEDURE是合法的。（FUNCTIO 阅读全文
posted @ 2018-02-23 10:24
ecwork
阅读(158)
评论(0)
推荐(0)
摘要：
What's the difference between MyISAM and InnoDB? In deciding which data engine to use, it's important to understand how each one behaves, it's stength 阅读全文
posted @ 2018-01-31 16:05
ecwork
阅读(189)
评论(0)
推荐(0)
摘要：
本文翻译自文章：Pandas Cheat Sheet - Python for Data Science，同时添加了部分注解。 对于数据科学家，无论是数据分析还是数据挖掘来说，Pandas是一个非常重要的Python包。它不仅提供了很多方法，使得数据处理非常简单，同时在数据处理速度上也做了很多优化， 阅读全文
posted @ 2017-11-20 05:49
ecwork
阅读(731)
评论(0)
推荐(0)
|
