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 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.
by Bryan Kowalchuk
The two most common database lookup table patterns are examined
by DrABELL
Technique to extend capability of standard SQL by adding the Aggregate Product Function
by Peter Leow
This is a simple web application to illustrate visually the difference between Ajax and non-Ajax calls that take place all in a single web page.
by Member 11313437
How to easily anonymize (or pseudonymize, depending on the depth of performing) patients' proper data in clear text in MySQL
by Peter Leow
Get your database to generate unique running IDs for your application
by Dennis Baberich
How to get a claimbased cookie authentication between custom frontend and self hosted SignalR server
by DiponRoy
How to auto increment column options in databases
by adriancs
A tool to backup & restore all MySQL databases in one click
by Sujith Karivelil
In Master - Slave replication, Changes in master will reflect in Slave. but any changes made in the slave Database will not reflect back in Master, this article will help you to implement Bidirectional Replication.
by Anis Derbel
The easy way to connect to Mysql using Wamp server on WPF
by OldUser101
A walkthrough of building a MySQL Database Connection Tester application in VB.NET
by Member 4206974
A PHP class that uses PDO for creating a table from JSON Objects
by Kinyanjui Kamau
Being able to add or update data field by field through Winforms using EF5, .NET 4.5
by atul123321
How to Encrypt And Decrypt a field without writing any frontent code .
by Christopher R Davis
Use model driven development with a MySql backend
by Member 3783976
Implement function in C# to emulate functionality of mysql_real_escape_string() C API function.
by Smirnov Pavel
How to convert FileTime to DateTime and back in MySQL
by Jesus Carroll
In Data Engineering, supporting Data Science, Data Mining and Reporting tasks, it is useful to get only fields that have data. We don't mind nulls values and we are grateful if this field's structure is dynamic. These ones might be a stat in the set of empty's kingdom.
by Sujith Karivelil
This article will help you to create, update and delete events/ appointment in google calendar from your web application.
by Ravindra T C
How to connect to a MySQL database using the MySQL Connector for .NET.
by Hexa How
Display visitor's sunrise and sunset time based on their IP address using C#
by AlbertoLeon CSharpMan
Insert Ignore with select thousands of rows threw timeout expired exception
by chetan dudhagara
How to Protect from SQL Injection in PhP based website
by Kinyanjui Kamau
To set up an ASP.NET application the implements ASP Identity with Entity Framework to use MySql as a database.
by Renz Ladroma
A guide to transfer your MySQL databases between two servers using the SCP method
by Nuredin Abdella
In this tip, I will discuss how to create, alter, enable, disable and remove MySQL event in order to automate database manipulation tasks.
by BI Road Warrior
Improving Pentaho Data Integration with MySQL: improving performance.
by Rocky R. Fernandes
Install Rails 4 and MySQL Server on Windows 7/8
by IAndreev93
Very Simply MySQL Viewer with Swing GUI written in NetBeans IDE using GUI Builder
by rohit7209
It is a very simple and effective utility build in jQuery & PHP to implement pagination on HTML table.
by Masteramuk
Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB
by Alain Peralta
A very simple replication cluster with MariaDB
by madagaga
Converting MSSQL database to MySQL
by Lopamudra Pradhan
How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query.
by Aadhar Joshi
Database replication procedure is to replicate data from different databases of MySQL.
by Milind R Chavan
Create MySQL Database backup using mysqldump
by Nazar.Bukhari
This tutorial will demonstrate the creation of second mysql instance and transfer a database from the first instance to the second.
by Eng Ahmed Taha
MySQL trigger workaround for statement-level triggers mimicking Oracle's behavior.
by Suvendu Shekhar Giri
Difference between MySQL DATETIME and TIMESTAMP datatypes
by AlbertoLeon CSharpMan
How to search text with LIKE with MySQLParameter in MySQL .NET / Connector
by Veselin Tenev
Provides simplistic solution to a recursive MySQL table
by subhajit bhadury
nKnight - RBAC Solution for C#.NET
by Micah Ebohon
Having MSQL and ODBC connection string in one configuration file for your application
by DLChambers
Validate MigrationHistory to preempt arcane exceptions when EF accesses DB
by Michael Safyan
If you've done a regular search for API reference documentation, most likely you've come across links to very old versions of the API (e.g. links to Java 1.4.2 instead of Java 5 or Java 6), or you've probably come across plenty of links that are completely unrelated to the actual search (getting...
by DiponRoy
Quick start example to run DB and clients in docker
by Jason Parms
Lightweight Directory Access Protocol (LDAP) Injection
by eceramanan
How to select a column from a comma separated row in SQL
by pankajupadhyay29
Nice one but it did not handle null values you can change it as following to handle null valuescreate table #TABLE_1 (COLUMN_1 varchar(5))insert into #TABLE_1select 'A'union allselect 'B'union allselect 'C'union allselect 'D'union allselect 'E'union allselect...
by DiponRoy
Select a default row for a query that returns no rows
by AjithKp560_
FTP Client for Web server.
by Joan M
This tip will explain how to sort a column inside a table.
by Martin Vorbrodt
SQL database access
by doug433
This tip shows how PHP can be used to access a MySQL database to retrieve data for a scroll list. Here, I will discuss one that lists 12 rows at a time on a web page.
by Yuri Danilov
An overview of Top 8 new SQL features of MySQL 8
by JC Carmo
How to display MySQL database records in alphabetical order on a PyQT5 form regardless of record ID numbers
by Thiago Gaidzinski
UniDAC allows you to connect your cross-platform application directly with many database's types.
by Biswal Tanmaya
Use of Realm object in Realm event handler
by DrABELL
Generate large data series by using Cartesian Product and small data table
by IAndreev93
Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...
by GregStevens
You can use the SQL LIKE operator in unconventional ways to do pattern matching.
by Ravindra T C
Explains how to use MySQL with the Entity Framework.