STIBS,
Thursday, October 17, 2002, 12:26:34 AM, you wrote:
S> I have a littlebig problem:
S> I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
S> case a product number) is the same in both tables.
S> OK, I did this:
S> UPDATE table1 SET table1.field1 = table2.fi
>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 5:15 PM
Subject: RE: Problem with UPDATE table ... can u help plz?
When I try that modified for my tables that fit this hypothetical, I get:
CREATE TABLE `sales_table` (
`item_s` varchar(100) default '',
`price_s
on the page shows a kluge
workaround.
Greg
-Original Message-
From: Bruce Lewis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 16, 2002 4:03 PM
To: STIBS; [EMAIL PROTECTED]
Subject: Re: Problem with UPDATE table ... can u help plz?
You need an InnerJoin to perform the operation similar
IL PROTECTED]>
Sent: Wednesday, October 16, 2002 4:26 PM
Subject: Problem with UPDATE table ... can u help plz?
Hi from Dresden, Germany!
I have a littlebig problem:
I want to UPDATE table1.fields with data from table2.fields WHERE the id (in
this
case a product number) is the same in both t
Hi from Dresden, Germany!
I have a littlebig problem:
I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this
case a product number) is the same in both tables.
OK, I did this:
UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,...
WHERE ta
Try this:
select key_col, min(name), max(date_col)
from my_table
group by key_col ;
You could use max(name) instead of min(name) also, although
since the names can be misspelled, I don't see why it would matter
which name is displayed.
s.s.
On Wed, 30 Jan 2002 21:36:04
Further, I'd advise NOT using field names like "date" and "key". Using
eserved words is never a good prcatice.
-Original Message-
From: Rick Emery
Sent: Wednesday, January 30, 2002 2:16 PM
To: 'P.Agenbag'; 'mysql'
Subject: RE: SQL help
Sorry, I meant:
mysql> select name,max(dateq) from mytable group by keyq;
-Original Message-
From: Rick Emery
Sent: Wednesday, January 30, 2002 2:14 PM
To: 'P.Agenbag'; mysql
Subject: RE: SQL help plz
mysql>
ent: Wednesday, January 30, 2002 1:36 PM
To: mysql
Subject: SQL help plz
Hi
I need help with an sql string:
have a table similar to this:
idkeynamedate
1 123name1 date1
2 123name1 date2
3 111name2 date1
4
At 21:36 +0200 1/30/02, P.Agenbag wrote:
>Hi
>I need help with an sql string:
>
>have a table similar to this:
>
>idkeynamedate
>1 123name1 date1
>2 123name1 date2
>3 111name2 date1
>4 111name2
Hi
I need help with an sql string:
have a table similar to this:
idkeynamedate
1 123name1 date1
2 123name1 date2
3 111name2 date1
4 111name2 date2
5 123name1 date3
Now
>hi all together!
>
>i'm turning to your mailinglist as last chance to find s.o. helping
>me with my problem.
>
>the situation is as follows:
>
>i got a table on a mysql-database, queriing it by php4. the table
>consists of all planets of the planetarion.com-system. these
>information consists
Hello.
On Thu, Jun 28, 2001 at 10:48:23PM +0200, [EMAIL PROTECTED] wrote:
[...]
> the user inserts some wished dates (the lowest score, the searched
> planet may have, the highest, the highest number of roids and the
> lowest..) and the number-interval in wich the _galaxy-score_ may be
> included
hi all together!
i'm turning to your mailinglist as last chance to find s.o. helping me with my problem.
the situation is as follows:
i got a table on a mysql-database, queriing it by php4. the table consists of all
planets of the planetarion.com-system. these information consists of each 3
c
novice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 02, 2001 15:29
Subject: help plz.
> hi,
>
> I'm using
>
> mysql Ver 9.16 Distrib 3.21.33b, for
> unknown-freebsd3.0 (i386)
>
> and i'm using 'C' program to interfa
hi,
I'm using
mysql Ver 9.16 Distrib 3.21.33b, for
unknown-freebsd3.0 (i386)
and i'm using 'C' program to interface with mysql
database,
I didn't get any compilation errors, but while
executing i receive the following error :
File '¡$Pè7' not found (Errcode: 1)
Below is my code that gives
16 matches
Mail list logo
