derived select can't find table

2007-12-26 Thread wang shuming
Hi, select * , ( select f2 from (select f1,f2 from t2 where t2.id=t1.id limit 1 union all ... order by f1 ) t2 limit 1 ) f2 from t1 Unknown column ' t1.id' in 'where clause' Best regard! Shuming Wang

issue about range optimization

2007-12-26 Thread 232160563
i can not understand sentences as following: For a BTREE index, an interval might be usable for conditions combined with AND, where each condition compares a key part with a constant value using =, <=>, IS NULL, >, <, >=, <=, !=,<>, BETWEEN, or LIKE 'pattern' (where 'pattern' does not start

Archiving log files

2007-12-26 Thread David Lubkin
ral wizardry, is to packrat. Keep each day's general log in a dated file, e.g., archive foo.log to foo.20071226. Hang onto at least a few months' worth, if it turns out to be untenable to keep them forever. This is easy enough to do, but I wonder why it doesn't come up in discussi

quit

2007-12-26 Thread 杨怀刚
quit