Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
update piratees p
join (
select, min(ps.ship_in) as ship_in
from piratees p1
join piratee_login ps on ps.piratee_id =
where ps.ship_in is not null
and ps.ship_in != '0000-00-00 00:00:00'
group by
) as ps
on =
set p.start_date = ps.ship_in
where p.start_date = '0000-00-00'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.