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');
Wednesday, February 20, 2019
SQL 2
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment