ubuntu mysql命令

sudo apt update
sudo apt install mysql-server

sudo systemctl start mysql
sudo systemctl stop mysql

sudo systemctl status mysql

mysql -u username -p

CREATE DATABASE database_name;

CREATE TABLE table_name (
    column1 datatype constraints,
    column2 datatype constraints,
    ...
);

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

SELECT * FROM table_name;

UPDATE table_name SET column1 = value1 WHERE condition;

DELETE FROM table_name WHERE condition;

import mysql.connector

# 连接到MySQL数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
mycursor = mydb.cursor()

# 执行查询
mycursor.execute("SELECT * FROM yourtable")

# 获取查询结果
myresult = mycursor.fetchall()

for x in myresult:
  print(x)