See below
On Wed, Apr 15, 2009 at 1:56 AM, Richard Quadling
wrote:
> 2009/4/14 Alvaro Carrasco :
> > Hi Richard,
> >
> > Sorry about not sending to the list, I found this post while browsing the
> > internet and i'm not subscribed to the php-windows list.
> >
> >> Hi.
> >>
> >> I'm trying to find
> > > (got work to do during business hours) on the differences between
> > > UPDATE and INSERT.
> >
> >INSERT creates a new entry, update changes an existing ones. So you
> >cannot use INSERT to corect your data.
>
> Then it must work on a created field that has not been populated yet?
> It doe
Bill Mudry wrote:
The following SQL query
UPDATE species2 AS s LEFT JOIN sci_genera AS sg ON (sg.genus_name =
LEFT(s.species_name, LOCATE(' ', s.species_name) - 1))
SET s.generalID = sg.generalID;
alters the contents of species2 to become
ID species_name
1 Quercus rubra
2 Dalbergia
2009/4/14 Alvaro Carrasco :
> Hi Richard,
>
> Sorry about not sending to the list, I found this post while browsing the
> internet and i'm not subscribed to the php-windows list.
>
>> Hi.
>>
>> I'm trying to find an ORM tool to allow me to talk to Microsoft SQL
>
>> servers (V7, 2000 and 2005) for
