Hello,
I wanted only to report that I removed and re-added the Index as Martijn
suggested and now it's OK.
Thanks again for your help
Regards,
Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello!
I'm using MySQL 5.0.18-standard Server on a Linux SuSE 10 Server and I've
got following problem:
I have a table with the followign structure
+-+--+--+-+---+-
---+
| Field | Type | Null | Key |
during the
week) and tell you the results.
Shall also perform a REPAIR TABLE?
Regards,
Patrick
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 04 April 2006 10:34
To: Patrick Herber; mysql@lists.mysql.com
Subject: Re: MySQL 5.0.18-standard - Wrong
I would suggest a union
SELECT name, count(*)
FROM (SELECT name1 as name from mytable union select name2 as name from
mytable union select name3 as name from table)
GROUP BY name
but perhaps there's a better way...
Regards,
Patrick
-Original Message-
From: Critters [mailto:[EMAIL
Hi,
Do you mean you have such a structure
Table A
ID_a
ID_b
ID_c
...
Table B
ID_b
Value_b
...
Table C
ID_c
Value_c
...
?
In that case you can
SELECT Value_b, Value_c
FROM A
LEFT JOIN B on A.ID_b=B.ID_b
LEFT JOIN C on A.ID_c=C.ID_c
WHERE ID_a=xxx
Regards,
Patrick
-Original
Do you mean something like that?
UPDATE tablename SET date2=DATE_ADD(date1, INTERVAL -3 MONTH)
Regards,
Patrick
-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED]
Sent: Monday, 16 January 2006 15:27
To: mysql@lists.mysql.com
Subject: UPDATE Date Column
Hi,
I have a 2
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since I have some performance troubles with table-locking in a multi-user
environment (when one of them performs a complex query all the other have to
wait up to 1 minute, which is not very nice...), I would like to
innodb_data_file_path?
Thanks a lot and regards,
Patrick
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
Sent: Sunday, 15 January 2006 15:09
To: Patrick Herber
Cc: mysql@lists.mysql.com
Subject: Re: ERROR 1114 (HY000): The table is full converting
a big table