加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 编程开发 > Python > 正文

python开发_mysqldb安装

发布时间:2020-12-17 00:19:04 所属栏目:Python 来源:网络整理
导读:在python的API上面,看到了MySQLdb,即python可以操作mysql数据库 接下来,我就把我这两天的工作给大伙絮叨絮叨: 准备条件: 1. 安装包 ? 2. 安装包 3. 安装包 4.如果你都安装成功了,你不妨去验证一下: 步骤: 嘿嘿,安装mysql数据的操作,我就不向大家展

在python的API上面,看到了MySQLdb,即python可以操作mysql数据库

接下来,我就把我这两天的工作给大伙絮叨絮叨:

准备条件:

1. 安装包 ?

2.安装包

3.安装包

4.如果你都安装成功了,你不妨去验证一下:

步骤:

嘿嘿,安装mysql数据的操作,我就不向大家展示了

下面提供mysql的一些操作:

首先我们到官网:

下载:安装包

下载后,点击直接安装了

我安装的目录是:

下载:的时候,

明确说明了,对python的支持是2.4-2.7,所以我选择的是2.7.5的python版本。

安装的目录:

安装完成后,会在目录:下面多出一些文件

在GUI中输入:

>>help()

MySQLdb

出现的信息:

Python 2.7.5 (default,May 15 2013,22:43:36) [MSC v.1500 32, >>>Welcome to Python 2.7! This <span style="color: #0000ff;">is<span style="color: #000000;"> the online help utility.

If this <span style="color: #0000ff;">is<span style="color: #000000;"> your first time using Python,you should definitely check out
the tutorial on the Internet at http://docs.python.org/2.7/tutorial/<span style="color: #000000;">.

Enter the name of any module,keyword,<span style="color: #0000ff;">or<span style="color: #000000;"> topic to get help on writing
Python programs <span style="color: #0000ff;">and using Python modules. To quit this help utility <span style="color: #0000ff;">and
<span style="color: #0000ff;">return to the interpreter,just type <span style="color: #800000;">"<span style="color: #800000;">quit<span style="color: #800000;">"<span style="color: #000000;">.

To get a list of available modules,keywords,<span style="color: #0000ff;">or topics,type <span style="color: #800000;">"<span style="color: #800000;">modules<span style="color: #800000;">"<span style="color: #000000;">,<span style="color: #800000;">"<span style="color: #800000;">keywords<span style="color: #800000;">",<span style="color: #0000ff;">or <span style="color: #800000;">"<span style="color: #800000;">topics<span style="color: #800000;">". Each module also comes with a one-<span style="color: #000000;">line summary
of what it does; to list the modules whose summaries contain a given word
such as <span style="color: #800000;">"<span style="color: #800000;">spam<span style="color: #800000;">",type <span style="color: #800000;">"<span style="color: #800000;">modules spam<span style="color: #800000;">"<span style="color: #000000;">.

help><span style="color: #000000;"> MySQLdb
Help on package MySQLdb:

NAME
MySQLdb - MySQLdb -<span style="color: #000000;"> A DB API v2.0 compatible interface to MySQL.

FILE
e:python2.7.5libsite-packagesmysqldb&;span style="color: #800080;">init<span style="color: #000000;">.py

DESCRIPTION
This package <span style="color: #0000ff;">is<span style="color: #000000;"> a wrapper around _mysql,which mostly implements the
MySQL C API.

connect() </span>--<span style="color: #000000;"&gt; connects to server

See the C API specification </span><span style="color: #0000ff;"&gt;and</span> the MySQL documentation <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; more info
on other items.

For information on how MySQLdb handles type conversion,see the
MySQLdb.converters module.

PACKAGE CONTENTS
connections
constants (package)
converters
cursors
release
times

SUBMODULES
FIELD_TYPE

CLASSES
<span style="color: #800080;">builtin.frozenset(<span style="color: #800080;">builtin<span style="color: #000000;">.object)
DBAPISet
<span style="color: #800080;">builtin<span style="color: #000000;">.object
datetime.date
datetime.datetime
datetime.time
exceptions.StandardError(exceptions.Exception)
_mysql_exceptions.MySQLError
_mysql_exceptions.Error
_mysql_exceptions.DatabaseError
_mysql_exceptions.DataError
_mysql_exceptions.IntegrityError
_mysql_exceptions.InternalError
_mysql_exceptions.NotSupportedError
_mysql_exceptions.OperationalError
_mysql_exceptions.ProgrammingError
_mysql_exceptions.InterfaceError
_mysql_exceptions.Warning(exceptions.Warning,_mysql_exceptions.MySQLError)
exceptions.Warning(exceptions.Exception)
_mysql_exceptions.Warning(exceptions.Warning,_mysql_exceptions.MySQLError)

</span><span style="color: #0000ff;"&gt;class</span> DBAPISet(<span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.frozenset)
 </span>|  A special type of set <span style="color: #0000ff;"&gt;for</span> which A == x <span style="color: #0000ff;"&gt;is</span> true <span style="color: #0000ff;"&gt;if</span> A <span style="color: #0000ff;"&gt;is</span><span style="color: #000000;"&gt; a
 </span>|  DBAPISet <span style="color: #0000ff;"&gt;and</span> x <span style="color: #0000ff;"&gt;is</span><span style="color: #000000;"&gt; a member of that set.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      DBAPISet
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.frozenset
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |<span style="color: #000000;"&gt;  Methods defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__eq__</span><span style="color: #000000;"&gt;(self,other)
 </span>|  
 |  ----------------------------------------------------------------------
 |<span style="color: #000000;"&gt;  Data descriptors defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |      dictionary <span style="color: #0000ff;"&gt;for</span> instance variables (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span> <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.frozenset:
 </span>|  
 |  <span style="color: #800080;"&gt;__and__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__and__</span>(y) <==> x&amp;<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__cmp__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__cmp__</span>(y) <==><span style="color: #000000;"&gt; cmp(x,y)
 </span>|  
 |  <span style="color: #800080;"&gt;__contains__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__contains__</span>(y) <==> y <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; x.
 </span>|  
 |  <span style="color: #800080;"&gt;__ge__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ge__</span>(y) <==> x>=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__getattribute__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getattribute__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>) <==><span style="color: #000000;"&gt; x.name
 </span>|  
 |  <span style="color: #800080;"&gt;__gt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__gt__</span>(y) <==> x><span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__hash__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__hash__</span>() <==><span style="color: #000000;"&gt; hash(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__iter__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__iter__</span>() <==><span style="color: #000000;"&gt; iter(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__le__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__le__</span>(y) <==> x<=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__len__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__len__</span>() <==><span style="color: #000000;"&gt; len(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__lt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__lt__</span>(y) <==> x<<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__ne__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ne__</span>(y) <==> x!=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__or__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__or__</span>(y) <==> x|<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__rand__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__rand__</span>(y) <==> y&amp;<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__reduce__</span><span style="color: #000000;"&gt;(...)
 </span>|      Return state information <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; pickling.
 </span>|  
 |  <span style="color: #800080;"&gt;__repr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__repr__</span>() <==><span style="color: #000000;"&gt; repr(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__ror__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ror__</span>(y) <==> y|<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__rsub__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__rsub__</span>(y) <==> y-<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__rxor__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__rxor__</span>(y) <==> y^<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__sizeof__</span><span style="color: #000000;"&gt;(...)
 </span>|      S.<span style="color: #800080;"&gt;__sizeof__</span>() -> size of S <span style="color: #0000ff;"&gt;in</span> memory,<span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; bytes
 </span>|  
 |  <span style="color: #800080;"&gt;__sub__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__sub__</span>(y) <==> x-<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__xor__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__xor__</span>(y) <==> x^<span style="color: #000000;"&gt;y
 </span>|  
 |<span style="color: #000000;"&gt;  copy(...)
 </span>|<span style="color: #000000;"&gt;      Return a shallow copy of a set.
 </span>|  
 |<span style="color: #000000;"&gt;  difference(...)
 </span>|      Return the difference of two <span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; more sets as a new set.
 </span>|      
 |      (i.e. all elements that are <span style="color: #0000ff;"&gt;in</span> this set but <span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; the others.)
 </span>|  
 |<span style="color: #000000;"&gt;  intersection(...)
 </span>|      Return the intersection of two <span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; more sets as a new set.
 </span>|      
 |<span style="color: #000000;"&gt;      (i.e. elements that are common to all of the sets.)
 </span>|  
 |<span style="color: #000000;"&gt;  isdisjoint(...)
 </span>|      Return True <span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; two sets have a null intersection.
 </span>|  
 |<span style="color: #000000;"&gt;  issubset(...)
 </span>|<span style="color: #000000;"&gt;      Report whether another set contains this set.
 </span>|  
 |<span style="color: #000000;"&gt;  issuperset(...)
 </span>|<span style="color: #000000;"&gt;      Report whether this set contains another set.
 </span>|  
 |<span style="color: #000000;"&gt;  symmetric_difference(...)
 </span>|<span style="color: #000000;"&gt;      Return the symmetric difference of two sets as a new set.
 </span>|      
 |      (i.e. all elements that are <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; exactly one of the sets.)
 </span>|  
 |<span style="color: #000000;"&gt;  union(...)
 </span>|<span style="color: #000000;"&gt;      Return the union of sets as a new set.
 </span>|      
 |      (i.e. all elements that are <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; either set.)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span> <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.frozenset:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,...) -><span style="color: #000000;"&gt; a new object with type S,a subtype of T

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; DataError(DatabaseError)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; errors that are due to problems with the
 </span>|<span style="color: #000000;"&gt;  processed data like division by zero,numeric value out of range,</span>|<span style="color: #000000;"&gt;  etc.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      DataError
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,a subtype of T
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__delattr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__delattr__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>) <==> <span style="color: #0000ff;"&gt;del</span><span style="color: #000000;"&gt; x.name
 </span>|  
 |  <span style="color: #800080;"&gt;__getattribute__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getattribute__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>) <==><span style="color: #000000;"&gt; x.name
 </span>|  
 |  <span style="color: #800080;"&gt;__getitem__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getitem__</span>(y) <==><span style="color: #000000;"&gt; x[y]
 </span>|  
 |  <span style="color: #800080;"&gt;__getslice__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getslice__</span>(i,j) <==><span style="color: #000000;"&gt; x[i:j]
 </span>|      
 |      Use of negative indices <span style="color: #0000ff;"&gt;is</span> <span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; supported.
 </span>|  
 |  <span style="color: #800080;"&gt;__reduce__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__repr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__repr__</span>() <==><span style="color: #000000;"&gt; repr(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__setattr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__setattr__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; DatabaseError(Error)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; errors that are related to the
 </span>|<span style="color: #000000;"&gt;  database.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

Date </span>= <span style="color: #0000ff;"&gt;class</span> date(<span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object)
 </span>|  date(year,month,day) --><span style="color: #000000;"&gt; date object
 </span>|  
 |<span style="color: #000000;"&gt;  Methods defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__add__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__add__</span>(y) <==> x+<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__eq__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__eq__</span>(y) <==> x==<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__format__</span><span style="color: #000000;"&gt;(...)
 </span>|<span style="color: #000000;"&gt;      Formats self with strftime.
 </span>|  
 |  <span style="color: #800080;"&gt;__ge__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ge__</span>(y) <==> x>=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__getattribute__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getattribute__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>) <==><span style="color: #000000;"&gt; x.name
 </span>|  
 |  <span style="color: #800080;"&gt;__gt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__gt__</span>(y) <==> x><span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__hash__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__hash__</span>() <==><span style="color: #000000;"&gt; hash(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__le__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__le__</span>(y) <==> x<=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__lt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__lt__</span>(y) <==> x<<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__ne__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ne__</span>(y) <==> x!=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__radd__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__radd__</span>(y) <==> y+<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__reduce__</span><span style="color: #000000;"&gt;(...)
 </span>|      <span style="color: #800080;"&gt;__reduce__</span>() -><span style="color: #000000;"&gt; (cls,state)
 </span>|  
 |  <span style="color: #800080;"&gt;__repr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__repr__</span>() <==><span style="color: #000000;"&gt; repr(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__rsub__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__rsub__</span>(y) <==> y-<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__sub__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__sub__</span>(y) <==> x-<span style="color: #000000;"&gt;y
 </span>|  
 |<span style="color: #000000;"&gt;  ctime(...)
 </span>|<span style="color: #000000;"&gt;      Return ctime() style string.
 </span>|  
 |<span style="color: #000000;"&gt;  fromordinal(...)
 </span>|      int -><span style="color: #000000;"&gt; date corresponding to a proleptic Gregorian ordinal.
 </span>|  
 |<span style="color: #000000;"&gt;  fromtimestamp(...)
 </span>|      timestamp -> local date <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; a POSIX timestamp (like time.time()).
 </span>|  
 |<span style="color: #000000;"&gt;  isocalendar(...)
 </span>|      Return a 3-tuple containing ISO year,week number,<span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; weekday.
 </span>|  
 |<span style="color: #000000;"&gt;  isoformat(...)
 </span>|      Return string <span style="color: #0000ff;"&gt;in</span> ISO 8601 format,YYYY-MM-<span style="color: #000000;"&gt;DD.
 </span>|  
 |<span style="color: #000000;"&gt;  isoweekday(...)
 </span>|<span style="color: #000000;"&gt;      Return the day of the week represented by the date.
 </span>|      Monday == 1 ... Sunday == 7
 |  
 |<span style="color: #000000;"&gt;  replace(...)
 </span>|<span style="color: #000000;"&gt;      Return date with new specified fields.
 </span>|  
 |<span style="color: #000000;"&gt;  strftime(...)
 </span>|      format -><span style="color: #000000;"&gt; strftime() style string.
 </span>|  
 |<span style="color: #000000;"&gt;  timetuple(...)
 </span>|<span style="color: #000000;"&gt;      Return time tuple,compatible with time.localtime().
 </span>|  
 |<span style="color: #000000;"&gt;  today(...)
 </span>|      Current date <span style="color: #0000ff;"&gt;or</span> datetime:  same as self.<span style="color: #800080;"&gt;__class__</span><span style="color: #000000;"&gt;.fromtimestamp(time.time()).
 </span>|  
 |<span style="color: #000000;"&gt;  toordinal(...)
 </span>|      Return proleptic Gregorian ordinal.  January 1 of year 1 <span style="color: #0000ff;"&gt;is</span> day 1<span style="color: #000000;"&gt;.
 </span>|  
 |<span style="color: #000000;"&gt;  weekday(...)
 </span>|<span style="color: #000000;"&gt;      Return the day of the week represented by the date.
 </span>|      Monday == 0 ... Sunday == 6
 |  
 |  ----------------------------------------------------------------------
 |<span style="color: #000000;"&gt;  Data descriptors defined here:
 </span>|  
 |<span style="color: #000000;"&gt;  day
 </span>|  
 |<span style="color: #000000;"&gt;  month
 </span>|  
 |<span style="color: #000000;"&gt;  year
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; other attributes defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,a subtype of T
 </span>|  
 |  max = datetime.date(9999,12,31<span style="color: #000000;"&gt;)
 </span>|  
 |  min = datetime.date(1,1,1<span style="color: #000000;"&gt;)
 </span>|  
 |  resolution = datetime.timedelta(1<span style="color: #000000;"&gt;)

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; Error(MySQLError)
 </span>|  Exception that <span style="color: #0000ff;"&gt;is</span> the base <span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; of all other error exceptions
 </span>|  (<span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; Warning).
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; IntegrityError(DatabaseError)
 </span>|<span style="color: #000000;"&gt;  Exception raised when the relational integrity of the database
 </span>|  <span style="color: #0000ff;"&gt;is</span><span style="color: #000000;"&gt; affected,e.g. a foreign key check fails,duplicate key,</span>|<span style="color: #000000;"&gt;  etc.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      IntegrityError
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; InterfaceError(Error)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; errors that are related to the database
 </span>|<span style="color: #000000;"&gt;  interface rather than the database itself.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      InterfaceError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; InternalError(DatabaseError)
 </span>|<span style="color: #000000;"&gt;  Exception raised when the database encounters an internal
 </span>|  error,e.g. the cursor <span style="color: #0000ff;"&gt;is</span> <span style="color: #0000ff;"&gt;not</span> valid anymore,the transaction <span style="color: #0000ff;"&gt;is</span>
 |<span style="color: #000000;"&gt;  out of sync,etc.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      InternalError
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; MySQLError(exceptions.StandardError)
 </span>|<span style="color: #000000;"&gt;  Exception related to operation with MySQL.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |<span style="color: #000000;"&gt;  Data descriptors defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; NotSupportedError(DatabaseError)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;in</span> case a method <span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; database API was used
 </span>|  which <span style="color: #0000ff;"&gt;is</span> <span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; supported by the database,e.g. requesting a
 </span>|  .rollback() on a connection that does <span style="color: #0000ff;"&gt;not</span> support transaction <span style="color: #0000ff;"&gt;or</span>
 |<span style="color: #000000;"&gt;  has transactions turned off.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      NotSupportedError
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; OperationalError(DatabaseError)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;for</span> errors that are related to the database<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;s</span>
 |  operation <span style="color: #0000ff;"&gt;and</span> <span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; necessarily under the control of the programmer,</span>|  e.g. an unexpected disconnect occurs,the data source name <span style="color: #0000ff;"&gt;is</span> <span style="color: #0000ff;"&gt;not</span>
 |  found,a transaction could <span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; be processed,a memory allocation
 </span>|<span style="color: #000000;"&gt;  error occurred during processing,etc.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      OperationalError
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; ProgrammingError(DatabaseError)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;for</span> programming errors,e.g. table <span style="color: #0000ff;"&gt;not</span><span style="color: #000000;"&gt; found
 </span>|  <span style="color: #0000ff;"&gt;or</span> already exists,syntax error <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; the SQL statement,wrong number
 </span>|<span style="color: #000000;"&gt;  of parameters specified,etc.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      ProgrammingError
 </span>|<span style="color: #000000;"&gt;      DatabaseError
 </span>|<span style="color: #000000;"&gt;      Error
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; MySQLError:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.StandardError:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

Time </span>= <span style="color: #0000ff;"&gt;class</span> time(<span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object)
 </span>|  time([hour[,minute[,second[,microsecond[,tzinfo]]]]]) --><span style="color: #000000;"&gt; a time object
 </span>|  
 |  All arguments are optional. tzinfo may be None,<span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; an instance of
 </span>|  a tzinfo subclass. The remaining arguments may be ints <span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; longs.
 </span>|  
 |<span style="color: #000000;"&gt;  Methods defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__eq__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__eq__</span>(y) <==> x==<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__format__</span><span style="color: #000000;"&gt;(...)
 </span>|<span style="color: #000000;"&gt;      Formats self with strftime.
 </span>|  
 |  <span style="color: #800080;"&gt;__ge__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ge__</span>(y) <==> x>=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__getattribute__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getattribute__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>) <==><span style="color: #000000;"&gt; x.name
 </span>|  
 |  <span style="color: #800080;"&gt;__gt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__gt__</span>(y) <==> x><span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__hash__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__hash__</span>() <==><span style="color: #000000;"&gt; hash(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__le__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__le__</span>(y) <==> x<=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__lt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__lt__</span>(y) <==> x<<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__ne__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ne__</span>(y) <==> x!=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__nonzero__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__nonzero__</span>() <==> x !=<span style="color: #000000;"&gt; 0
 </span>|  
 |  <span style="color: #800080;"&gt;__reduce__</span><span style="color: #000000;"&gt;(...)
 </span>|      <span style="color: #800080;"&gt;__reduce__</span>() -><span style="color: #000000;"&gt; (cls,state)
 </span>|  
 |  <span style="color: #800080;"&gt;__repr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__repr__</span>() <==><span style="color: #000000;"&gt; repr(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |<span style="color: #000000;"&gt;  dst(...)
 </span>|<span style="color: #000000;"&gt;      Return self.tzinfo.dst(self).
 </span>|  
 |<span style="color: #000000;"&gt;  isoformat(...)
 </span>|      Return string <span style="color: #0000ff;"&gt;in</span> ISO 8601 format,HH:MM:SS[.mmmmmm][+<span style="color: #000000;"&gt;HH:MM].
 </span>|  
 |<span style="color: #000000;"&gt;  replace(...)
 </span>|<span style="color: #000000;"&gt;      Return time with new specified fields.
 </span>|  
 |<span style="color: #000000;"&gt;  strftime(...)
 </span>|      format -><span style="color: #000000;"&gt; strftime() style string.
 </span>|  
 |<span style="color: #000000;"&gt;  tzname(...)
 </span>|<span style="color: #000000;"&gt;      Return self.tzinfo.tzname(self).
 </span>|  
 |<span style="color: #000000;"&gt;  utcoffset(...)
 </span>|<span style="color: #000000;"&gt;      Return self.tzinfo.utcoffset(self).
 </span>|  
 |  ----------------------------------------------------------------------
 |<span style="color: #000000;"&gt;  Data descriptors defined here:
 </span>|  
 |<span style="color: #000000;"&gt;  hour
 </span>|  
 |<span style="color: #000000;"&gt;  microsecond
 </span>|  
 |<span style="color: #000000;"&gt;  minute
 </span>|  
 |<span style="color: #000000;"&gt;  second
 </span>|  
 |<span style="color: #000000;"&gt;  tzinfo
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; other attributes defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,a subtype of T
 </span>|  
 |  max = datetime.time(23,59,999999<span style="color: #000000;"&gt;)
 </span>|  
 |  min =<span style="color: #000000;"&gt; datetime.time(0,0)
 </span>|  
 |  resolution = datetime.timedelta(0,1<span style="color: #000000;"&gt;)

Timestamp </span>= <span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; datetime(date)
 </span>|<span style="color: #000000;"&gt;  datetime(year,day[,hour[,tzinfo]]]]])
 </span>|  
 |  The year,month <span style="color: #0000ff;"&gt;and</span> day arguments are required. tzinfo may be None,<span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; an
 </span>|  instance of a tzinfo subclass. The remaining arguments may be ints <span style="color: #0000ff;"&gt;or</span><span style="color: #000000;"&gt; longs.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      datetime
 </span>|<span style="color: #000000;"&gt;      date
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |<span style="color: #000000;"&gt;  Methods defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__add__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__add__</span>(y) <==> x+<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__eq__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__eq__</span>(y) <==> x==<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__ge__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ge__</span>(y) <==> x>=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__getattribute__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__getattribute__</span>(<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;name</span><span style="color: #800000;"&gt;'</span>) <==><span style="color: #000000;"&gt; x.name
 </span>|  
 |  <span style="color: #800080;"&gt;__gt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__gt__</span>(y) <==> x><span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__hash__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__hash__</span>() <==><span style="color: #000000;"&gt; hash(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__le__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__le__</span>(y) <==> x<=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__lt__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__lt__</span>(y) <==> x<<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__ne__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__ne__</span>(y) <==> x!=<span style="color: #000000;"&gt;y
 </span>|  
 |  <span style="color: #800080;"&gt;__radd__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__radd__</span>(y) <==> y+<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__reduce__</span><span style="color: #000000;"&gt;(...)
 </span>|      <span style="color: #800080;"&gt;__reduce__</span>() -><span style="color: #000000;"&gt; (cls,state)
 </span>|  
 |  <span style="color: #800080;"&gt;__repr__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__repr__</span>() <==><span style="color: #000000;"&gt; repr(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__rsub__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__rsub__</span>(y) <==> y-<span style="color: #000000;"&gt;x
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__sub__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__sub__</span>(y) <==> x-<span style="color: #000000;"&gt;y
 </span>|  
 |<span style="color: #000000;"&gt;  astimezone(...)
 </span>|      tz -> convert to local time <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; new timezone tz
 </span>|  
 |<span style="color: #000000;"&gt;  combine(...)
 </span>|      date,time -> datetime with same date <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; time fields
 </span>|  
 |<span style="color: #000000;"&gt;  ctime(...)
 </span>|<span style="color: #000000;"&gt;      Return ctime() style string.
 </span>|  
 |<span style="color: #000000;"&gt;  date(...)
 </span>|      Return date object with same year,month <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; day.
 </span>|  
 |<span style="color: #000000;"&gt;  dst(...)
 </span>|<span style="color: #000000;"&gt;      Return self.tzinfo.dst(self).
 </span>|  
 |<span style="color: #000000;"&gt;  fromtimestamp(...)
 </span>|      timestamp[,tz] -> tz<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;s local time from POSIX timestamp.</span>
 |  
 |<span style="color: #000000;"&gt;  isoformat(...)
 </span>|      [sep] -> string <span style="color: #0000ff;"&gt;in</span> ISO 8601 format,YYYY-MM-DDTHH:MM:SS[.mmmmmm][+<span style="color: #000000;"&gt;HH:MM].
 </span>|      
 |      sep <span style="color: #0000ff;"&gt;is</span> used to separate the year <span style="color: #0000ff;"&gt;from</span> the time,<span style="color: #0000ff;"&gt;and</span> defaults to <span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;T</span><span style="color: #800000;"&gt;'</span><span style="color: #000000;"&gt;.
 </span>|  
 |<span style="color: #000000;"&gt;  now(...)
 </span>|      [tz] -> new datetime with tz<span style="color: #800000;"&gt;'</span><span style="color: #800000;"&gt;s local day and time.</span>
 |  
 |<span style="color: #000000;"&gt;  replace(...)
 </span>|<span style="color: #000000;"&gt;      Return datetime with new specified fields.
 </span>|  
 |<span style="color: #000000;"&gt;  strptime(...)
 </span>|      string,format -> new datetime parsed <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; a string (like time.strptime()).
 </span>|  
 |<span style="color: #000000;"&gt;  time(...)
 </span>|      Return time object with same time but with tzinfo=<span style="color: #000000;"&gt;None.
 </span>|  
 |<span style="color: #000000;"&gt;  timetuple(...)
 </span>|<span style="color: #000000;"&gt;      Return time tuple,compatible with time.localtime().
 </span>|  
 |<span style="color: #000000;"&gt;  timetz(...)
 </span>|      Return time object with same time <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; tzinfo.
 </span>|  
 |<span style="color: #000000;"&gt;  tzname(...)
 </span>|<span style="color: #000000;"&gt;      Return self.tzinfo.tzname(self).
 </span>|  
 |<span style="color: #000000;"&gt;  utcfromtimestamp(...)
 </span>|      timestamp -> UTC datetime <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; a POSIX timestamp (like time.time()).
 </span>|  
 |<span style="color: #000000;"&gt;  utcnow(...)
 </span>|      Return a new datetime representing UTC day <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; time.
 </span>|  
 |<span style="color: #000000;"&gt;  utcoffset(...)
 </span>|<span style="color: #000000;"&gt;      Return self.tzinfo.utcoffset(self).
 </span>|  
 |<span style="color: #000000;"&gt;  utctimetuple(...)
 </span>|<span style="color: #000000;"&gt;      Return UTC time tuple,compatible with time.localtime().
 </span>|  
 |  ----------------------------------------------------------------------
 |<span style="color: #000000;"&gt;  Data descriptors defined here:
 </span>|  
 |<span style="color: #000000;"&gt;  hour
 </span>|  
 |<span style="color: #000000;"&gt;  microsecond
 </span>|  
 |<span style="color: #000000;"&gt;  minute
 </span>|  
 |<span style="color: #000000;"&gt;  second
 </span>|  
 |<span style="color: #000000;"&gt;  tzinfo
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; other attributes defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,a subtype of T
 </span>|  
 |  max = datetime.datetime(9999,31,23,999999<span style="color: #000000;"&gt;)
 </span>|  
 |  min = datetime.datetime(1,1<span style="color: #000000;"&gt;,1<span style="color: #000000;"&gt;)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; date:
 </span>|  
 |  <span style="color: #800080;"&gt;__format__</span><span style="color: #000000;"&gt;(...)
 </span>|<span style="color: #000000;"&gt;      Formats self with strftime.
 </span>|  
 |<span style="color: #000000;"&gt;  fromordinal(...)
 </span>|      int -><span style="color: #000000;"&gt; date corresponding to a proleptic Gregorian ordinal.
 </span>|  
 |<span style="color: #000000;"&gt;  isocalendar(...)
 </span>|      Return a 3-tuple containing ISO year,<span style="color: #0000ff;"&gt;and</span><span style="color: #000000;"&gt; weekday.
 </span>|  
 |<span style="color: #000000;"&gt;  isoweekday(...)
 </span>|<span style="color: #000000;"&gt;      Return the day of the week represented by the date.
 </span>|      Monday == 1 ... Sunday == 7
 |  
 |<span style="color: #000000;"&gt;  strftime(...)
 </span>|      format -><span style="color: #000000;"&gt; strftime() style string.
 </span>|  
 |<span style="color: #000000;"&gt;  today(...)
 </span>|      Current date <span style="color: #0000ff;"&gt;or</span> datetime:  same as self.<span style="color: #800080;"&gt;__class__</span><span style="color: #000000;"&gt;.fromtimestamp(time.time()).
 </span>|  
 |<span style="color: #000000;"&gt;  toordinal(...)
 </span>|      Return proleptic Gregorian ordinal.  January 1 of year 1 <span style="color: #0000ff;"&gt;is</span> day 1<span style="color: #000000;"&gt;.
 </span>|  
 |<span style="color: #000000;"&gt;  weekday(...)
 </span>|<span style="color: #000000;"&gt;      Return the day of the week represented by the date.
 </span>|      Monday == 0 ... Sunday == 6
 |  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; date:
 </span>|  
 |<span style="color: #000000;"&gt;  day
 </span>|  
 |<span style="color: #000000;"&gt;  month
 </span>|  
 |<span style="color: #000000;"&gt;  year

</span><span style="color: #0000ff;"&gt;class</span><span style="color: #000000;"&gt; Warning(exceptions.Warning,MySQLError)
 </span>|  Exception raised <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; important warnings like data truncations
 </span>|  <span style="color: #0000ff;"&gt;while</span><span style="color: #000000;"&gt; inserting,etc.
 </span>|  
 |<span style="color: #000000;"&gt;  Method resolution order:
 </span>|<span style="color: #000000;"&gt;      Warning
 </span>|<span style="color: #000000;"&gt;      exceptions.Warning
 </span>|<span style="color: #000000;"&gt;      MySQLError
 </span>|<span style="color: #000000;"&gt;      exceptions.StandardError
 </span>|<span style="color: #000000;"&gt;      exceptions.Exception
 </span>|<span style="color: #000000;"&gt;      exceptions.BaseException
 </span>|      <span style="color: #800080;"&gt;__builtin__</span><span style="color: #000000;"&gt;.object
 </span>|  
 |<span style="color: #000000;"&gt;  Data descriptors defined here:
 </span>|  
 |  <span style="color: #800080;"&gt;__weakref__</span>
 |      list of weak references to the object (<span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; defined)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Methods inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.Warning:
 </span>|  
 |  <span style="color: #800080;"&gt;__init__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__init__</span>(...) initializes x; see help(type(x)) <span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; signature
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data <span style="color: #0000ff;"&gt;and</span> other attributes inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.Warning:
 </span>|  
 |  <span style="color: #800080;"&gt;__new__</span> = <built-<span style="color: #0000ff;"&gt;in</span> method <span style="color: #800080;"&gt;__new__</span> of type object>
 |      T.<span style="color: #800080;"&gt;__new__</span>(S,value) <==> x.name =<span style="color: #000000;"&gt; value
 </span>|  
 |  <span style="color: #800080;"&gt;__setstate__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  <span style="color: #800080;"&gt;__str__</span><span style="color: #000000;"&gt;(...)
 </span>|      x.<span style="color: #800080;"&gt;__str__</span>() <==><span style="color: #000000;"&gt; str(x)
 </span>|  
 |  <span style="color: #800080;"&gt;__unicode__</span><span style="color: #000000;"&gt;(...)
 </span>|  
 |  ----------------------------------------------------------------------
 |  Data descriptors inherited <span style="color: #0000ff;"&gt;from</span><span style="color: #000000;"&gt; exceptions.BaseException:
 </span>|  
 |  <span style="color: #800080;"&gt;__dict__</span>
 |  
 |<span style="color: #000000;"&gt;  args
 </span>|  
 |<span style="color: #000000;"&gt;  message

FUNCTIONS
Binary(x)

Connect(</span>*args,**<span style="color: #000000;"&gt;kwargs)
    Factory function </span><span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; connections.Connection.

Connection </span>= Connect(*args,**<span style="color: #000000;"&gt;kwargs)
    Factory function </span><span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; connections.Connection.

DateFromTicks(ticks)
    Convert UNIX ticks into a date instance.

TimeFromTicks(ticks)
    Convert UNIX ticks into a time instance.

TimestampFromTicks(ticks)
    Convert UNIX ticks into a datetime instance.

connect </span>= Connect(*args,**<span style="color: #000000;"&gt;kwargs)
    Factory function </span><span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; connections.Connection.

debug(...)
    Does a DBUG_PUSH with the given string.
    mysql_debug() uses the Fred Fish debug library.
    To use this function,you must compile the client library to
    support debugging.

escape(...)
    escape(obj,dict) </span>-- escape any special characters <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; object obj
    using mapping dict to provide quoting functions </span><span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; each type.
    Returns a SQL literal string.

escape_dict(...)
    escape_sequence(d,dict) </span>-- escape any special characters <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt;
    dictionary d using mapping dict to provide quoting functions </span><span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; each type.
    Returns a dictionary of escaped items.

escape_sequence(...)
    escape_sequence(seq,dict) </span>-- escape any special characters <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; sequence
    seq using mapping dict to provide quoting functions </span><span style="color: #0000ff;"&gt;for</span><span style="color: #000000;"&gt; each type.
    Returns a tuple of escaped items.

escape_string(...)
    escape_string(s) </span>-- quote any SQL-interpreted characters <span style="color: #0000ff;"&gt;in</span><span style="color: #000000;"&gt; string s.

    Use connection.escape_string(s),</span><span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; you use it at all.
    _mysql.escape_string(s) cannot handle character sets. You are
    probably better off using connection.escape(o) instead,since
    it will escape entire sequences as well as strings.

get_client_info(...)
    get_client_info() </span>--<span style="color: #000000;"&gt; Returns a string that represents
    the client library version.

string_literal(...)
    string_literal(obj) </span>--<span style="color: #000000;"&gt; converts object obj into a SQL string literal.
    This means,any special SQL characters are escaped,</span><span style="color: #0000ff;"&gt;and</span> it <span style="color: #0000ff;"&gt;is</span><span style="color: #000000;"&gt; enclosed
    within single quotes. In other words,it performs:

    </span><span style="color: #800000;"&gt;"</span><span style="color: #800000;"&gt;'%s'</span><span style="color: #800000;"&gt;"</span> %<span style="color: #000000;"&gt; escape_string(str(obj))

    Use connection.string_literal(obj),</span><span style="color: #0000ff;"&gt;if</span><span style="color: #000000;"&gt; you use it at all.
    _mysql.string_literal(obj) cannot handle character sets.

DATA
BINARY = DBAPISet([249,250,251,252<span style="color: #000000;">])
DATE = DBAPISet([10,14<span style="color: #000000;">])
NULL = <span style="color: #800000;">'<span style="color: #800000;">NULL<span style="color: #800000;">'<span style="color: #000000;">
NUMBER = DBAPISet([0,3,4,5,8,9,13<span style="color: #000000;">])
ROWID =<span style="color: #000000;"> DBAPISet([])
STRING = DBAPISet([253,254,247<span style="color: #000000;">])
TIME = DBAPISet([11<span style="color: #000000;">])
TIMESTAMP = DBAPISet([12,7<span style="color: #000000;">])
<span style="color: #800080;">all = [<span style="color: #800000;">'<span style="color: #800000;">BINARY<span style="color: #800000;">',<span style="color: #800000;">'<span style="color: #800000;">Binary<span style="color: #800000;">',<span style="color: #800000;">'<span style="color: #800000;">Connect<span style="color: #800000;">',<span style="color: #800000;">'<span style="color: #800000;">Connection<span style="color: #800000;">',<span style="color: #800000;">'<span style="color: #800000;">DATE<span style="color: #800000;">',<span style="color: #800000;">'<span style="color: #800000;">Date<span style="color: #800000;">'<span style="color: #000000;">...
<span style="color: #800080;">author = <span style="color: #800000;">'<span style="color: #800000;">Andy Dustman farcepest@gmail.com<span style="color: #800000;">'
<span style="color: #800080;">revision = <span style="color: #800000;">''
<span style="color: #800080;">version = <span style="color: #800000;">'<span style="color: #800000;">1.2.4b4<span style="color: #800000;">'<span style="color: #000000;">
apilevel = <span style="color: #800000;">'<span style="color: #800000;">2.0<span style="color: #800000;">'<span style="color: #000000;">
paramstyle = <span style="color: #800000;">'<span style="color: #800000;">format<span style="color: #800000;">'<span style="color: #000000;">
threadsafety = 1<span style="color: #000000;">
version_info = (1,2,<span style="color: #800000;">'<span style="color: #800000;">beta<span style="color: #800000;">',4<span style="color: #000000;">)

VERSION
1.2<span style="color: #000000;">.4b4

AUTHOR
Andy Dustman farcepest@gmail.com<span style="color: #000000;">

help>

说明你的MySQLdb安装成功了。

========================================================

More reading,and english is important.

I'm Hongten

大哥哥大姐姐,觉得有用打赏点哦!多多少少没关系,一分也是对我的支持和鼓励。谢谢。Hongten博客排名在100名以内。粉丝过千。Hongten出品,必是精品。

E | hongtenzone@foxmail.com ?B |?

========================================================

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读