If you want to check empty or null value with conditional statement like case when and if in table row with Mysql database you like to check empty or null value form table then you have multiple way check that first we check empty value with case when statement then following examplestrongEmp

If you want to check empty or null value with conditional statement like case when and if in table row with Mysql database you like to check empty or null value form table then you have multiple way check that first we check empty value with case when statement then following examplestrongEmp

In a recent post the MySQL product managers asked the community for feedback about proposed new defaults. One of the proposals is to make log-slave-updates on by default.

There are other important options that require some debate. They all look reasonable to me. This one, instead, which implies funnelling the replication events in a slave to its binary log, is questionable.

Let's start for the reason why it is a good idea. The scenario in which it makes sense is when you want a slave to be a master of one or more slaves. This is a common scenario in many cases where you need …

If you are working on php or any php framwork and you want to copy one table into other table by using sql query so you could do it using simple SELECT and INSERT statement just you need to think how you can useIn Following example you can see how to fetch data from post table and how to inse

If you are working on php or any php framwork and you want to copy one table into other table by using sql query so you could do it using simple SELECT and INSERT statement just you need to think how you can useIn Following example you can see how to fetch data from post table and how to inse

if you are use laravel and you want to add text on image or resize crop image then we can do with interventionimage pakackeyou have to just follow few step and you can add text on imagestrongStep 1 strongyou have to add package on your laravel project by using composer like pre

Ready for another post in the EXPLAIN FORMAT=JSON is Cool series! Great! This post will discuss how to see all the information that is contained in optimized queries with

UNION

 using the

union_result

 and

query_specifications

 commands.

When optimizing complicated queries with

UNION

, it is easy to get lost in the regular

EXPLAIN

  output trying to identify which part of the output belongs to each part of the

UNION

.

Let’s consider the following example:

mysql> explain
    ->     select emp_no, last_name, 'low_salary' from employees
    ->     where emp_no in (select emp_no from salaries
    ->         where salary < (select avg(salary) …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.11. See the release notes and changelog for details on this release. Download MariaDB 10.1.11 Release Notes Changelog What is MariaDB 10.1? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.1.11 now available appeared first on MariaDB.org.

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on January 29, 2016. Binaries are available from the downloads area or from our software repositories.

Percona XtraDB Cluster 5.6.28-25.14 is now the current release, based on the following:

• Percona Server 5.6.28-76.1
• Galera Replicator 3.14 …

Whenever you need to get difference between two dates in date in laravel 5 then you can get easily using Carbon Laravel by default provide Carbon class Carbon class throught you can calculate difference between two dates in daysIn Following example you can see we have a two dates first to va