因公司业务发展迅速，部门现在招两个mysql dba 同学，目前本人在平安健康互联网（平安好医生）数据团队，负责数据库的整体规划，想来的同学可以发简历到我的邮箱 ylouis83@gmail.com 靠谱的公司靠谱的团队 ：）

关于公司：

国内最大的互联网医疗平台，提供全品类互联网医疗服务，目前国内前三大的a轮估值

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) …