typeerror mysql_TypeError:“str”对象不可调用（mysqlpython）

我用mysql python编写代码。在

要将新记录添加到数据库中，我使用以下代码：# Open database connection

db = MySQLdb.connect("localhost","root","admin","majoranalysis" )

# prepare a cursor object using cursor() method

cursor = db.cursor()

sql = "INSERT INTO

# insert a record

jobdetail(title,date_accessed,description,requirement,url) \

VALUES(%(title)s,%(data_accessed)s,%(description)s,%(requirement)s,%(url)s)"

dt = ('data analysist',date(2015,4,16),'description','requirement',joblistlink[0])

cursor.execute(sql,dt)

问题不是声明str，但很可能会发生错误：

^{pr2}$

创建表的sql命令是：CREATE TABLE IF NOT EXISTS `jobdetail` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`title` varchar(225) COLLATE utf8_unicode_ci NOT NULL,

`date_accessed` date NOT NULL,

`description` text COLLATE utf8_unicode_ci NOT NULL,

`requirement` text COLLATE utf8_unicode_ci NOT NULL,

`url` varchar(225) COLLATE utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

你知道虫子在哪里吗？在