Mysql Date Functions

August 25, 2016 admin 0

mysql> SHOW INDEX FROM table_name\GFollowing is a list of all important Date and Time related functions available through SQL. There are various other functions supported [...]

Distinct Keyword in Mysql

August 25, 2016 admin 0

The SQL DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be [...]

MySQL Handling Duplicates Records

August 25, 2016 admin 0

Tables or result sets sometimes contain duplicate records. Sometimes, it is allowed but sometimes it is required to stop duplicate records. Sometimes, it is required [...]

MySQL and SQL Injection

August 25, 2016 admin 0

If you take user input through a webpage and insert it into a MySQL database, there's a chance that you have left yourself wide open [...]

MySQL Database History

August 25, 2016 admin 0

MySQL is an open source SQL database, which is developed by Swedish company MySQL AB. MySQL is pronounced "my ess-que-ell," in contrast with SQL, pronounced [...]

1 2