#31
  1. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Counting Distinct values


    <p><pre><font color=#008000><xmp>
    select count(distinct carmake) from cars;
    </xmp></font></pre><p>
    <!-- Code -->
    <p><pre><font color=#008000><xmp>
    select count(carmake) from cars;
    </xmp></font></pre><p>
    <!-- Code -->
    <p><pre><font color=#008000><xmp>
    select distinct carmake from cars;
    </xmp></font></pre><p>
  2. #32
  3. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    a mistake I think



    Nice tutorial by the way. Easy to follow, but I think there's this slight mistake in page 10 of the tut...Read below.

    mysql> UPDATE members SET email = 'john@somewhere.com', lname = 'Doe The
    First
    WHERE member_id = 2;
    Query OK, 1 row affected (0.05 sec)
    Rows matched: 1 Changed: 1 Warnings: 0
    --------------------------------------------------------------------------------
    And your table will now look something like this:


    --------------------------------------------------------------------------------
    +-----------+-------+---------------+---------+--------------------------+
    | member_id | fname | lname | tel | email |
    +-----------+-------+---------------+---------+--------------------------+
    | 1 | John | Doe The First | 1234567 | john@somewhere.com |
    | 2 | Jane | Doe | 8373728 | jane@site.com |
    | 3 | Steve | Klingon | 7449373 | steve@alien-race.com |
    | 4 | Santa | Claus | 9999999 | santa@the-north-pole.com |
    +-----------+-------+---------------+---------+--------------------------+
    4 rows in set (0.00 sec)
    --------------------------------------------------------------------------------


    i think it's the second record that should have been changed, or am I wrong?
  4. #33
  5. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    add show columns to the document


    It would be a good idea to add the show columns command to the documents!
  6. #34
  7. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Nice work


    Thanks for the nice introduction to mysql. I found some pretty good answer I had bin looking for.

    Lars C Jørgensen
  8. #35
  9. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: YES, but...


    Do you have some good URl to recommend me?
  10. #36
  11. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: YES, but...


    I don't know if these are the best around, or what they have that will help with sql, but these are the places I've used so far...
    icthus.net/cgi-city
    webresource.net
    Hope that helps!
  12. #37
  13. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Nice ;)


    I relly enjoied reading this Article, relaxed written and high information content. Rate A++. Would be nice to read more form this author.
  14. #38
  15. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    MySQL Part 1


    This really helped me get a start. Most othe tutorials seem to start further ahead which made it hard to get going.
    Thanks
  16. #39
  17. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: YES, but...


    i like hotscripts.com
    good tutorial
  18. #40
  19. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Error: missing " ' "


    In one of the examples there is a missing quotation mark. The example for a multiple field update should have used the single quote mark ' at the end of the SET expression.

    Otherwise I thought the tutorial entitled Speaking SQL spent too little time speaking SQL and too much time on configuring MySQL - a fine subject but one covered in previous articles still on your site.
  20. #41
  21. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Good for learning Mysql using mysql monitor under telnet environment


    perhaps the author may wish to include a part on Mysql script.
  22. #42
  23. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Self-join


    i do not understand self join ..

    what is the t1 and t2 and how is the page5 as t1 and page5 as t2 and what is page5 it self can u give me lot from your time...

    thanx
  24. #43
  25. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: Self-join


    sorry i wrong in the place for q
  26. #44
  27. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    You have failed the test.


    The correct answer was 'Berlin'.
  28. #45
  29. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    mysql tutor


    Great!!! I was able to finish my assignment thanks to you

IMN logo majestic logo threadwatch logo seochat tools logo