Click here to Skip to main content
15,868,141 members
Everything / Database Development / MySQL

MySQL

MySQL

Great Reads

by Christoph Buenger
Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).
by vic_ch2000
A nullable datetime column in .NET DataGrid with DateTimePicker.
by Peter Leow
Get your database to generate unique running IDs for your application
by SarmadAsghar
Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5

Latest Articles

by Frédéric -lefred- Descamps
How to install WordPress on Oracle Cloud Infrastructure (OCI) using always free tier
by Ștefan-Mihai MOGA
About the IntelliDisk app that uses many components published on CodeProject
by adriancs
A quick walkthrough of manually installing MySQL on Windows without use of MySQL installer.

All Articles

Sort by Score

MySQL 

2 Sep 2015 by Peter Leow
Get your database to generate unique running IDs for your application
19 Feb 2015 by DrABELL
Technique to extend capability of standard SQL by adding the Aggregate Product Function
18 Mar 2019 by Martin Vorbrodt
SQL database access
28 Jan 2015 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.
6 Jul 2022 by DiponRoy
Quick start example to run DB and clients in docker
13 Dec 2015 by Nazar.Bukhari
This tutorial will demonstrate the creation of second mysql instance and transfer a database from the first instance to the second.
17 Aug 2011 by Milind R Chavan
Create MySQL Database backup using mysqldump
7 Apr 2014 by subhajit bhadury
nKnight - RBAC Solution for C#.NET
9 Jul 2014 by Jason Parms
Lightweight Directory Access Protocol (LDAP) Injection
22 Jul 2014 by Rocky R. Fernandes
Install Rails 4 and MySQL Server on Windows 7/8
2 Jan 2022 by Eng Ahmed Taha
MySQL trigger workaround for statement-level triggers mimicking Oracle's behavior.
19 Feb 2015 by DrABELL
Generate large data series by using Cartesian Product and small data table
5 Jul 2011 by GregStevens
You can use the SQL LIKE operator in unconventional ways to do pattern matching.
25 Oct 2012 by Member 3783976
Implement function in C# to emulate functionality of mysql_real_escape_string() C API function.
5 Aug 2014 by Anis Derbel
The easy way to connect to Mysql using Wamp server on WPF
1 Jul 2015 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.
28 Sep 2015 by Member 11313437
How to easily anonymize (or pseudonymize, depending on the depth of performing) patients' proper data in clear text in MySQL
16 Mar 2017 by Smirnov Pavel
How to convert FileTime to DateTime and back in MySQL
23 Jun 2018 by Biswal Tanmaya
Use of Realm object in Realm event handler
10 May 2011 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...
7 Sep 2012 by Joan M
This tip will explain how to sort a column inside a table.
9 Aug 2012 by Christopher R Davis
Use model driven development with a MySql backend
5 Aug 2013 by AlbertoLeon CSharpMan
How to search text with LIKE with MySQLParameter in MySQL .NET / Connector
16 Apr 2014 by madagaga
Converting MSSQL database to MySQL
29 Apr 2015 by AjithKp560_
FTP Client for Web server.
12 Nov 2015 by Veselin Tenev
Provides simplistic solution to a recursive MySQL table
7 Jan 2017 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.
16 Mar 2021 by Yuri Danilov
An overview of Top 8 new SQL features of MySQL 8
11 Nov 2015 by Masteramuk
Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB
14 Nov 2015 by BI Road Warrior
Improving Pentaho Data Integration with MySQL: improving performance.
11 Apr 2020 by JC Carmo
How to display MySQL database records in alphabetical order on a PyQT5 form regardless of record ID numbers
31 Mar 2023 by Member 4206974
A PHP class that uses PDO for creating a table from JSON Objects
30 Jun 2014 by Kinyanjui Kamau
To set up an ASP.NET application the implements ASP Identity with Entity Framework to use MySql as a database.
27 Jan 2015 by Sujith Karivelil
This article will help you to create, update and delete events/ appointment in google calendar from your web application.
31 Aug 2015 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.
19 Nov 2015 by Dennis Baberich
How to get a claimbased cookie authentication between custom frontend and self hosted SignalR server
27 Oct 2014 by Lopamudra Pradhan
How to fix the error "MySQL can't specify target table for update in FROM clause" while executing an update query.
17 Jul 2012 by Ravindra T C
How to connect to a MySQL database using the MySQL Connector for .NET.
23 Jul 2012 by Ravindra T C
Explains how to use MySQL with the Entity Framework.
10 Apr 2014 by Hexa How
Display visitor's sunrise and sunset time based on their IP address using C#
2 Aug 2013 by AlbertoLeon CSharpMan
Insert Ignore with select thousands of rows threw timeout expired exception
3 Mar 2015 by IAndreev93
Very Simply MySQL Viewer with Swing GUI written in NetBeans IDE using GUI Builder
21 Jul 2019 by DiponRoy
Select a default row for a query that returns no rows
25 Apr 2014 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.
17 Sep 2018 by adriancs
A tool to backup & restore all MySQL databases in one click
20 Oct 2016 by Bryan Kowalchuk
The two most common database lookup table patterns are examined
3 Feb 2017 by rohit7209
It is a very simple and effective utility build in jQuery & PHP to implement pagination on HTML table.
28 Mar 2014 by Kinyanjui Kamau
Being able to add or update data field by field through Winforms using EF5, .NET 4.5
9 May 2011 by eceramanan
How to select a column from a comma separated row in SQL
4 Dec 2018 by Renz Ladroma
A guide to transfer your MySQL databases between two servers using the SCP method
4 Sep 2012 by Aadhar Joshi
Database replication procedure is to replicate data from different databases of MySQL.
9 Mar 2021 by Member 14866662
A walkthrough of building a MySQL Database Connection Tester application in VB.NET
17 Nov 2015 by DLChambers
Validate MigrationHistory to preempt arcane exceptions when EF accesses DB
10 Jun 2014 by Alain Peralta
A very simple replication cluster with MariaDB
9 Apr 2020 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.
16 Nov 2017 by Suvendu Shekhar Giri
Difference between MySQL DATETIME and TIMESTAMP datatypes
20 Jun 2012 by chetan dudhagara
How to Protect from SQL Injection in PhP based website
11 May 2010 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...
15 Apr 2013 by atul123321
How to Encrypt And Decrypt a field without writing any frontent code .
4 Jul 2022 by DiponRoy
How to auto increment column options in databases
7 Mar 2015 by IAndreev93
Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...
29 Sep 2015 by Thiago Gaidzinski
UniDAC allows you to connect your cross-platform application directly with many database's types.
1 Jun 2023 by Micah Ebohon
Having MSQL and ODBC connection string in one configuration file for your application