Date Functions: DATE_FORMAT, DAYOFWEEK and LAST_DAY
Lessons in this course
- MySQL Server, Databases and Your First SELECTFree
- Integer Types: Bytes, Ranges and UNSIGNED Locked
- DECIMAL for Money: Precision, Scale and Rounding Locked
- CHAR and VARCHAR: Text Columns and Their Size Locked
- DATE, DATETIME and TIMESTAMP Locked
- CREATE TABLE: Columns, Types and Row Size Locked
- PRIMARY KEY: One Unique Id per Row Locked
- AUTO_INCREMENT: How MySQL Numbers New Rows Locked
- FOREIGN KEY: Linking Orders to Customers Locked
- NOT NULL, DEFAULT and UNIQUE Locked
- INSERT: Adding Rows, Multi-Row VALUES and INSERT … SELECT Locked
- SELECT with WHERE, IN, BETWEEN and LIKE Locked
- ORDER BY and LIMIT: Top Lists and Paging Locked
- UPDATE: Rows Matched vs Rows Changed Locked
- DELETE and TRUNCATE: Removing Rows Safely Locked
- String Functions: CONCAT, LPAD, LENGTH vs CHAR_LENGTH Locked
- NULL in Calculations: IFNULL and COALESCE Locked
- Date Functions: DATE_FORMAT, DAYOFWEEK and LAST_DAY Locked
- GROUP BY and HAVING: One Row per Category Locked
- JOIN and LEFT JOIN: Orders, Products and Customers Locked
- Final Project: The March Sales Report Locked