Page 41 - Phyton_GUIprogrammingwithTkinter

P a ge | 32

iv. Open IDLE Shell and it will show as the following when the database is
successfully created.

3. CREATE Tables

i. How to create a table is the same as how to create a database. We just enter
the SQL command or query into the method execute ().
ii. But before that, make sure the connector has been given parameters
database to determine which database to use.

iii. In the code above we pass the parameter database="grocery_shop".
iv. Create a new file named create_table.py, then fill it with the following code.