Posted by J.O. Aho on 06/21/06 01:41

Frankly wrote:
> I guess its time to go back to the PHPmyAdmin tutorial. I do see it says
> something about Multi table query generation to create automatic joins lol.
> ok ok so i dont know what it means yet but i will.
> i am going to start this tutorial over from the begining. I'll Be Back!!!

SELECT is a Sql command to fetch something from a table, WHERE is used to tell
the fetch what you want to fetch, usually with some kind of "if-statement", as
'WHERE columnA=1' tells us that we want everything that in the columnA has
the value 1. When you want data from two or more tables at the same time, you
use JOIN (multi table query), in the JOIN statement you tell which columns in
the tables are the same value, so that the database can put together a
temporary table with all the data you need.

As it's 3 in the morning over here, I'm not in the mood to run the
mysql-administrator as this requires me to open the server running on another
computer for external connections, so I can't at this moment say where you can
use the SQL queries.

When it comes to the online manual, the links I have given you, all those are
the same as for other versions (3.x and 4.x), myself I use Mysql 5 on my
server, so I do make searches against the 5.0 online manual. On the top left
side of the page you have "Find this page for version", just click on the
version number that matches best the version you are using and you get the
page that always will be right for you.

Yes, the example.net e-mail address is a fake one, as no one owns that domain
and is always used for examples, no one will get the spams that spammers
sends. I mail you an e-mail, so you will get mine, don't worry.

Don't worry about things to much, there will always be moments that will feel
difficult, but you will get passed those and you may even wonder afterwards
why you did think things so difficult.


//Aho

[Back to original message]