from sqlsetup import connect, run, commit, tbl, close connect('sakila') run("SELECT * FROM address") tbl() close() connect('mydb') run("SELECT * FROM player") tbl() run("DESC player") close()
# M-RET run from sqlsetup import connect, run, commit, tbl, close, sel connect('learning')
from sqlsetup import connect, run, commit, tbl, close, sel connect('bank') sel("SHOW TABLES;") sel("SELECT fname, lname FROM employee;") sel("SELECT * FROM department;") sel("SELECT * FROM employee;") sel("SELECT emp_id, 'Active', emp_id * .5, UPPER(lname) FROM employee") sel("SELECT VERSION(), USER(), DATABASE();") # no FROM needed sel("""SELECT UPPER(lname) AS last_name_upper, emp_id AS employee_id FROM employee""") sel("SELECT DISTINCT cust_id FROM account") run("""CREATE VIEW employee_vw AS SELECT emp_id, fname, lname, YEAR(start_date) start_year FROM employee;""") commit() sel("""SELECT employee.emp_id, employee.fname, department.name dept_name FROM employee INNER JOIN department ON employee.dept_id = department.dept_id;""")