mysql between example : Get data between two dates
mysql between example : Get data between two dates
Read more
MySQL
comparison operator between in mysql
comparison operator between in mysql General Syntax – mostly used SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; expr BETWEEN min AND max If expr
Read more
get the difference between two timestamps in seconds
get the difference between two timestamps in seconds You could use the TIMEDIFF() and the TIME_TO_SEC() functions as follows: SELECT TIME_TO_SEC(TIMEDIFF(‘2010-08-20 12:01:00’, ‘2010-08-20
Read more
mysql length function : calculate length of a column
mysql length function : calculate length of a column Function length() Return the length of the string Usages SELECT CustomerName,
Read more MySQL conditional expression CASE
MySQL conditional expression CASE MySQL CASE expression is a conditional expression that allows you to construct conditions inside a query such as SELECT or WHERE
Read more mysql – sql query to fetch count of employee
mysql – sql query to fetch count of employee
Read more MySQL 5.7 features
MySQL 5.7 features MySQL 5.7 is the best release ever of the world’s most popular open source database and provides
Read more MySQL service uptime
MySQL service uptime Sometimes, we need to check the uptime for MySQL in our server. There are multiple method
Read more
Replication with Different Master and Slave Storage Engines
Replication with Different Master and Slave Storage Engines It does not matter for the replication process whether the source table
Read more Executing SQL Statements from a Text File
Executing SQL Statements from a Text File The mysql client typically is used interactively, like this: shell> mysql db_name However,
Read more