NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
# update_type, should be NULL
This query identifies which rows to update. I put them in a temporary table ''new_link_loc''. Note in this example I use Min("public".link.data_entry_date) which was the best option in South Sudan.{{Note| If you export out to Excel and then back in to the database as temporary table then you must define the column ''min'' as yyyy-mm-dd hh:mm:ss in Excel in order to preserve the seconds.}}
<pre>
SELECT