List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:August 27 1999 10:07am
Subject:0 rows affected
View as plain text  
Derek Sivers writes:
 > When I type this command at the mysql prompt...
 > 
 > grant all privileges on *.* to derek@localhost; 
 > 
 > .. is it supposed to say "0 rows affected"?
 > Or does that mean it didn't work?
 > 


Hi!

Mysql monitor reports always number of rows affected. Grant usually
affects several rows, but does not report back, as it is truly not
important. Actually, it is a 'higher level' command which abstracts
users from such truly unnecessary details.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
what is wrong with this?Denis Voitenko26 Aug
  • Re: what is wrong with this?Patrice Bulat26 Aug
  • RE: what is wrong with this?Brian Andrews26 Aug
RE: what is wrong with this?Darren L Sweeney26 Aug
  • BOOK (MySQL + mSQL) is *not* for dummiesDerek Sivers27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummiesDick Griffin27 Aug
      • Re: BOOK (MySQL + mSQL) is *not* for dummiesPaul DuBois27 Aug
        • Re: BOOK (MySQL + mSQL) is *not* for dummieskg27 Aug
          • OT Re: BOOK (MySQL + mSQL) is *not* for dummiesjohn27 Aug
            • Re: OT Re: BOOK (MySQL + mSQL) is *not* for dummiesPaul DuBois27 Aug
          • Re: OT Re: BOOK (MySQL + mSQL) is *not* for dummiesGarrick Staples27 Aug
        • Re: BOOK (MySQL + mSQL) is *not* for dummiesDick Griffin27 Aug
          • Re: BOOK (MySQL + mSQL) is *not* for dummiesDerek Sivers27 Aug
      • damn root - why do you need to pee?Derek Sivers27 Aug
        • Re: damn root - why do you need to pee?Paul DuBois27 Aug
          • Re: damn root - why do you need to pee?Derek Sivers27 Aug
            • Re: damn root - why do you need to pee?Paul DuBois27 Aug
              • 0 rows affectedDerek Sivers27 Aug
                • 0 rows affectedJani Tolonen27 Aug
                • 0 rows affectedsinisa27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummieskg27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummiesWayne Topa27 Aug
  • RE: what is wrong with this?Steve Edberg27 Aug
    • RE: what is wrong with this?Paul DuBois27 Aug
  • Re: BOOK (MySQL + mSQL) is *not* for dummiesChris Shenton27 Aug