上一页 1 ··· 29 30 31 32 33 34 35 36 37 ··· 115 下一页
摘要: 总结,int(M) zerofill,加上zerofill后M才表现出有点点效果,比如 int(3) zerofill,你插入到数据库里的是10,则实际插入为010,也就是在前面补充加了一个0.如果int(3)和int(10)不加zerofill,则它们没有什么区别.M不是用来限制int个数的.in 阅读全文
posted @ 2016-09-28 07:12 功夫 熊猫 阅读(14226) 评论(0) 推荐(4)
摘要: Configure Amazon RDS mysql to store Chinese Characters https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html http://docs.aws.amazon.com/AW 阅读全文
posted @ 2016-09-27 08:53 功夫 熊猫 阅读(812) 评论(0) 推荐(0)
摘要: http://dev.mysql.com/doc/refman/5.7/en/identifiers.html http://dev.mysql.com/doc/refman/5.7/en/identifiers.html The following table describes the maxi 阅读全文
posted @ 2016-09-23 04:50 功夫 熊猫 阅读(491) 评论(0) 推荐(0)
摘要: http://skeletoncoder.blogspot.com/2006/10/jdbc-tutorials-commit-or-rollback.html JDBC Tutorials: Commit or Rollback transaction in finally block In mo 阅读全文
posted @ 2016-09-23 02:59 功夫 熊猫 阅读(537) 评论(0) 推荐(0)
摘要: https://www.techonthenet.com/mysql/loops/leave.php This MySQL tutorial explains how to use the LEAVE statement in MySQL with syntax and examples. http 阅读全文
posted @ 2016-09-22 08:02 功夫 熊猫 阅读(1047) 评论(0) 推荐(0)
摘要: 今天用到了MySql里的isnull才发现他和MSSQL里的还是有点区别,现在简单总结一下: mysql中isnull,ifnull,nullif的用法如下: isnull(expr) 的用法:如expr 为null,那么isnull() 的返回值为 1,否则返回值为 0。 mysql> selec 阅读全文
posted @ 2016-09-21 05:13 功夫 熊猫 阅读(627) 评论(0) 推荐(0)
摘要: https://code.tutsplus.com/articles/an-introduction-to-stored-procedures-in-mysql-5--net-17843 MySQL 5 introduced a plethora of new features - stored p 阅读全文
posted @ 2016-09-21 02:32 功夫 熊猫 阅读(281) 评论(0) 推荐(0)
摘要: http://stackoverflow.com/questions/4862911/how-to-throw-an-error-in-mysql-procedure 9down votefavorite What is the mechanism to force the MySQL to thr 阅读全文
posted @ 2016-09-20 08:46 功夫 熊猫 阅读(459) 评论(0) 推荐(0)
摘要: http://stackoverflow.com/jobs/124781/principal-data-scientist-concur-technologies-inc?med=clc&ref=small-sidebar-tag-themed-python Job Description Be a 阅读全文
posted @ 2016-09-20 08:39 功夫 熊猫 阅读(538) 评论(0) 推荐(0)
摘要: https://www.sitepoint.com/cursors-mysql-stored-procedures/ After my previous article on Stored Procedures was published on SitePoint, I received quite 阅读全文
posted @ 2016-09-19 13:53 功夫 熊猫 阅读(482) 评论(0) 推荐(0)
上一页 1 ··· 29 30 31 32 33 34 35 36 37 ··· 115 下一页