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.

SQL

cloud

MySQL

DBA

null

Select a Default Row in SQL

21 Jul 2019 by DiponRoy

Select a default row for a query that returns no rows

SQL Database Access

18 Mar 2019 by Martin Vorbrodt

SQL database access

How to Transfer a MySQL Database between Two Servers using SCP

4 Dec 2018 by Renz Ladroma

A guide to transfer your MySQL databases between two servers using the SCP method

SQL

Linux

MySQL

Backup All MySQL Databases in C# WinForm with 1 Click

17 Sep 2018 by adriancs

A tool to backup & restore all MySQL databases in one click

MySQL

WinForms

database

Use of Realm Object in Realm Event Handler

23 Jun 2018 by Biswal Tanmaya

Use of Realm object in Realm event handler

MySQL: DATETIME vs TIMESTAMP

16 Nov 2017 by Suvendu Shekhar Giri

Difference between MySQL DATETIME and TIMESTAMP datatypes

SQL

MySQL

DateTime

FileTime to DateTime and Back in MySQL

16 Mar 2017 by Smirnov Pavel

How to convert FileTime to DateTime and back in MySQL

Windows

MySQL

jrPaginator - HTML Table Pagination Plugin with jQuery and PHP

3 Feb 2017 by rohit7209

It is a very simple and effective utility build in jQuery & PHP to implement pagination on HTML table.

A Basic Introduction to Sqoop Import & Export for MySql Table to be Used as Hadoop Distributed File System (HDFS) in Cloudera

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.

A Closer Look at Lookup Tables

20 Oct 2016 by Bryan Kowalchuk

The two most common database lookup table patterns are examined

MySQL Double Instance Creation and Database Transfer in CentOS

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.

Linux

MySQL

Authorization on Self-Hosted SignalR Server with a MySql DB with EntityFramework

19 Nov 2015 by Dennis Baberich

How to get a claimbased cookie authentication between custom frontend and self hosted SignalR server

Programmatically Validate EF6/MySQL MigrationHistory in DB vs Assembly

17 Nov 2015 by DLChambers

Validate MigrationHistory to preempt arcane exceptions when EF accesses DB

MySQL

Improving Pentaho Data Integration Performance on MySQL

14 Nov 2015 by BI Road Warrior

Improving Pentaho Data Integration with MySQL: improving performance.

MySQL

Naive Approach to Recursive MySQL

12 Nov 2015 by Veselin Tenev

Provides simplistic solution to a recursive MySQL table

MySQL

recursion

Known Limitation of MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4

11 Nov 2015 by Masteramuk

Basic rules for using MySQL Cluster (NDB) from MyISAM or InnoDB

UniDAC - database's direct connection

29 Sep 2015 by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

Anonymization of Patients' Data in MySQL

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

SQL

MySQL

Ask Your Database for that Unique ID

2 Sep 2015 by Peter Leow

Get your database to generate unique running IDs for your application

SQL

MySQL

PHP

AJAX vs. Non-AJAX Calls All-in-One Page

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.

How to Use Scheduled Events in MySQL

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.

MySQL

event

ServerZilla: FTP Client for Server

29 Apr 2015 by AjithKp560_

FTP Client for Web server.

Useful SQL Snippets & Own Functions for SQL Server, SQL Server CE, MySQL, SQLite, PostgreSQL

7 Mar 2015 by IAndreev93

Standard functions usage, and my own functions... Allowing you simpler process tables... Date and time... Strings...

Java and MySQL via JDBC: How to Connect DB, Get Data from Table and Display It in JTable

3 Mar 2015 by IAndreev93

Very Simply MySQL Viewer with Swing GUI written in NetBeans IDE using GUI Builder

Aggregate Product function extends SQL

19 Feb 2015 by DrABELL

Technique to extend capability of standard SQL by adding the Aggregate Product Function

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

Generate large data series by using Cartesian Product and small data table

Bidirectional Replication - in MySQL

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.

Handling events in google calendar using google API v3

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.

MySQL can’t specify target table for update in FROM clause

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.

Connect WPF with Wamp Server MySql

5 Aug 2014 by Anis Derbel

The easy way to connect to Mysql using Wamp server on WPF

Install Rails 4 and MySQL Server on Windows 7/8

22 Jul 2014 by Rocky R. Fernandes

Install Rails 4 and MySQL Server on Windows 7/8

Save your Data from LDAP Injection Attack

9 Jul 2014 by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

How to set up application using ASP.NET Identity with MySQL Provider

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.

MariaDB Galera Replication Cluster

10 Jun 2014 by Alain Peralta

A very simple replication cluster with MariaDB

The Workings Of A Simple PHP Scrolling List

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.

MySQL

PHP

MSSQL to MySQL Export

16 Apr 2014 by madagaga

Converting MSSQL database to MySQL

How to Display Web Visitor's Sunrise and Sunset Time by IP Address

10 Apr 2014 by Hexa How

Display visitor's sunrise and sunset time based on their IP address using C#

nKnight - Role Based Access Control(RBAC) Solution for C#.NET

7 Apr 2014 by subhajit bhadury

nKnight - RBAC Solution for C#.NET

Custom Adding/Updating using Entity Framework 5

28 Mar 2014 by Kinyanjui Kamau

Being able to add or update data field by field through Winforms using EF5, .NET 4.5

.NET4.5

.NET

MySQL

MySqlCommand, MySqlParameter and "LIKE" with Percent Symbol

5 Aug 2013 by AlbertoLeon CSharpMan

How to search text with LIKE with MySQLParameter in MySQL .NET / Connector

How to fix Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

2 Aug 2013 by AlbertoLeon CSharpMan

Insert Ignore with select thousands of rows threw timeout expired exception

MySQL

ADO.NET

.NET Reporting Tool Tutorial - 1

28 Apr 2013 by emadns

A basic tutorial for ReportMax tool

.NET Reporting Tool Tutorial - 3

23 Apr 2013 by emadns

Using the Chart control in ReportMax

Encrypt and Decrypt password through SQL query

15 Apr 2013 by atul123321

How to Encrypt And Decrypt a field without writing any frontent code .

Equivalent function of mysql_real_escape_string() in C#

25 Oct 2012 by Member 3783976

Implement function in C# to emulate functionality of mysql_real_escape_string() C API function.

Sort a Column Inside an Already Created Table

7 Sep 2012 by Joan M

This tip will explain how to sort a column inside a table.

SQL

MySQL

DBA

MySQL Database Replication Procedure

4 Sep 2012 by Aadhar Joshi

Database replication procedure is to replicate data from different databases of MySQL.

Entity Framework on MySQL with nHydrate

9 Aug 2012 by Christopher R Davis

Use model driven development with a MySql backend

Using MySQL with Entity Framework

23 Jul 2012 by Ravindra T C

Explains how to use MySQL with the Entity Framework.

How to Connect to MySQL Using C#

17 Jul 2012 by Ravindra T C

How to connect to a MySQL database using the MySQL Connector for .NET.

MySQL

Dev

How to Protect from SQL Injection in PhP based website

20 Jun 2012 by chetan dudhagara

How to Protect from SQL Injection in PhP based website

MySQL DB backup using powershell script

17 Aug 2011 by Milind R Chavan

Create MySQL Database backup using mysqldump

PowerShell

MySQL

Using LIKE "backwards" to find patterns that match an input

5 Jul 2011 by GregStevens

You can use the SQL LIKE operator in unconventional ways to do pattern matching.

SQL

MySQL

Select a column in a comma separated row in SQL

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...

SQL

MySQL

Select a column in a comma separated row in SQL

9 May 2011 by eceramanan

How to select a column from a comma separated row in SQL

SQL

MySQL

Quick Code Language and API Reference Search for Developers

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...