Using Many to Many SQL Relationships and Intermediate Tables
When working in a complex database, you can use an intermediate table to create a many-to-many(M:N)
SQLMany-To-Many RelationshipsDatabase
SQL
February 20, 2021
By Francis Ndungu
Articles in category: Database
Find and Delete Duplicate Rows in MySQL with GROUP BY and HAVING Clauses
Sometimes, you might see more than one copy of the same record appearing in a MySQL database table.
GROUP BYHAVING ClausesMySQL
SQL
February 20, 2021
By Francis Ndungu
Working with MySQL Restrictive Mode
When some of the MySQL columns in a table are defined with the keyword NOT NULL, you may get an erro
Database ManagementSQL ModesMySQL
SQL
February 20, 2021
By Francis Ndungu
How to Implement MySQL Full-Text Search
A MySQL full-text search index allows you to find matches for a given keyword against character-base
Database ManagementFull-Text SearchMySQL
SQL
February 20, 2021
By Francis Ndungu
Use MySQL Dual Passwords to Change Credentials without Downtime
Starting from MySQL 8.0.14, you can have dual passwords for users accounts. You can use this featur
PHPWeb ServersMySQL
SQL
February 20, 2021
By Francis Ndungu
Improve MySQL Data Integrity With Check Constraints
Starting from MySQL 8.0.16 database server and later versions, a CHECK constraint is a feature that
Data IntegrityCheck ConstraintsMySQL
SQL
February 20, 2021
By Francis Ndungu
Use MySQL Union Clause For Reporting
The MySQL UNION statement combines the results of multiple SELECT statements. The clause is useful w
Union ClauseDatabase ManagementMySQL
SQL
February 20, 2021
By Francis Ndungu
Secure MySQL Database with System Roles and Permissions
In MySQL, a role is a group of named privileges that can be assigned to users. When creating a datab
System RolesDatabasesMySQL
SQL
February 10, 2021
By Francis Ndungu