mysql 字段类型对应的 数字编号， （转摘）

MYSQL_TYPE_BIT                  16
MYSQL_TYPE_BLOB                 252
MYSQL_TYPE_DATE                 10
MYSQL_TYPE_DATETIME             12
MYSQL_TYPE_DECIMAL              0
MYSQL_TYPE_DOUBLE               5
MYSQL_TYPE_ENUM                 247
MYSQL_TYPE_FLOAT                4
MYSQL_TYPE_GEOMETRY             255
MYSQL_TYPE_INT24                9
MYSQL_TYPE_LONG                 3
MYSQL_TYPE_LONGLONG             8
MYSQL_TYPE_LONG_BLOB            251
MYSQL_TYPE_MEDIUM_BLOB          250
MYSQL_TYPE_NEWDATE              14
MYSQL_TYPE_NEWDECIMAL           246
MYSQL_TYPE_NULL                 6
MYSQL_TYPE_SET                  248
MYSQL_TYPE_SHORT                2
MYSQL_TYPE_STRING               254
MYSQL_TYPE_TIME                 11
MYSQL_TYPE_TIMESTAMP            7
MYSQL_TYPE_TINY                 1
MYSQL_TYPE_TINY_BLOB            249
MYSQL_TYPE_VARCHAR              15
MYSQL_TYPE_VAR_STRING           253
MYSQL_TYPE_YEAR                 13

在使用 MySQLdb 时：
The only other method you are very likely to use is when you have to do a multi-row insert:

c.executemany(
      """INSERT INTO breakfast (name, spam, eggs, sausage, price)
      VALUES (%s, %s, %s, %s, %s)""",
      [
      ("Spam and Sausage Lover's Plate", 5, 1, 8, 7.95 ),
      ("Not So Much Spam Plate", 3, 2, 0, 3.95 ),
      ("Don't Wany ANY SPAM! Plate", 0, 4, 3, 5.95 )
      ] )
Here we are inserting three rows of five values. Notice that there is a mix of types (strings, ints, floats) though we still only use %s. And also note that we only included format strings for one row. MySQLdb picks those out and duplicates them for each row.


MySQLdb会自动适应类型，实际上可以不必在乎类型了？
但是其他数据库包会么？