xml地图|网站地图|网站标签 [设为首页] [加入收藏]
7后导入之前数据库date出错的解决方法,学习笔记
分类:数据库

 

Calling a stored procedure can produce multiple result sets. They should be retrieved and made available to the application.
MySQLdb is using the Cursor nextset()-method to go through multiple result sets. If the stored procedure returns a multiple results, it will require you to get all sets. For example, using MySQLdb, you'll have to do the following when procedure 'multi' returns 2 sets:

 # using MySQLdb
 cur.callproc("multi", (5, 6, 0))
 cur.nextset()
 cur.nextset()
 cur.execute("SELECT @_multi_0,@_multi_1,@_multi_2")
 row = cur.fetchone() # == (5L, 6L, 30L)

In Connector/Python we might do it a bit easier, buffering the multiple sets returned and using the fetch-methods to get the results:

 # using MySQL Connector/Python
 cur.callproc("multi", (5,6,0))
 row = cur.fetchone() == ('5', '6', 30)

If the application needs the other results, it can get them using next_proc_resultset() this method returns a MySQLCursorBuffered object which holds the result:

 # using MySQL Connector/Python
 result = cur.callproc("multi", (5,6,0))
 cursor_set1 = cur.next_proc_resultset()
        rows = cur.fetchall()

 

  1.  节制 , 给有个别字段增添限定原则, 譬喻年龄在1-玖拾贰虚岁以内

  mysql5.x进级至mysql5.7后导入以前数据库date出错的消除措施!

图片 1

  修正mysql5.7的配置文件就可以消除,方法如下:

 

  linux版:找到mysql的装置路线进入暗许的为/usr/share/mysql/中,举办对my-default.cnf编辑

   增多限制,输入 Age>1 and Age < 100

       利用查找作用"/"找到"sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES"

    图片 2

       将其除去只怕是注释就可以。

 

本文由澳门新葡亰手机版发布于数据库,转载请注明出处:7后导入之前数据库date出错的解决方法,学习笔记

上一篇:没有了 下一篇:没有了
猜你喜欢
热门排行
精彩图文