Sql course dec1

Course Outline

mysql download

get mysql-x.x.xx-osx10.x-x86_32.pkg

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

alias mysql=/usr/local/mysql/bin/mysql

alias mysqladmin=/usr/local/mysql/bin/mysqladmin

go into system preferences, click mysql, start the server

type in mysql at the command line

reference manual

SQL Programming

SQL Cheat Sheet

xkcd tables

create table dept (deptno int(2), dname varchar(15), loc varchar(12));

insert into dept values (10, 'accounting', 'new york'), (20, 'research', 'london'), (30, 'sales', 'paris'), (40, 'operations', 'berlin');

select * from dept;

---

create table salgrade (grade int(1), losal int(4), hisal int(4));

insert into salgrade values (1, 700, 1200), (2, 1201, 1400), (3, 1401, 2000), (4, 2001, 3000), (5, 3001, 9999);

select * from salgrade;