You can use Microsoft Excel to access data from a MySQL database using ODBC connector. With ODBC...
Category - MySQL
What are the different types of SQL joins explained with examples?
When working with databases, SQL joins (Structured Query Language table joins) are used to...
Composite indexes – When should you use them in MySQL?
What are composite indexes? Database engines (e.g. MySQL, PostgreSQL, etc.) can create composite...
Using Random Numbers in MySQL
Although you might not expect it, random numbers are used in databases quite often, especially when...
MySQL generate random number not IN table
In an application I made last week, I needed a random id value that was not registered in the...
MySQL Create Database Query
In MySQL, we create a database using the CREATE DATABASE statement. MySQL implements a database as...
How to get current date & time in MySQL
MySQL NOW() Function In SQL NOW() function is used to return the system date and time. This...
SQL INSERT INTO – Data Insertion in database
The SQL INSERT command is used to insert data into a table in a database (such as a MySQL or...
SQL SELECT – Selection from a database table
The SQL SELECT statement is used to select or retrieve data from a database. SQL SELECT will allow...
MySQL Get Records Greater than Current Date
Often it is useful (eg for statistics) to query all records of the current day. This is very easy...
MySQL SELECT Random Record from Table
To query records randomly, you can pass the RAND() function to the ORDER BY clause. So that we now...
Select Random Rows in MySQL
Select Random Records in MySQL Sorting records in SQL is not a problem thanks to the ORDER BY...
How to Pass Parameter to MySQL in C#
To connect to MySQL database you can use the System.Data.Odbc namespace in .net using...