Re: How to use an hardcoded list of values

On 9/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > I don't think you're gaining anything by doing this though, unless it is > extremely expensive to do a lookup in item. Thanks Baron, I wanted to be sure I didn't miss a key feature. As the lookup in item is not expensive at all, I will keep

How to use an hardcoded list of values

Hi all, I have a list of values I get from my application and I want to generate a record set based on this list (for an INSERT INTO ... SELECT). Today I have sth like: SELECT 54, item.item_id, mdv.valueInt FROM item i, metadata_value mdv WHERE mdv.item_id = 20202 AND mdv.field_id = 54 AND i.ite

Re: Mysql and disk space left

On 4/19/07, Manuel Vacelet <[EMAIL PROTECTED]> wrote: Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Hi everybody, Nobody can answer my question

Mysql and disk space left

Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Update multiple tables strange behaviour

2007/2/15, Manuel Vacelet <[EMAIL PROTECTED]>: Hi all, I'm facing a strange behaviour with an UPDATE statement. I have a table like: +-+--+ | item_id | rank | +-+--+ |2812 |2 | | 13050 |4 | | 13051 |3 | | 13052 |1 | +-+---

Update multiple tables strange behaviour

Hi all, I'm facing a strange behaviour with an UPDATE statement. I have a table like: +-+--+ | item_id | rank | +-+--+ |2812 |2 | | 13050 |4 | | 13051 |3 | | 13052 |1 | +-+--+ And I want to switch items 2812 and 13052 rank (i.e. assi

How to "cast" a column ?

Hi all, I have query that joins 2 tables. I have an index on each part of the join but unfortunately the 2 columns don't have the same type so the index is not used for the join (I guess it's the reason why). On one hand I have an INT and on the other and a VARCHAR. Is there any way to write the

Re: How do I do this query efficiently?

2006/11/16, Peter Brawley <[EMAIL PROTECTED]>: Michael, >SELECT t1.id, t1.version, t1.value >FROM data t1 >LEFT JOIN data t2 ON t1.id=t2.id AND t1.version < t2.version >WHERE t2.id IS NULL; >I had almost the same problem and I found this solution very smart... >even smarter than I can unde