LabCatsCoding Examples
CRUD
SQL is SELECT m.member_id, m.first_name, last_name, avatar, age, language FROM member m LEFT JOIN language l ON m.language_id=l.language_id GROUP BY m.member_idThis demonstrates how the basic CRUD functions work.
- C: is achieved by clicking on the Add Member button to add a member. This also has an example of getting the id created by inserting a new reocrd in member so that you can create the appropriate record in the member_major_lookup table
- R: reading the data or showing the contents of a query as a table
- U: Updating or editing a record
- D: Delete
IDAvatarFirst NameLast NameAgeLanguageEditDelete236
KatieObserver16SpanishEdit Delete237
EvaFoster16ChineseEdit Delete238
MargotFrisbeeign16ChineseEdit Delete239MargaretBoston17SpanishEdit Delete240
HadleyCrazed17ChineseEdit Delete241
FionaFitz16SpanishEdit Delete
KatieObserver16SpanishEdit Delete237EvaFoster16ChineseEdit Delete238MargotFrisbeeign16ChineseEdit Delete239MargaretBoston17SpanishEdit Delete240HadleyCrazed17ChineseEdit Delete241FionaFitz16SpanishEdit Delete