|
|
Posted by Frankly on 06/21/06 18:49
"J.O. Aho" <user@example.net> wrote in message
news:4frmeiF1k59dtU1@individual.net...
> 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.
I hope today to get up to where SQL commands are placed in the sql field of
PHPmyAdmin.
my goal is to use this to in a way bypass the Admin tool and work directly
with mysql.
I feel starting from the begining using mostly mysql will help me down the
road when I need to create these types of queries to import data to my web
site. I feel much better today and understand enough how much info is
really in your posts.
for example your Left Join Query can be changed a bit to work with other
joins I will need to make.
not to mention your other posts. when i first read them i felt like it
might as well be chinese.
with those posts, your explanations and the other readings I am doing I feel
pretty good.
>
> 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.
i think you might find that tool interesting. I also down loaded the MySQL
workbench.
there is also something else for queries. I am going to try and by pass
these admin tools to get
a better understanding of MySQL but do plan on learning them later on. that
is just my newbie way of thinking. perhaps they are only meant as eye candy
to attract MS users like myself.
however i do hope you download it cause i would love to know your opinion
about it.
>
> 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.
as i am replying to this my other monitor is at
http://dev.mysql.com/doc/refman/4.1/en/join.html
and it might just be that I am in a more relaxed state of mind but the
As of MySQL 3.23.12,
From MySQL 4.0.9
doesnt seem to confuse me as much. if i just ignore the "As of" and the
"From" it is right on target.
i just have to also ignore when they mention things As of 'a version newer
than mine'
like you said... sometimes you just got to walk away for a bit to have it
come together.
>
> 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.
Tell you the truth even spammers dont like me :). I hardly ever check my
personal emails and when i do maybe i get about 8 spams.
>
> 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
i feel much better already. when you explained to me that 'join statement'
it was like having a world of information and not knowing what to do with
it. Ok i still dont know if i have to be at a certain table when i enter
the mysql query field or if there are other steps, but after i see it done
in my tutorial it will be much clearer. to tell you the truth i think im
just going to go through this tread from the begining and read again what
you and strawberry had to say. in the tutorial i am about where I was when
i became side tracked by looking into MS and Macromedia.
Frank
Navigation:
[Reply to this message]
|