Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

String Functions: CONCAT, LPAD, LENGTH vs CHAR_LENGTH

Lesson 16 of 21 Lab 🔒 Locked

Lessons in this course

  1. MySQL Server, Databases and Your First SELECTLabFree
  2. Integer Types: Bytes, Ranges and UNSIGNEDLab Locked
  3. DECIMAL for Money: Precision, Scale and RoundingLab Locked
  4. CHAR and VARCHAR: Text Columns and Their SizeLab Locked
  5. DATE, DATETIME and TIMESTAMPLab Locked
  6. CREATE TABLE: Columns, Types and Row SizeLab Locked
  7. PRIMARY KEY: One Unique Id per RowLab Locked
  8. AUTO_INCREMENT: How MySQL Numbers New RowsLab Locked
  9. FOREIGN KEY: Linking Orders to CustomersLab Locked
  10. NOT NULL, DEFAULT and UNIQUELab Locked
  11. INSERT: Adding Rows, Multi-Row VALUES and INSERT … SELECTLab Locked
  12. SELECT with WHERE, IN, BETWEEN and LIKELab Locked
  13. ORDER BY and LIMIT: Top Lists and PagingLab Locked
  14. UPDATE: Rows Matched vs Rows ChangedLab Locked
  15. DELETE and TRUNCATE: Removing Rows SafelyLab Locked
  16. String Functions: CONCAT, LPAD, LENGTH vs CHAR_LENGTHLab Locked
  17. NULL in Calculations: IFNULL and COALESCELab Locked
  18. Date Functions: DATE_FORMAT, DAYOFWEEK and LAST_DAYLab Locked
  19. GROUP BY and HAVING: One Row per CategoryLab Locked
  20. JOIN and LEFT JOIN: Orders, Products and CustomersLab Locked
  21. Final Project: The March Sales ReportLab Locked