sqlite、SQL 和 MYSQL 之间的区别以及学习技巧 [关闭]

SQLite、SQL和MySQL的区别及学习技巧

python
import sqlite3
# 创建数据库连接
conn = sqlite3.connect('example.db')
# 创建游标对象
cursor = conn.cursor()
# 创建表
cursor.execute('''CREATE TABLE stocks
                  (date text, trans text, symbol text, qty real, price real)''')
# 插入数据
cursor.execute("INSERT INTO stocks VALUES ('2021-01-01', 'BUY', 'AAPL', 100, 135.50)")
# 查询数据
cursor.execute("SELECT * FROM stocks")
rows = cursor.fetchall()
for row in rows:
    print(row)
# 关闭游标和连接
cursor.close()
conn.close()

python
import mysql.connector
# 创建数据库连接
conn = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="mydatabase"
)
# 创建游标对象
cursor = conn.cursor()
# 创建表
cursor.execute("CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255))")
# 插入数据
cursor.execute("INSERT INTO customers (name, address) VALUES ('John', '123 Street')")
# 查询数据
cursor.execute("SELECT * FROM customers")
rows = cursor.fetchall()
for row in rows:
    print(row)
# 关闭游标和连接
cursor.close()
conn.close()