MySQL Client Format Output to Space-Delimited


To save output:

To format output to space delimited:

I found CentOS 7 and Ubuntu 16.04 uses different column commands,
in CentOS 7, column is from util-linux, in Ubuntu 16.04 and OSX, BSD like.

I tried to format output as TSV, but failed.

MySQL Client Format Output to Space-Delimited by @sskaje:

Google’s Distract the Guards

Distract the Guards

The time for the mass escape has come, and you need to distract the guards so that the bunny prisoners can make it out! Unfortunately for you, they’re watching the bunnies closely. Fortunately, this means they haven’t realized yet that the space station is about to explode due to the destruction of the LAMBCHOP doomsday device. Also fortunately, all that time you spent working as first a minion and then a henchman means that you know the guards are fond of bananas. And gambling. And thumb wrestling.

The guards, being bored, readily accept your suggestion to play the Banana Games.

You will set up simultaneous thumb wrestling matches. In each match, two guards will pair off to thumb wrestle. The guard with fewer bananas will bet all their bananas, and the other guard will match the bet. The winner will receive all of the bet bananas. You don’t pair off guards with the same number of bananas (you will see why, shortly). You know enough guard psychology to know that the one who has more bananas always gets over-confident and loses. Once a match begins, the pair of guards will continue to thumb wrestle and exchange bananas, until both of them have the same number of bananas. Once that happens, both of them will lose interest and go back to guarding the prisoners, and you don’t want THAT to happen!

For example, if the two guards that were paired started with 3 and 5 bananas, after the first round of thumb wrestling they will have 6 and 2 (the one with 3 bananas wins and gets 3 bananas from the loser). After the second round, they will have 4 and 4 (the one with 6 bananas loses 2 bananas). At that point they stop and get back to guarding.

How is all this useful to distract the guards? Notice that if the guards had started with 1 and 4 bananas, then they keep thumb wrestling! 1, 4 -> 2, 3 -> 4, 1 -> 3, 2 -> 1, 4 and so on.

Now your plan is clear. You must pair up the guards in such a way that the maximum number of guards go into an infinite thumb wrestling loop!

Write a function answer(banana_list) which, given a list of positive integers depicting the amount of bananas the each guard starts with, returns the fewest possible number of guards that will be left to watch the prisoners. Element i of the list will be the number of bananas that guard i (counting from 0) starts with.

The number of guards will be at least 1 and not more than 100, and the number of bananas each guard starts with will be a positive integer no more than 1073741823 (i.e. 2^30 -1). Some of them stockpile a LOT of bananas.


To provide a Python solution, edit
To provide a Java solution, edit

Test cases

(int list) banana_list = [1, 1]
(int) 2

(int list) banana_list = [1, 7, 3, 21, 13, 19]
(int) 0

Use verify [file] to test your solution and see how it does. When you are finished editing your code, use submit [file] to submit your answer. If your solution passes the test cases, it will be removed from your home folder.

You are not authorised to read all content in this post.

Please login…

Google’s Distract the Guards by @sskaje:

Incoming search terms:

Google’s Doomsday Fuel

I tried a simple way in my very first solution, only two test cases passed. Then I google’d other ppl’s test cases, and found this.

This challenge is about mathematics, not traditional algorithms. Thanks to this, I learned Markov Chains and Absorbing Markov Chains. Thanks to @patrickJMT for his videos on youtube.

All test cases, someone posted on

You are not authorised to read all content in this post.

Please login…

Google’s Doomsday Fuel by @sskaje:

Incoming search terms: