myisampack, CHECK TABLE & REPAIR TABLE

2002-02-18 Thread Markus Klink
Hello all, I would like to compress some tables which have an archive purpose and thus will not suffer from the restriction of using myisampack, which implies that the tables will be read only after packing. However, we also have a database problem detection program, which will check each table

distinct on varchar fields

2001-05-04 Thread Markus Klink
Hi All, when I use a distinct on varchar fields, does mySQL truncate the value of the string to some set value. This two queries give me a completely different number of rows and I am not sure how to influence the behaviour: select distinct x from y; (many rows result) and select distinct conc