In an application I made last week, I needed a random id value that was not registered in the...
Category - MySQL
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...
MySQL Insert Into Inner Join
When adding records in SQL language, you sometimes need to get records from different tables. In...
Installing and Configuring MySQL Community
1- Summary versions of MySQL There is 2 version of MySQL: MySQL Cummunity: The free version. (We...