Thursday, August 3, 2017

MySQL SQL

use pythonclub2;
Select * from announcements;

Create user memberUser; 

Select * From MeetingNotes;

Select meetingsDate, MeetingTime, PlaceName, Meetingminutes
From meetings
inner join meetingnotes
on meetings.idMeetings=meetingnotes.Meetings_idMeetings
inner join places
on places.idPlaces=meetings.Places_idPlaces
Where MeetingsDate = '2017-06-21';

Insert into meetings(idMeetings, MeetingsDate, 
MeetingTime, Places_idPlaces)
Values(4,'2017-8-3','20:00:00',1);

Insert into Meetingnotes(idMeetingNotes, 
Meetings_idMeetings, MeetingMinutes)
values(4,4,'This meeting hasn''t happened yet');

Select * from Resources;

Update Resources
Set ResourcesName='John''s web Tutorial'
where idResources=1

No comments:

Post a Comment