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會自動適應類型，實際上可以不必在乎類型了？ 但是其他數據庫包會么？