Some time when you are open any link your website then browser display following massageh2 stylemargin0pxpadding0pxNot Foundh2span stylemargin0padding0The requested URL testhtml was not found on this serverspanspan stylemargin0padding0Additionally a 404 Not Fo

Many user use ubuntu OS and many user face one of the common problem several time like corrupt history file in zsh most of time face this problem when reboot your OS so How to fix this problem please follow this command and fix thatpre classlanguagemysqlmv zshhistory zshhistorybad

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.