MySQL Tutorials: From Basic to Advanced

1 How to install/update MySQL on Windows

2 How to install/upgrade MySQL in Mac OS

3 How to make comments in MySQL statements (3+ approaches)

4 How to Execute an SQL File in VS Code

5 Where does MySQL 8 store data?

6 How to set up phpMyAdmin (Windows, Mac OS, Ubuntu)

7 What are the Default Username and Password for phpMyAdmin

8 How to completely uninstall MySQL from your system

9 How to use MySQL with Docker and Docker Compose

10 How to Set Connection Timeout in MySQL 8

11 How to interact with MySQL using command line

12 Understanding interactive_timeout and wait_timeout in MySQL 8

13 How to Install and Configure MySQL on Ubuntu 23.04

14 How to check your current MySQL version (Windows, Mac OS, Ubuntu)

15 MySQL 8: Ways to reset root password in Windows

16 MySQL 8: 3 Ways to Reset Root Password in macOS

17 MySQL 8: 2 Ways to Reset Root Password in Ubuntu

18 MySQL 8: How to create a new user with root privileges

19 MySQL 8: How to grant privileges to a user for a database

20 MySQL 8: How to revoke/restrict privileges from a user

21 Managing users and roles in MySQL 8: A practical guide

22 4 Ways to Create a New Database in MySQL 8

23 Using ENUM in MySQL 8: A Practical Guide (with Examples)

24 Ways to Rename a Database in MySQL 8 (3 Ways)

25 3 Ways to Drop a Database in MySQL 8

26 MySQL 8: 3 ways to see all databases in the server

27 MySQL 8: How to select a database to work with command line

28 MySQL: 4 Ways to list all tables in a database.

29 Data Types in MySQL 8: A Comprehensive Cheat Sheet

30 MySQL 8: How to create a table with auto-increment ID

31 Unsigned integer vs signed integer in MySQL 8: Explained with examples

32 MySQL: 3 ways to see the structure of a table

33 Ways to Rename a Table in MySQL 8

34 How to Drop a Table in MySQL 8 (Basic & Advanced)

35 How to empty a table in MySQL 8 (erase all data but keep the table structure)

36 How to add/remove columns to/from a table in MySQL 8

37 MySQL 8: How to rename a column of a table

38 MySQL 8: How to change charset and collation of a table

39 MySQL 8: How to change charset of a whole database

40 MySQL 8: Ways to Dump a Database to an SQL File

41 MySQL 8: 3 ways to import an SQL file to a database

42 MySQL 8: How to export a database to a CSV file

43 MySQL 8: How to export a database to a JSON file

44 What is the default port of MySQL server

45 What is MySQL Workbench and how to use it

46 MySQL 8: Can a table store 100 million rows

47 How to insert a new record into a table in MySQL 8

48 How to mass insert data into a table in MySQL 8

49 MySQL 8: How to Insert Text with Quotes into a Table

50 Using SELECT Statement in MySQL 8: A Comprehensive Guide

51 How to duplicate a table in MySQL 8

52 MySQL: Using WHERE clause in SELECT statement

53 MySQL: Using LIMIT and OFFSET to get a subset of records

54 MySQL: Using ORDER BY to sort records in SELECT statement

55 MySQL: How to Sort Rows by Multiple Columns

56 MySQL: How to Select DISTINCT Rows

57 MySQL: How to count the number of rows by a condition

58 Using AND & OR operators in MySQL 8: A Practical Guide

59 Using LIKE and NOT LIKE operators in MySQL 8: A Practical Guide

60 Using Loops in MySQL: A Practical Guide (with Examples)

61 MySQL 8: How to compare values (greater than, less than, equal to, etc.)

62 MySQL 8: How to use aliases for columns and tables in SELECT statement

63 MySQL 8: Add column with default value to an existing table

64 MySQL: How to reset the AUTO_INCREMENT value of a table

65 MySQL 8: How to get the size of a database

66 Using SHOW and DESCRIBE statements in MySQL 8: A Practical Guide

67 How to update rows in a table in MySQL 8

68 How to delete rows from a table in MySQL 8

69 MySQL 8: Adding, Removing, and Changing Indices of a Table

70 Understanding UNIQUE constraint in MySQL 8: A Developer's Guide

71 MySQL 8: How to search for a string in all tables of a database

72 MySQL 8: How to perform case-insensitive string comparison

73 Using Regular Expressions in MySQL 8: The Complete Guide

74 How to perform full-text search in MySQL 8

75 Using CONCAT function in MySQL 8: A Practical Guide

76 Using SUBSTRING function in MySQL 8: A Practical Guide

77 Using REPLACE function in MySQL 8: A Practical Guide

78 Using UPPER and LOWER functions in MySQL 8: A Practical Guide

79 Using REVERSE function in MySQL 8: A Practical Guide

80 Using CHAR_LENGTH and LENGTH functions in MySQL 8

81 How to escape special characters in MySQL 8

82 Using GROUP BY clause in MySQL 8: A Beginner’s Guide

83 MySQL 8 Aggregate Functions: SUM, AVG, MIN, MAX, COUNT

84 MySQL 8: Count rows in each group with GROUP BY and COUNT

85 MySQL 8: Find the min/max value in each group

86 MySQL: Eliminate orphan rows in one-to-many relationships

87 MySQL 8: Find the sum/average of values in each group

88 MySQL 8: CHAR, VARCHAR, TEXT, and BLOB data types - explained with examples

89 MySQL 8: INT, TINYINT, SMALLINT, MEDIUMINT, BIGINT data types - explained with examples

90 DOUBLE and FLOAT data types in MySQL 8: Explained with examples

91 DATE and TIME data types in MySQL 8: Explained with examples

92 MySQL 8: Timestamps with timezone - Explained with examples

93 MySQL 8: created_at and updated_at columns – A practical guide

94 MySQL 8: How to Group Data by Day, Month, and Year

95 MySQL 8: How to select rows from the last 7 days, 30 days, etc.

96 DEFAULT & ON UPDATE TIMESTAMP in MySQL 8: Explained with examples

97 CURDATE() and CURRENT_DATE() in MySQL 8: Explained with examples

98 CURTIME() and CURRENT_TIME() in MySQL 8: Explained with examples

99 NOW() and CURRENT_TIMESTAMP() in MySQL 8: Explained with examples

100 UNIX_TIMESTAMP() and UTC_TIMESTAMP() in MySQL 8: Explained with examples

101 Extracting date/time parts in MySQL 8 with built-in functions

102 TIMESTAMPDIFF() in MySQL 8: Get the difference between two timestamps

103 DATEDIFF() and TIMEDIFF() in MySQL 8: Get the difference between two dates/times

104 How to subtract Date/Time values in MySQL 8

105 How to add a time interval to a date value in MySQL 8

106 How to Create Custom Collations in MySQL

107 How to format date/time values in MySQL 8

108 MySQL: How to Remove FOREIGN KEY Constraints

109 MySQL: How to add a calculated column to SELECT query

110 How to convert a string to date/time in MySQL 8

111 FROM_UNIXTIME() in MySQL 8: Convert a UNIX timestamp to a date

112 The HAVING clause in MySQL 8: A Practical Guide

113 How to Monitor Query Latency in MySQL 8

114 Using Index Scans for Sorts in MySQL 8: A Practical Guide

115 Multicolumn Indices in MySQL 8: A Practical Guide

116 MySQL: How to deal with redundant and duplicate indices

117 MySQL 8: How to clean unused indices in a database

118 MySQL 8: How to find and replace table corruption

119 Table partitioning in MySQL 8: A Practical Guide

120 Using UNION operator in MySQL 8: The Complete Guide

121 How to implement cursor-based pagination in MySQL (3 examples)

122 How to execute subqueries in MySQL 8: A Practical Guide

123 MySQL: IS NULL and IS NOT NULL operators - Explained with examples

124 Using BETWEEN operator in MySQL 8: A Practical Guide

125 MySQL: Selecting rows between two dates/times - A Practical Guide

126 MySQL: IN and NOT IN Operators – Explained with Examples

127 Understanding CHECK constraint in MySQL 8: A Practical Guide

128 One-to-Many Relationship in MySQL 8: A Practical Guide

129 Working with FOREIGN KEY in MySQL 8: A Developer's Guide

130 Many-to-Many Relationship in MySQL 8: A Practical Guide

131 MySQL: Creating a Fixed-Size Table by Using Triggers

132 Cross Join in MySQL 8: A Practical Guide

133 Inner Joins in MySQL 8: A Practical Guide

134 Left Join in MySQL 8: A Practical Guide

135 Using LEFT JOIN with GROUP BY in MySQL 8: A Practical Guide

136 Right Join in MySQL 8: A Practical Guide

137 Views in MySQL 8: A Comprehensive Guide

138 MySQL 8: Using OVER() to define a window frame in a query

139 Using ROW_NUMBER() function in MySQL 8: A Practical Guide

140 Using RANK() and DENSE_RANK() in MySQL 8: A Practical Guide

141 MySQL 8: FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE() functions – Explained with examples

142 Using LEAD() and LAG() functions in MySQL 8: A Practical Guide

143 Using GROUP_CONCAT() function in MySQL 8: A Practical Guide

144 Using NTILE() function in MySQL 8: A quick Guide

145 Using the EXPLAIN statement in MySQL 8

146 MySQL Upsert: Update if exists, insert if not

147 MySQL: ON DUPLICATE KEY UPDATE Statement - Explained with Examples

148 MySQL 8: INSERT IGNORE statement - Explained with examples

149 How to Set Expiration Date for a Record in MySQL 8

150 How to Auto Backup MySQL Database to Google Drive

151 MySQL 8: Using ROLLUP modifier with GROUP BY clause

152 Replication in MySQL 8: A Comprehensive Guide

153 MySQL: How to migrate a database to a new server

154 Cascade delete in MySQL 8: A Practical Guide

155 MySQL 8: How to count rows in related tables

156 MySQL 8: Sorting rows in table A by column in table B

157 How to read log files in MySQL 8

158 MySQL 8: How to create a replica using Percona XtraBackup

159 MySQL 8: How to create a replica using mysqldump

160 MySQL 8: Creating a replica using mydumper and myloader

161 Using ‘BEFORE INSERT’ trigger in MySQL 8: A Practical Guide

162 Using 'AFTER INSERT' trigger in MySQL 8: A Practical Guide

163 Using ‘AFTER UPDATE’ trigger in MySQL 8: Tutorial & Examples

164 Using 'AFTER DELETE' trigger in MySQL 8: Explained with examples

165 Transaction, commit, and rollback in MySQL 8: A Practical Guide

166 MySQL 8: How to enable/disable remote connections

167 JSON Data Type in MySQL 8: Tutorial & Examples

168 Using JSON_EXTRACT() function in MySQL 8 (with examples)

169 Working with JSON_ARRAY() function in MySQL 8

170 Understanding JSON_OBJECT() function in MySQL 8

171 Working with JSON_INSERT() function in MySQL 8

172 Using JSON_REPLACE() Function in MySQL 8

173 Making use of the JSON_REMOVE() function in MySQL 8

174 MySQL 8: Using JSON_SET() function to insert or update a JSON document

175 How to Prevent SQL Injection in MySQL 8: Explained with Examples

176 Pivot tables in MySQL 8: A Practical Guide

177 MySQL 8: Get the ID of the last inserted row

178 MySQL 8: Get the latest row of each group with GROUP BY (3 approaches)

179 Working with Self-Referencing and Self-Join in MySQL 8

180 MySQL 8 Example: Storing Categories and Subcategories in a Single Table

181 MySQL 8: How to Limit Results in Each Group

182 MySQL 8: How to concatenate multiple rows into a single string

183 MySQL 8: 5 ways to check if a row exists in a table.

184 MySQL 8: 3 ways to remove duplicate rows from a table

185 4 Ways to Select a Random Row in MySQL 8

186 How to efficiently select N random rows in MySQL 8

187 MySQL 8: Set a fallback value for NULL columns in SELECT statement

188 How to check constraints of a table in MySQL 8

189 MySQL 8: 4 Ways to Fill Missing Values in a Table

190 The Right Way to Store an Array in MySQL 8

191 Spatial Data Types in MySQL 8: A Practical Guide

192 Spatial Functions in MySQL 8: A Comprehensive Guide

193 MySQL 8: The right way to store location (latitude, longitude) in a table

194 MySQL 8: Calculate the distance between two locations (latitude, longitude)

195 MySQL 8: Set a custom starting value for AUTO_INCREMENT column

196 How to import a CSV file into a table in MySQL 8

197 MySQL 8: Searching Values in a String Separated by Comma

198 MySQL 8: UPDATE on a SELECT query in multiple tables

199 MySQL 8: Using string interpolation in a query (with examples)

200 Best practices for naming tables and columns in MySQL 8

201 MySQL 8: Get a list of dates between two given dates

202 MySQL 8: How to select all columns except password column

203 How to Define and Use Variables in MySQL 8

204 Using IF…THEN Statements in MySQL 8

205 Using CASE-WHEN statements in MySQL 8: A Practical Guide

206 MySQL 8: Using WHERE, GROUP BY, and HAVING together in a query

207 MySQL 8: How to query column names of a table

208 MySQL 8: How to add a prefix to auto-incremented column values

209 How to execute recursive SELECT queries in MySQL 8

210 How to correctly save Emoji in MySQL 8

211 How to use the WITH clause in MySQL 8: Tutorial & Examples

212 MySQL 8: How to update multiple tables in a single query

213 Using Hash Indexes in MySQL: A Practical Guide

214 MySQL: Using R-Tree Indexes for Spatial Data Types

215 Understanding Full-Text Indexes in MySQL

216 Partial Indexes in MySQL: A Practical Guide