Database Master Files

Usage:

1. Import the given package in an empty Python file.
2. Run the file where you imported the package as a program (double click on the file).
3. Enter data from the database.
4. In the Request field, enter the SQL command.
5. Click on the Done button.

Examples of SQL commands:

1. Creating a table - CREATE TABLE 'users'(id int AUTO_INCREMENT, name varchar(32), password varchar(32), PRIMARY KEY (id));
2. Adding data to a table - INSERT INTO 'users' (name, password) VALUES ('Jack', '12345');
3. Changing data in a table - UPDATE 'users' SET password = '6789and10' WHERE id = 1;
4. Removing data from a table - DELETE FROM 'users' WHERE id = 1;
5. Dropping a table - DROP TABLE 'users';