Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. The slogan table
Concatenation
Simple text functions
Modifying strings
Summary

Instruction

Finally, let's look at the third table.

Exercise

Select all data from the slogan table. For each record, we have:

  • id – an identifier.
  • item_id – an ID of an advertised product.
  • type – the best medium for the slogan (e.g., TV, Internet, or newspapers).
  • text – the slogan itself.
  • copywriter_id – the ID of the copywriter who wrote that slogan.