mysql --user=user_name --password=your_password db_name
NB! Kui loengus ei olnud, kysi parooli ja kasutajatunnust loengus/praxis!
create database facebook;
show databases;
use facebook;
mysql --user=... --password=... facebook
show tables;
describe <table>;
drop <table>;
create table tammet_users(
username VARCHAR(30),
name VARCHAR(40),
sex char(1),
various VARCHAR(200),
PRIMARY KEY (username));
id INT NOT NULL AUTO_INCREMENT
INSERT INTO tammet_users
(username,name,sex) VALUES('tanel', 'Tanel Tammet', 'M');
INSERT INTO tammet_users
(username,name,sex) VALUES('kaire', 'Kaire Kass', 'F');
INSERT INTO tammet_users
(username,name,sex) VALUES('mary', 'Mary Black', 'F');
INSERT INTO tammet_users
(username,name,sex) VALUES('john', 'John Smith', 'M');
INSERT INTO tammet_users
(username,name,sex) VALUES('william', 'William Blazkowicz', 'M');
mysql --user=fstudent --password=student facebook < proov.sql
create table tammet_friends(
id INT NOT NULL AUTO_INCREMENT,
inviter VARCHAR(30),
invitee VARCHAR(30),
status char(1) default 'I',
PRIMARY KEY (id));
insert into tammet_friends
(inviter,invitee) values ('tanel','kaire');
insert into tammet_friends
(inviter,invitee) values ('tanel','mary');
select * from tammet_friends;
select tammet_users.name,u2.name,u2.sex from
tammet_users,tammet_users u2,tammet_friends where
tammet_users.username=tammet_friends.inviter and
u2.username=tammet_friends.invitee;
create table tammet_users(
username VARCHAR(30) NOT NULL DEFAULT NULL,
name VARCHAR(40) NOT NULL DEFAULT NULL,
sex char(1),
various VARCHAR(200),
PRIMARY KEY (username));
show engines;