在建表时创建主键
在建表时创建主键详细操作教程
以下实例为学习在建表时创建主键,具体代码如下:
# Filename : example.py
# Author by : www.lidihuo.com
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
passwd="yourpassword",
database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255))")
#if this page is executed with no error, the table "customers" now has a primary key
执行以上代码输出结果为:
# Filename : example.py
# Author by : www.lidihuo.com