("CREATE TABLE IF NOT EXISTS employees (" "id INTEGER PRIMARY KEY AUTOINCREMENT," "name VARCHAR(255)," "department_id INTEGER," "FOREIGN KEY (department_id) REFERENCES departments(id))") # 创建模型 model = QSqlRelationalTableModel(db=db) model.setTable('employees') model.setEditStrategy(...
DROP TABLE IF EXISTS employees; CREATE TABLE employees ( EmployeeId integer, FirstName varchar(50), LastName varchar(50), Title varchar(50), ManagerEmpId integer, HiredOn date, Salary integer, Com...