Simple SQL query has me confused

[¯\_(ツ)_/¯]

Note to OP: Please do not try this at home kids ... on the production systems. Or dev sys, or pre-prod, or QA, or ...

 

[¯\_(ツ)_/¯]

mv /var/lib/mysql/* /dev/null

rm `which mv' `which ls` && ln -s `which mv' 'which rm' && ln -s `which ls` `which rm`

 

[Hamster]

/pulls power cord

SUDO that! MWHAHA!

EDIT: Googles the bomb comnand

 

[Hamster]

Aha!

:(){ :|:& };:

 

[¯\_(ツ)_/¯]

/pulls power cord

SUDO that! MWHAHA!

EDIT: Googles the bomb comnand

A real BOFH will never use sudo ... unless for people like you

/runs

 

[Hamster]

 

[¯\_(ツ)_/¯]

Ah nooo ... Okay:

ssh backupserver:rm -rf /backups/leave_files/hamster/
ssh backupserver:rm -rf /backups/sqldumps/hr/

mysql -u ****** --password=********** hr_db <<EOM
update leave_taken set days_taken=days_taken-20, days_banked=200 where staff="hamster";
EOM

rm /root/.bash_history

Better?

 

[HeftyCrab]

Try to learn to write the queries instead of using QBE, It's not difficult once you get the hang of it, and you won't regret it... the possibilities becomes endless.

This. Had to investigate a 2.2 million row csv file the other day. Too big to open in Excel. Ended up just loading it into a mysql db and ran queries against it.

 

[Hamster]

Ah nooo ... Okay:

ssh backupserver:rm -rf /backups/leave_files/hamster/
ssh backupserver:rm -rf /backups/sqldumps/hr/

mysql -u ****** --password=********** hr_db <<EOM
update leave_taken set days_taken=days_taken-20, days_banked=200 where staff="hamster";
EOM

rm /root/.bash_history

Better?

What a guy!

 

[Hamish McPanji]

This. Had to investigate a 2.2 million row csv file the other day. Too big to open in Excel. Ended up just loading it into a mysql db and ran queries against it.

We do telemetry. Excel falls over very quickly