Re: Extending mysql.user.User to 64 chars

2006-06-15 Thread Mark Constable
On Friday 16 June 2006 02:40, Ghaffar wrote: > The same limitation is also in 4.1.x versions. > You have to edit the source of the client library and recompile. I thought so too but fortunately for me we are both wrong... version: 4.1.15-Debian_1ubuntu5-log mysql> SHOW FULL FIELDS FROM `user`;

Extending mysql.user.User to 64 chars

2006-06-15 Thread Mark Constable
Howdy. For years I have manually altered mysql.user.User to 64 chars to accommodate email length user IDs but now, after upgrading to v5.0.21, the "normal" alter table routine I use seems to ruin the table altogether. I can't use mysqlcheck to fix it because the root user can't log in. On a fresh i

Re: confirm subscribe to mysql@lists.mysql.com

2006-06-15 Thread Mark Constable
On Friday 16 June 2006 00:28, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/44916ea4caaa5c4f/markc=renta.net > > This confirmation serves two purpo

group_concat()

2003-09-06 Thread Mark Constable
I finally installed 4.1 alpha so I could test the group_concat function but need some help... could anyone give me a clue how I can order the results of group_concat() according to the lft field ? (just adding it per se wipes out the results) I have tried many many variations and have not hit upon