Victor A. Oguntuase
About Victor A. Oguntuase
Victor is an experienced Python Developer, Machine Learning Engineer and Technical Writer with interests across various fields of science and engineering. He is passionate about learning new technologies and skill and working on challenging problems. He enjoys teaching, intellectual discourse, and gaming, among other things.
howto · 2024-02-02
How to Insert Value in MySQL Table With Duplicate Keys Validation
This tutorial shows how to insert a value into a MySQL table with proper validation for the existence or otherwise of duplicate keys/values.
howto · 2024-02-02
How to Get the Current Date in MySQL
This tutorial describes the various methods to get the current date from a MySQL host system.
howto · 2024-02-02
How to Format and Store Phone Numbers in MySQL
This tutorial illustrates the handling and formatting of phone number fields in a MySQL database. The choice of the most appropriate datatypes based on database requirements is also discussed.
howto · 2024-02-02
How to Retrieve Data Within a Date Range in MySQL
This tutorial illustrates the method of selecting and retrieving data within a date range in MySQL using comparison operators.
howto · 2024-02-02
How to Implement Flush Privileges in MySQL
This tutorial introduces the flush privileges command in MySQL for refreshing the grants table and effecting permitted changes.
howto · 2024-02-02
How to Find Duplicate Records in a MySQL Table
This tutorial illustrates the methods of detecting and counting the number of duplicate records in a MySQL table using a combination of the Select, Distinct, and Count keywords.
howto · 2024-02-02
How to Change Column Datatype or Property in MySQL
This tutorial explains the process of changing the datatype and other attributes or constraints of an existing column in a MySQL database table.
howto · 2022-02-09
The Datepart Function Alternatives in MySQL
This tutorial illustrates alternative methods to the general SQL datepart function for extracting parts of a datetime in MySQL.
howto · 2022-02-09
Nested Select Statements in MySQL for Enhanced Query
This tutorial introduces the concept of nested select statements for advanced querying in MySQL. A few included examples also illustrate possible use-cases of this concept.