# `Prepared Statement` 与 `Connector/Python` - 示例
```
...
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'))
conn.commit()
cursor.close()
conn.close()
```
--------------------------------------------------------