Posts

Showing posts from April, 2012

How can I open a message box in a Windows batch file?

echo MSGBOX "YOUR MESSAGE" > %temp%\TEMPmessage.vbs call %temp%\TEMPmessage.vbs del %temp%\TEMPmessage.vbs /f /q

List out all windows Environment variables

perl -wle "print qq{$_=$ENV{$_}} for sort keys %ENV"

How to concatenate multiple MySQL rows into one field?

Using MySQL, I can do something like select hobbies from peoples_hobbies where person_id = 5; and get: shopping fishing coding but instead I just want 1 row, 1 col: shopping, fishing, coding Answer: select person_id , group_concat ( hobbies separator ', ' )     from peoples_hobbies group by person_id ;