I've also found the mysql docs to be great at teaching SQL.
select is at http://web.mysql.com/Manual_chapter/manual_Reference.html#SELECT
and the TOC is at http://web.mysql.com/Manual_chapter/manual_toc.htm
[EMAIL PROTECTED] wrote:
> Perry:
> For any database programming it is very important for one to bone
> up on SQL. Having said that there is an easy way to learn. Use MS
> Access Query design and fashion the query you want. Then switch
> to SQL window (click on the arrow next to the set square icon on
> top left). Voila! You will see the SQL.
>
> I almost always test out my SQL by pasting it in MS Access
> window and checking for syntax. Then I paste it back in the
> program and make any ncessary corrections.
>
> Also MS Access help is decent and you can look at examples and
> learn from it...
>
> Ranga Nathan
> Reliance Technology Consultatns Inc.
>
> On 26 May 00, at 8:46, Anthony George wrote:
>
> Date sent: Fri, 26 May 2000 08:46:48 -0400
> From: "Anthony George" <[EMAIL PROTECTED]>
> Organization: EMS Technical Services
> To: "Perl-Win32-Users Mailing List"
><[EMAIL PROTECTED]>
> Subject: Re: Data access
> Send reply to: "Anthony George" <[EMAIL PROTECTED]>
>
> >
> > [EMAIL PROTECTED] wrote:
> > >
> > > I have another situation where I am calling a select subroutine in PERL
> > > based on the table a user selects. This select statement is very basic:
> > >
> > > select * from $tablename
> > >
> > > From here how do I pick only the columns of my choice?
> > >
> > > Perry Chaturvedi
> >
> > You'll probably get better response from Perl-Win32-Database,
> > but, the select statement you have is selecting all fields in $tablename
> > you'll need to be more specific:
> > SELECT (FIELD1,FIELD2,FIELD3) FROM $tablename WHERE FIELD1 LIKE
> > $string ##untested, maybe incorrect on the WHERE
> > This would return FIELD1,FIELD2,FIELD3 from $tablename where FIELD1 is
> > like $string(kind of like FIELD1=~/$string/ of sorts)
> > I found quite a bit of docs searching on google:
> > http://www.google.com/search?q=sql+select&meta=lr%3D%26hl%3Den
> > for SQL server and ODBC/Access
> > >tony
> >
> >
> > ---
> > You are currently subscribed to perl-win32-users as: [EMAIL PROTECTED]
> > To unsubscribe, forward this message to
> > [EMAIL PROTECTED]
> > For non-automated Mailing List support, send email to
> > [EMAIL PROTECTED]
> >
> >
>
> ---
> You are currently subscribed to perl-win32-users as: [EMAIL PROTECTED]
> To unsubscribe, forward this message to
> [EMAIL PROTECTED]
> For non-automated Mailing List support, send email to
> [EMAIL PROTECTED]
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
