|
|
Posted by 427SOHC on 06/22/06 07:47
In article <Twgmg.5580$d9.901@trndny04>, Frankly says...
>
>
>
>"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
>
>
Any recommendations for a good SQL reference book? Trying to find something a
little generic that isn't necessarily for MySQL.
--
Unlimited Newsgroup Download Day
Newsguy Bandwidth Blowout 6-29-06
More Info - http://www.newsguy.com/nolimits.htm
Navigation:
[Reply to this message]
|