2013
Lost connection to MySQL server during query
select count(*) as count from menu
where disp_flg = 1 and
keyword like '%001%' and
(ppv_id is null or ppv_id = '') and
(start_date <= '20240615' or start_date = '' or start_date is null) and
(end_date >= '20240615' or end_date = '' or end_date is null );2006
MySQL server has gone away
select count(*) as count from menu
where disp_flg = 1 and
keyword like '%001%' and
(ppv_id is not null and ppv_id <> '') and
(start_date <= '20240615' or start_date = '' or start_date is null) and
(end_date >= '20240615' or end_date = '' or end_date is null );2006
MySQL server has gone away
select * from menu
where
disp_flg = 1 and
keyword like '%001%' and
(ppv_id is null or ppv_id = '') and
(start_date <= '20240615' or start_date = '' or start_date is null) and
(end_date >= '20240615' or end_date = '' or end_date is null )
order by id asc limit 50, 10;