mysql 写入数据

INSERT INTO users (username, email, password)
VALUES ('john_doe', 'john@example.com', 'secure_password');

UPDATE users
SET email = 'john_new@example.com'
WHERE username = 'john_doe';

DELETE FROM users
WHERE username = 'john_doe';

import mysql.connector

try:
    conn = mysql.connector.connect(user='your_user', password='your_password',
                                  host='your_host', database='your_database')
    cursor = conn.cursor()
    cursor.execute("INSERT INTO users (username, email) VALUES (%s, %s)", ('john_doe', 'john@example.com'))
    conn.commit()
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if conn.is_connected():
        cursor.close()
        conn.close()

INSERT INTO users (username, email) VALUES 
('user1', 'user1@example.com'),
('user2', 'user2@example.com'),
('user3', 'user3@example.com');

START TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;