# 章节末测验

+ 以下代码执行的结果是（假设连接没有问题,表 `t1` 事先并不存在）?
  + A. 抛出异常
  + B. 正常执行,插入的行无法保存
  + C. 正常执行,创建表和插入行都能成功
  + D. 执行 `query_insert` 时报错

```
from mysql.connector import connect;

conn = connect(
  database='test',
  host='127.0.0.1',
  port=4000,
  user='root',
  password='oh_you_can_really_dance'
)

cursor = conn.cursor(prepared=True)
query_setup = 'create table if not exists t1 (id int, name char(30))'
query_insert = 'insert into t1 (id, name) values (%s, %s)'
cursor.execute(query_setup)
cursor.execute(query_insert, (101, 'XYZ'))
cursor.close()
conn.close()
```

********************************************************************

答案：B