Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Everything / database / MySQL

MySQL

MySQL

Great Reads

by Romelard Fabrice (Alias F___)
Class Library for MySQL request
by emadns
A basic tutorial for ReportMax tool
by emadns
Using the Chart control in ReportMax
by SrikantSahu
This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

Latest Articles

by Romelard Fabrice (Alias F___)
Class Library for MySQL request
by emadns
A basic tutorial for ReportMax tool
by emadns
Using the Chart control in ReportMax
by SrikantSahu
This tip gives basic commands to import table from Mysql to Hadoop File system and Import the files from HDFS back to Mysql.

All Articles

Sort by Score

MySQL 

by Romelard Fabrice (Alias F___)
Class Library for MySQL request
by Arthur V. Ratz
A Simple Web Application User Authentication Project using Passport.js And JSON Web Tokens (JWT) explained
by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
by Jörgen Andersson
A propertymapping extension for DataReaders
by Amit Kumar Dutta
Discusses a technique to record current geographic location from mobile and display in web pages (with Location History Browsing)
by Murray Brooks Davis
How to make a simple, end-to-end, mobile, Java enterprise application including a RESTful web service and an Android client.
by Oso Oluwafemi Ebenezer
Implementing a simple webchat using PHP and MySQL
by Renato Tegon Forti
A set of class to access and manipulate MySQL database using MySQL C API
by Hazem Torab
Source code for a generic comments module, using AJAX/PHP/MySQL.
by scott_liu
It employs a dynamic trigger, a CLR Stored Procedure, and a Web Service to sync data from a MS SQL Server to MySQL.
by vivekthangaswamy
How to use a MySQL 4.1 database from an ASP.NET application and some ODBC basics.
by Satish Jagtap
This article explains how to import database to MySQL server and how to export database from MySQL server without using batch files.
by Harry Kimpel
A brief description on how to set-up MySQL as session state store for ASP.NET.
by Jeff Bazinet
VwdCms.ImageZoom is a server control that provides zoom in and out and best-fit image resizing. The control is very simple and is a good example of how to manipulate the size of images with JavaScript
by Robin Rizvi
Audio-Gallery-Suite is a complete audio gallery solution made with HTML5/CSS3/Jquery-JS/PHP-Ajax/C# that includes a web audio gallery and a software for managing the web audio gallery.
by Petr Kozelek
Logging of data changes in relational databases
by Mr. xieguigang 谢桂纲
You see, this small utility tool save much of your time, this is another happy day! I hope you can enjoyed this code.
by Hariprasanth S
A CLI to automate database backups with customizable recurring schedules
by JBartlau
This article demonstrates how Report Server offers a distribution of reports that save time, increase efficiency, and reduce potential errors.
by adriancs
Building a .NET Core Linux Project with MySqlBackup.NET
by Peter Leow
A bridging introduction to server-side scripting.
by jqwidgets
How to connect our jQuery Chart to MySql Database using PHP
by Yuancai (Charlie) Ye
Continuous SQL-stream Sending and Processing System
by Uwe Eichkorn
BSEtunes is a MySQL based, full manageable, networkable single or multiuser jukebox application
by Ivo Katunaric
In this post, you’ll learn how to build a basic CRUD (Create, Read, Update, Delete) application and secure the application using Okta.
by Krasimir Hristozov
In this article, I’ll show you how to build a simple REST API in PHP from scratch. We’ll make the API secure by using Okta as our authorization provider and implementing the Client Credentials Flow.
by V.
First article on creating a reusable framework
by SarmadAsghar
This will provide opportunity to calculate aggregates, joins on the data retrieved from API’s which was never done.
by kribo
An article on how to connect to a MySQL database using the Connector/NET 5.2
by Edacio
This is a MySQL based Profile Provider written in C# for .NET 2.0
by cellarjay
Accessing the MYSQL Database at your webspace from any remote computer
by BrainlessLabs.com, sibani.p
Creating a simple ORM for C++ on-top of SQL database
by CarNet-India
CarNet is a project which involves creation of an mesh network between vehicles moving in vicinity of each other.
by Kuldip Rindani
This script calculates size of every user database with summary
by smoore4
Loop through all files in a folder/subfolders and run a checksum that is stored in a database. E-mail descrepancies and results.
by Chris_Riley
Klocwork is kind of like my code spell check, or professional editor. It just makes me sound good. And if I were part of a larger dev team it would be quite a powerful management tool.
by ambatisreedhar
An article on how to configure Joomla in a step by step manner
by Mathew G Sujith
Connecting ASP.NET and MySQL
by adriancs
Silverlight access to MySQL using Web Services.
by User 992674
This article shows you how to connect to MySQL database using MySQL Connector for .NET
by Lizandro Campbell
Using Visual C# 2008 to establish connection to a MySQL 5.1 database with MySQL Connector/NET 5.1.7
by alex turner
How about a .NET COBOL program which uses ADO.NET to connect to either MySQL or SQL Server?
by henry sentio kauta
Android at figure tips
by Bogdan Marian
Ensure your Docker Compose services start in the correct order
by StylezHouse
A porting of the ASP.NET reporting starter kit to use Mono, MySQL and Apache on a Linux system.
by Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
by Arthur V. Ratz
The readers of this article will find out how to use Clarifai API for Node.js to create and deploy a lightweight vehicles images classification web-application.
by Member 4206974
CrossData is a PHP object for creating an HTML table or a PHP array, crossing two fields of a table from a PDO accessed database.
by Matthew Casperson
In this article, Using MSAL to Access Azure APIs, we use the OBO OAuth flow to call a service in Azure. Then, we’ll communicate the results back to the frontend application via a shared database.
by BD Star
Create-Read-Update-Delete(CRUD) operation by MySQLi procedural way in the PHP
by Shivanand Alagi
Data access layer for MySQL based web projects.
by Suhel Shah
Custom implementation of Microsoft Membership and Role provider using Fluent Nhibernate
by Ashish Tripathi
DALC4NET is an Open Source data access layer built for Microsoft .NET projects. It enables us to access data from databases including SQL Server, Oracle, MySQL, MS Access, and MS Excel.
by zhongzf
An open source Data Access Component
by pseudonym67
Getting MySQL running and programming it with KDevelop.
by seesharper
An abstract syntax tree implementation for SQL
by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
by Zijian
Reusable codes for OAuth security in business applications
by Frédéric -lefred- Descamps
How to install WordPress on Oracle Cloud Infrastructure (OCI) using always free tier
by Han Bo Sun
Create a simple web app to support UTF-8 encoded strings
by User 6744868
Discussion about developing PHP/SOAP Web Services and implementing them using C#.
by André Marcos (Advisor), Thiago de Oliveira Lima, William Pereira de Souza
This web-based tool aims to facilitate the location of a person's data through their basic references information.
by BharatRamV
Distributed transaction between MS SQL Server and MariaDB - A myth.
by Kourosh K Tari
How to duplicate a record in MySQL table with auto increment key
by SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5
by Tharaka MTR
Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages.
by venugopalm
Database and Library Design for Customer Order Management System
by mbarbac
Kerosene ORM support for complete database-alike WCF services and connections
by Packt Publishing
Best practices in Kubernetes
by David Wincelberg
Strings that differ by typos can be matched.
by JUST_Neeraj
A Simple Messaging\ Workflow \ETL system on MySQL and .NET
by Mike V Baker
In this article, we’ll extend the dtSearch Engine-based example to use Amazon’s Aurora storage service, which is a hosted MySQL solution available through AWS.
by ColinBashBash
Generate classes / CRUD procedures.
by ezekielen
Dynamically generate SQL INSERT commands programmatically and run then in batches of hundreds to bulk load data from a .NET DataSet with multiple DataTables to MySql
by Emiliano Musso
Geolocalize a device and store coordinates on webserver
by Oso Oluwafemi Ebenezer
Using PHP and MySQL to get if a user is online, the number of users currently online, the highest online ever, the number of users online today, and the Last Seen time of a user.
by Jeremy Todd
Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.
by Gurux Ltd
Retrieve data from a physical device, process it, and visualize the results
by Han Bo Sun
Detailed description of how many-to-many association works with Hibernate, using MySQL and Spring
by Mohammad Dayyan
Shows you how using PHP Fusion 7 CAPTCHA class
by rohit7209
Use AccessRemoteMySQLDB-API in your project to access web-server MySQL database
by Emmanuel Kartmann
This article provides a small executable (36K) which configures MySQL (or another Windows Service) to automatically restart whenever it fails/crashes.
by le quang anh - leadershipqa
This is a sample that guides you to create reports with Crystal Reports using C# and MySQL RDBMS.
by Simon Robert VoIP
This article presents a simple example on how to insert automated reminders about appointments, meetings to MySQL table with the help of PHP
by adriancs
Step by step guide for installing MySQL on CentOS
by mislc
Complete code to query a MySQL database in plain PHP
by Renz Ladroma
How to Setup Master-Slave Replication in MySQL using CentOS
by Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
by Satish Jagtap
This article explains how to import database to MySQL server and how to export database from MySQL server.
by Ryan Krage
Display Infobright/MySQL Database Statistics in Java
by Ryan Krage, Binfeng Yuan
Display Infobright/MySQL Database Statistics in C++
by AmitGajjar
Create, Read, Update and Delete operations in ASP.Net with MySQL database with N-Tier Architecture
by Henry He
In this article, I will explain how to install and configure Drupal 7.8, HTTP Server 2.2.21, PHP 5.3.8, and MySQL 5.5.1 on Windows 7.
by Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
by Han Bo Sun
In this article, I will show you how to integrate Hibernate Search into a simple yet feature complete web application with the Spring MVC and Hibernate enabled.
by Ralf Meier, Shah Samiur Rashid
Codeless Combobox for VB.NET/C# platform with MySQL/SQL Server database applications
by Mark Pryce-Maher
An article on adding a MySql connector into Enterprise Library for .NET Framework 2.0
by Ramneekkalra
This article will surely give an idea how to develop a self-controlled, self-connected smart home/building.
by Naren Neelamegam
A complete walk through on IoT Device programming, Web Service programming and IoT Client programming.
by Ștefan-Mihai MOGA
Did you spot any bugs today? Than this tool might save some of your time
by Jeff Griffith
In this article, you create simple polls similar to those that appear on Facebook pages. The application provides an election title, start and end dates for the voting period, a set of voting options, and a report that contains the results.
by Pierre Kellerman
Explaining different ways to join tables
by dale.newman
Importing Excel & Delimited Files into a Junk Database
by mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
by mbarbac
The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.
by icemanind
Automatically generate Business and Data layers in C# or VB.Net from a SQL Server, Microsoft Access, MySql or SQLite database design.
by Richard Lin
An article on a lean (2 header files) C++ template class that provides mySQL query
by Jon Rooney
Lightening Fast Troubleshooting for Your Cloud Applications
by gggustafson
Autocomplete, or word completion, is a feature in which an application predicts the rest of a word a user is typing. This article describes a lightweight implementation.
by kburman6
This article discusses the making of a search engine.
by AdventureDriver
The code implements a system to create articles using MS-Word for use in the Mambo CMS. The majority of the code is a C# project that reads and parses HTML text created using MS Word. The support projects are a VBA macro for creating the needed HTML and an export/import system for getting localhost
by adriancs
A quick walkthrough of manually installing MySQL on Windows without use of MySQL installer.
by Rakotomalala Andriniaina
This article provides two files that contain a Membership Provider and a Role Provider for ASP.NET v2.0.
by DiponRoy
How to use MERGE statements in different databases
by ebrahim amini sharifi
Sending and receiving message, user authentication, user permission, priority message
by Victor M. Valenzuela
MFC classes to fill ComoBoxes & ListBoxes with MySQL data.
by Member 7656529
A review of the book Microsoft Visual Studio LightSwitch Business Application Development.
by Phani Krishna Kollapur Gandla
Migration of Relational Data structure to Cassandra (No SQL) Data structure
by Olivier_Giulieri
A look at the minimal metadata needed (database mapping and user interface) for generic CRUD applications using the example of a to do list.
by Dave Clemmer
Mo+ is the first technology that fully supports model oriented development, allowing software developers to powerfully scale the work they already do.
by Kuldip Rindani
Monitoring group of Linked SQL Servers from a SQL Server
by Miguel Diaz Kusztrich
A database tool for search text in procedures, views and tables using regular expressions
by Emmanuel Kartmann
This MySQL extension library provides an aggregate function that concatenate strings (for use with SELECT...GROUP BY clause).
by defwebserver
A simple example using MySQL 5 and stored procedures with ObjectDataSources and Generics, in ASP.NET 2.0.
by Renz Ladroma
A tutorial on how to setup Keepalived for MySQL Auto Failover
by Goncalo Oliveira
A set of C++ classes for working with the MySQL library.
by Benjamin Mayrargue
Adds support for MySQL databases in the Data Access Application Block.
by Amgad Fahmi
This an easy way to interact with your mysql database.
by Igor Krupitsky
Tool that will let you import data from SQL Server and Access to MySQL
by Wayne Gaylard
A class to generate a complete backup of a MySQL database.
by onrac
A Membership, Role, Sitemap, and Personalization provider using MySQL.
by Rajib Bahar
An article on HOW-TO grab MySQL schema in C#. This program utilizes ODBC API.
by Syed M Hussain
A MySql utility tool that can export database tables and generate ORM entities
by DarkLizener
Tutorial on writing your own MySQL User Defines Functions
by BarrySolomon
Support for Reading XML in MySQL
by aa2max
A complete website content management system using ASP and MySQL
by adriancs
A tool to export and import MySQL database in .NET
by adriancs
Transform MySQL Rows into C# Class Objects. Perform INSERT/UPDATE by Passing Class or Dictionary
by adriancs
Accelerate the Development with MySQL in C#
by Winfried Wille
MySQL-Fullltext: Start for a simple search-engine using MySQL C-API, WCF, and jQuery
by robert k lewis
An IDS scenario using SNORT, Mysql, MyODBC and MYSQLIDS
by Ian Semmel
A program which generates Typed DataSets and TableAdapters for MySQL databases
by Johan Lundqvist
A short article with an example of how you can use NHibernate and MyQL together.
by Erwin@Attentia
Getting limited recordsets from various databases.
by Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
by Vaclav Naydenov
Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.
by Gazmend Jakupi
Tutorial for developing in PHP
by Vaclav Naydenov
How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.
by QxOrm
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
by Rednet Software
Rednet.DataAccess is yet another component to work with data that simplifies your use.
by Steve MunLeeuw
Embedding the content of a PDF document is not supported, but we can add this feature with a SQL CLR function to parse the PDF into a list of images.
by Akshit Rana
In this article, I will explain how to implement Respository pattern and how to enable dependency injection feature to your MVC Application.
by JUST_Neeraj
A simple Workflow\ETL system in .NET Core which uses REST services to interact with the outside world
by DiponRoy
Select data as DataTable object for a database using Entity Framework
by Michael Chourdakis
Portable nginx+php+mysql inside Windows
by j1webb
This code will let you save .WAV files to either a MSSQL, MSDE or MySql database and then retrieve them
by codef00
Combining methods to better search for words that sound like other words when searching a MySQL database.
by Abani Kumar Meher
This article describes how we write code while developing web application which results in SQL injection vulnerability and how we should write code to prevent it.
by Jeroen De Dauw
A MediaWiki extension that allows you to insert, edit, view and aggregate coordinate data
by Hamdy Ghanem
Set and get data via PHP Web Service between Android and PHP
by Han Bo Sun
This tutorial will discuss an advanced configuration to use MySQL database as the session management.
by Albin Abel
Simple Pattern Matching Technique for Search Suggest Boxes
by namrata khandeparkar
MYSQL: Rather than reading a CSV file and inserting rows (tedious), speeded process just in one query
by Ogwara Rowland
NW.ORM, a helper framework for working Hibernate.
by Ghaffar Khan
Site statistics with PHP and MySQL
by Anele 'Mashy' Mbanga
A look at a flexible Java MySQL CRUD PHP script generator
by Ahmet Göktaş
T-SQL string maker for backup with a MEDIAPASSWORD database.
by Sergei Y.Kitáev
Introduction to statically parameterized SQL language
by Fahad Azeem
This article describes on how to set up a MySQL database to store images with ASP.NET and display it back to the browser.
by Dane Balia
Creating a DAL DLL using Subsonic and MySQL.
by J Snyman
An Article on Implementing MySQL Providers for ASP.NET 2.0 Membership, Roles, Site Map and Personalization
by ro-php-code
A plugin to upload an image using SWF upload and to crop the uploaded image using jQuery and then save the crop result.
by Sams Publishing
Learn to implement and configure a functional database-driven website using the Django framework and MySQL.
by Santhoshpettacode
Make to Cook any one with health care service to the user
by Cláudio de Vasconcelos
Implement a simple class to store multiple queries and run against a MySQL database.
by Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
by Vijay-Srivastava
Fetching complex data from multiple table using nested MySQL queries, JOIN operations, LIKE operator and aggregate functions(eg. GROUP BY, GROUP_CONCAT, etc.)
by Igor Sokolsky
The SqlBuilder class automates and simplifies database operations.
by $uresh $hanmugam
How to upload images into a MySQL BLOB field using the ODBC driver.
by Pragmateek
Using an Access, MySQL, PostgreSQL or SQLite Database from VBA
by DiponRoy
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
by Siddharth R Barman
Interact with MySQL database using EF Core in DotNet Core 1.0.
by Bert O Neill
In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.
by Han Bo Sun
In this tutorial, I will introduce the use of Spring JdbcTemplate in a Spring Boot web application. This tutorial will show how to create the necessary configuration for JdbcTemplate. And how it can be used for data insertion and retrieval.
by Kurt Friedrich
I wanted to use MySQL as the database to hold code first models with ASP MVC.
by Custec
An article on connecting to and using MySQL from Mono.
by adriancs
Settings and Configurations of MySQL Connector/Net ASP.NET Session State Provider
by Andy_L_J
Generate unique column values using UDFs and Stored Procedures
by jopascual
Connecting from VB.NET to a MySQL database.
by weilidai2001
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
by Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
by C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
by Peter Leow
Learn to setup a development environment on a PC to support the development and testing of PHP and MySQL projects.
by ken.tachyon
An article on how to get parameters into and out of MySql stored procedures.
by adminmyserver
Ruby on Rails application for the world's fastest server data.
by cruppstahl
Describes how to write a MySQL storage engine - a plugin which is responsible for persisting MySQL table data.
by GerVenson
ADO.NET ORM