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
Thursday, August 3, 2017
MySQL SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment