This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Create tables to hold data for your movie collection. | |
| Create table Movies (id int identity primary key, | |
| Title varchar (100), | |
| Director varchar (100), | |
| Runtime smallint, --Consider naming this runtime_minutes (this makes it clear as to the units) | |
| Genre_id int, | |
| Release_Year year); | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --create database for testing rollback | |
| create database if not exists dmstest; | |
| use dmstest; | |
| create table people( | |
| id int auto_increment |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import pyautogui | |
| import time | |
| while True: | |
| pyautogui.moveRel(0, 10) | |
| time.sleep(2) |
OlderNewer