Yves Goergen wrote:
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
Ah I
Hi All
I am trying to run this query:
update minpheno set TMP_ados_version='0' where ident=898;
On below table:
And get error 1136
ERROR 1136 (21S01): Column count doesn't match value count at row 1
How can that be (obviously ident=898 exists)?
I am going nuts
Thanks
Olaf
+--
Hi,
I am trying to use inheritence to save some space and use a common handle
for subtypes until I need to identify WHICH subtypes they are.
Here is the example I have:
Table BASE
Table SUB1
Table SUB2
And I want to form an relationship like:
SUB1 BASE
SUB2 BASE
So I understand that to do
> -Original Message-
> From: Yves Goergen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 05, 2008 6:22 PM
> To: Baron Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Error: You can't specify target table '...' for update in
> FROM clause
>
> On 05.02.2008 23:25 CE(S)T, Baron Schwar
On Feb 6, 2008 6:40 AM, Britske <[EMAIL PROTECTED]> wrote:
> SELECT * FROM prices WHERE prices.productid IN (SELECT id FROM priducts
> ORDER BY id LIMIT 0, 1000)
>
> However, I'm getting an error-message stating that Limit is not allowed in a
> subquery.
> How would you approach this?
SELECT *
FRO
Hi,
On Feb 6, 2008 6:40 AM, Britske <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm doing some clientside aggregation on rows (which represent prices )
> which sit in a huge table. I therefore want to import these rows in chunks,
> but for this aggregation code to operate correctly I need to be sure th
Hi,
I'm doing some clientside aggregation on rows (which represent prices )
which sit in a huge table. I therefore want to import these rows in chunks,
but for this aggregation code to operate correctly I need to be sure that
all prices of a certain product are contained in the same chunk.
To
* Wolfram Schlich <[EMAIL PROTECTED]> [2008-02-05 15:50]:
> Hi,
>
> I have a MySQL 5.0.54 instance with a 5.0.22 datadir from a corrupted
> filesystem, backed up what was readable and am now trying to get it
> back to life. Unfortunately, mysqld segfaults on startup:
> [...]
> What should I do nex
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
--
Yves Goergen "LonelyPix
