SQL in Python Projects

1. It is recommended to do ...
2. Some text It is how code looks like text again
3. Use such method.

import sqlite3

# Connect to the database or create it
conn = sqlite3.connect('mydatabase.db')

# Create a cursor object
cursor = conn.cursor()

# Create the "users" table with fields
cursor.execute('''
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER,
        user_name TEXT,
        email TEXT,
        password TEXT
    )
''')

# UPDATE the record
query = "UPDATE users SET email = 'new@gmail.com' WHERE id = 1"
cursor.execute(query)

# Execute SELECT query
select_query = "SELECT * FROM users"
cursor.execute(select_query)

# Output
data = cursor.fetchall()
print(data)

# Save changes and close the connection
conn.commit()
conn.close()