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;""")
