MySQL UPDATE Statement
MySQL UPDATE Statement The UPDATE statement is used to modify the existing records in a table. UPDATE Syntax: UPDATE tablename SET col1 = val1, col2 = value2, …
Read more
mysql query
MySQL where condition
MySQL where condition WHERE Syntax SELECT column1, column2, … FROM table_name WHERE condition; Note: The WHERE clause is not only used in SELECT statement,
Read more mysql – sql query to fetch count of employee
mysql – sql query to fetch count of employee
Read more
mysql get date interval of 30 days
Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way
Read more mysql query get date of 1 month interval
Very often we need to extract last 1 month, 2 months data from mysql DB. Here we will show easy way to
Read more Remove duplicate rows in MySQL
Easiest way to do this is to add a UNIQUE index on the column. When you write the ALTER statement,
Read more How MySQL Optimizes WHERE Clauses
Some of the optimizations performed by MySQL on where clauses as follow: Removal of unnecessary parentheses: ((a AND b) AND
Read more