The benefit of this approach is that you can then regularly scan your entire code base for the use of .ExecuteReader and .ExecuteNonQuery knowing that there should be no cases of those methods, other than the exception cases you expect.

Camel Case Table Names in MySQL

by stephen.vaubell

A solution to casing problems in MySQL

Collaborative Filtering in MySQL: A Tutorial

by Arctype SQL

Simple examples of collaborative filtering with fundamental logic behind all of these systems boiling down to same principles used here

Cross-Tabulation (Pivot Tables) with MySQL

by Cale Dunlap

Example of using code-based query generation, transposition, cross-tabulation, and normalized data to produce a query result that can feed a simple chart from data which was not originally designed with reporting or charting in mind.

DbKeeperNet - How to Seed ASP.NET Users and Roles

by voloda2

DbKeeperNet - How to seed ASP.NET Users and Roles

Designing your Azure MySQL DB with a UWP Demo

by Abdelrahman El Kinani

Azure MySQL DB, how to design it, basic UWP todo demo

Diagnosing a collation issue in a MySQL stored procedure

by Sebastian Solnica

Diagnosing a collation issue in a MySQL stored procedure.

Django 2 CRUD Tutorial: Generic Class-Based Views

by Ahmed Bouchefra

A Django 2 CRUD example application using generic class based views using the latest Python 3.7 version

Django 3 Tutorial & CRUD Example with MySQL and Bootstrap

by Ahmed Bouchefra

In this tutorial, we’ll see by example how to create a CRUD application from scratch and step by step. We’ll see how to configure a MySQL database, enable the admin interface, and create the django views.

Duplicate MySQL Table Using phpMyAdmin

by Sifiso W Ndlovu

Duplicate MySQL table using phpMyAdmin

How Can PHP Import Excel to MySQL using a PHP XLSX Reader and Excel XLSX Converter

by Haseeb A. Basil

How can PHP import Excel to MySQL using a PHP XLSX Reader and Excel XLSX converter

How to Pull Blobs Out of Archive Storage

by Kevin Mack

When storing data in Azure blob storage, the process of upload a blob is fairly straight forward, and all it takes is setting the access tier to “Archive” to move data to blob storage.

Importance of Logging in MySQL

by Biswal Tanmaya

This blog post discusses the importance of logging in MySQL

MySQL: Condition Based Sorting

by Suvendu Shekhar Giri

Sort the result set as per your need

Oozie Coordinator - Scheduling and Data Dependencies

by Member 13359958

How scheduling and data dependencies work in Oozie coordinator job

PHP MySQL Login Form

by jotorres

In this tutorial, you will learn how to create a login form for your website using PHP and MySQL.

PowerShell Script to Split Single-file Routines Export from MySQL Server

by Sujay Sarma

PowerShell script to split single-file routines export from MySQL Server

Save Records to Database with PHP and MySQL

by jotorres

For those of you who do not know how to create an insert using PHP and MySQL, here I will teach you.

Search MySQL Like Google Using Match and Full-Text Search

by Arctype SQL

How to use full text search and the match keyword to find a string in every table in a MySQL database

Server Side Filtering with jqxGrid using PHP and MySQL

by jqwidgets

Server Side Filtering with jqxGrid using PHP and MySQL

Simple Sync Apps

by Edison Heng

Synchronizing between Android and desktop

StatefulSets and Deployments in Kubernetes

by Trần_Tuấn_Anh

Kubernetes has revolutionized the way we manage containerized applications, providing robust tools to deploy, scale, and manage workloads. Two critical resources in Kubernetes for managing applications are Deployments and StatefulSets.

Unable to Start MySQL Service

by Jason Sultana

A solution for a MySQL service that's refusing to start

Using Cursors and for Loops in MySQL

by Arctype SQL

Learn how to write a MySQL cursor or a MySQL loop

Using MySQL database to save .NET traces

by Sebastian Solnica

How to configure the SqlDatabaseTraceListener to work with a MySQL database.

What are the Major Parts of a SQL DB?

by essentialSQL

This post discusses the major parts of a SQL database

What is a Database Trigger?

by essentialSQL

What is a Database Trigger?

What is SQLite3?

by essentialSQL

SQLite3 is a compact free database you can use easily to create and use a database. Learn more about it in this blog post.