Page 1 of 3 123 Last
  • Jump to page:
    #1
  1. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Great stuff!


    I think melonfire has got it all together! These tutorials they have been doing the past few months are great. They're easy to follow, lots of great examples, and they help out newbies alot!

    thanks guys

    tim
  2. #2
  3. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi,
    I found this tutorial very satisfactory.
    Thank you.
    Soni
  4. #3
  5. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    ok


    hi,
    quite a nice job! i found it very useful for beginners especially.
    but the author could have included explanation of the different JOINS because i still can't understand them clearly.
    i hope they will be in in the next tutorial.
    thanx Melonfire.
  6. #4
  7. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Thanks


    Just wanted to thank the author.
    <br>
    Easy to read and learn, and I find
    <br>
    the benefits worth the while
    <br>
    <br>
    Keep it coming
    <br>
    <br>
    Kind Regards
  8. #5
  9. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Excelent !


    Excelent article dude !
  10. #6
  11. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    More Join Options?


    I'm new to using joins, and have a question that expands on this example:
    <br>
    <br>
    SELECT fname, lname, title FROM members, videos, status WHERE
    <br>
    status.member_id = members.member_id AND status.video_id = videos.video_id;
    <br>
    <br>
    The example shows all the records that have related data in each of the three tables.
    <br>
    <br>
    Let's modify the example to say that you wanted a complete inventory listing plus any extra info such as whom it was checked out to if it's checked out.
    <br>
    <br>
    I've played with the sytax and I've found that I have to use the words LEFT JOIN to get it to do what I want. i don't know what LEFT JOIN means, and I don't know how to use two or more in the same query.
    <br>
    <br>
    Here's my exact query (that doesn't work):
    <br>
    <br>
    SELECT*****tbUsers.user,
    <br>
    *****tbUsers.password,
    <br>
    *****tbUsers.account,
    <br>
    *****tbAccounts.level,
    <br>
    *****tbAccounts.term,
    <br>
    *****tbAccounts.paid_through,
    <br>
    *****coupon.uid,
    <br>
    *****tbDirectory.id
    <br>
    FROM*****tbUsers
    <br>
    LEFT JOIN tbAccounts ON (tbUsers.account = tbAccounts.id)
    <br>
    LEFT JOIN tbDirectory ON (tbUsers.account = tbDirectory.account)
    <br>
    LEFT JOIN coupon ON (tbUsers.account = coupon.account)
    <br>
    <br>
    Keep in mind I want to show all records that appear in the table tbUsers with any related information in the tables tbAccounts, tbDirectory and Coupon.
    <br>
    <br>
    If I omit the last two LEFT JOIN statements and some of the field names, the query works. No matter what I try, commas, ANDs ORs I can't get it to work with more than one LEFT JOIN.
    <br>
    <br>
    I tried to duplicate my efforts in MS Access using it's query tool and it produces a query that uses RIGHT JOIN sytax. Unfortuntately, this query doesn't work in MySQL where I need it to.
    <br>
    <br>
    This is by far the best tutorial I've read yet on general query syntax, thanks. If you can help, please let me know.
    <br>
    <br>
    Matt
  12. #7
  13. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    please, please do more on joins


    Hi,

    Please do more on joins as it seems to be so poorly covered on the Net. I found an article that the O'Reilly SQL guy did in the past but that's it.

    I'll just add my voice to saying thanks for this well written article :-)

    Steve
  14. #8
  15. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Bravo!


    Exemplary tutorial.
    Short, to the point and very easy to understand.
    A little bit of humour makes it also enjoyable.
    Free but priceless!

    Again, Bravo!
  16. #9
  17. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    thanks


    Your MySQL articles helped me a ton. Thanks!
  18. #10
  19. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Sub-Selects


    In your example you have a mysql> prompt next to the example sub-select query.

    This is confusing as MySQL does not support sub-selects
  20. #11
  21. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    great article


    I didn't know MySQL was capable of all this. I read the article because I was looking for some info on how to use ORDER BY and found tons of other useful stuff. Two thumbs up!
  22. #12
  23. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Good stuff.


    This tutorial is very complete in SQL queries. A good help for all who know what to do with SQL. They can quickly look into this site.



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

    Re: Sub-Selects


    I need too a example of MySQL with sub-selects... I believe thar MySQL not support its.
    If you have some a example ??
  26. #14
  27. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    Re: Sub-Selects


    MySql Not will yet the next querys:
    Select <records> from <table> where <record> not in< Select ...>
    Select <records> from <table> where <record> in < Select ...>
    Select <records> from <table> where not exist <table>
  28. #15
  29. No Profile Picture
    guest
    Guest
    Devshed Newbie (0 - 499 posts)

    want to see how to deal with AUTO_INCREMENT


    I read the part1 and part2 already. got to say " Great Job ".

    I'm trying to figure out how to deal with AUTO_INCREMENT. where when I delete a record, like Record 4, record 5 will move up and become record 4, and the rest follow. I'm using php4 and mysql now. please help. thanx

    Ben
Page 1 of 3 123 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo