Archives

The List

« FIND_IN_SET() :: MySQL Function of the Day | Main | MySQL Function of the Day: Week 3 »

MySQL Pop Quiz #18

By Carsten | March 25, 2008

I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!

In mysql>, you already know that hitting return on this:

SELECT 1+1, 2+2;

returns this:

+-----+-----+
| 1+1 | 2+2 |
+-----+-----+
|   2 |   4 |
+-----+-----+

What happens if you instead hit return after the following line?

SELECT 1+1, 2+2\\g

or this one?

SELECT 1+1, 2+2\\G

Show hint

Show answer

Do you have your own favorite MySQL question? Is there something in MySQL that has you scratching your head? Send your ideas for new pop quiz questions to carsten (at) bitbybit (dot) dk. Send it in, even if you don’t know the answer — that only makes it more interesting.
More Pop Quiz entries: WWW or RSS.

Topics: MySQL, Pop Quiz |

One Response to “MySQL Pop Quiz #18”

  1. Guerrero de Terracota » MySQL Pop Quiz #18 Says:
    March 31st, 2008 at 9:11 am

    [...] ???????????? ? ?????????? Carsten Pedersen. ???????? [...]

Comments