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
Checks out over an SSH connection if no HTTPS access is available. For my own records:
1svn checkout svn+ssh://your_user@yourdomain.com/usr/local/svn/ReposName/trunk
If you want to ignore (skip) files inside a directory with SVN:
1svn pe svn:ignore smarty/templates_c
This will prompt you for a pattern (*.php) via your editor of choice. So you’ll need the EDITOR environment variable set in your ~bash.rc / .profile etc
1EDITOR=vi; export EDITOR
Update (14/04/09): This only ignores files that are not already version controlled (inside [...]