I don't know what is wrong (Python and SQL connection)

[Pedroski55]

Maybe the CREATE command has a problem?

Instead of AUTOINCREMENT try AUTO_INCREMENT? Otherwise AUTOINCREMENT may be interpreted as a column name.

CREATE TABLE IF NOT EXISTS patients (
id INTEGER PRIMARY KEY AUTO_INCREMENT,
reference_no TEXT,
issued_date TEXT,
appointment_date TEXT,
patient_id TEXT,
patient_name TEXT,
date_of_birth TEXT,
patient_address TEXT,
nhs_number TEXT,
name_of_tablets TEXT,
no_of_tablets TEXT,
dose TEXT,
use_medication TEXT,
doctor_name TEXT
)

This works in my MySQL database:

INSERT INTO patients (
reference_no, issued_date, appointment_date, patient_id, patient_name, date_of_birth,
patient_address, nhs_number, name_of_tablets, no_of_tablets, dose, use_medication, doctor_name
) VALUES ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M')

SELECT id, use_medication, doctor_name FROM patients WHERE 1