Wednesday, February 20, 2019

SQL 2

SELECT * FROM pythonclub3.officer;
Use Sakila;
Select * from Actor;

Select first_name, last_name, title, description
From actor
inner join film_actor
using(actor_id)
inner Join Film
using(film_id)
Where last_name='Guiness'
And first_name='Sean'
Or title Like 'S%';

Select first_name, last_name, title, description
From actor
inner join film_actor
On actor.actor_id=film_actor.actor_id
inner Join Film
On Film.film_id=film_actor.film_id
Where last_name='Guiness';

Select * from payment
Where payment_date between '2005-06-01' and '2005-06-30';

Select * from payment where amount > 5;

Use Pythonclub3;
Insert into Member(memberlastName, memberFirstName, memberEmail, DateJoined)
Values('Jones','Dale','dj@gmail.com','2019-02-19');
Select * from member;
Insert into officermember(StartDate, member_idmember, Officer_idOfficer)
values('2019-02-20',2,2);
Insert into Location(LocationName, Address, City, zipcode, locationPhone)
values('Central','1701 Broadway','Seattle','98122', '2065551234');
Insert into meeting(MeetingDate, MeetingTime, MeetingTopic, OfficerMember_idOfficerMember, Location_idLocation)
Values('2019-02-20', '16:00:00', 'Stuff and more stuff', 2,1);

Update member
Set memberfirstname='Bill'
Where idmember=2;

Delete from member where idmember=2;

Insert into Member(memberlastName, memberFirstName, memberEmail, DateJoined)
Values('Mann','Doug','dm@gmail.com','2019-02-19'),
('Doe','jane','jd@gmail.com','2019-02-19'),
('Nelson','Anne','an@gmail.com','2019-02-19'),
('Brown','Sue','sb@gmail.com','2019-02-19');

No comments:

Post a Comment