Some interesting findings from web-dev land…
Group and concatenate MySQL results and in this case make them distinct (unique):
1GROUP_CONCAT(DISTINCT landing_id ORDER BY landing_id SEPARATOR ‘,’) as landing_ids
This produces a series of values separated by comas: 1,2,3,4,5.
Useful component of sub/nested queries.
This will dump an SQL statement into a file:
1mysql -u username -p database_name -e "SQL_STATEMENT" > file.data