Re: sql where exists

2002-03-28 Thread Alex Kitainik
ual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Alex Kita

Re: List users?

2002-03-20 Thread Alex Kitainik
select distinct User from mysql.user where User <> '' Mike Yrabedra wrote: > How would I list all users via the command line? > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l

Re: Couldn╢t Performe the edit because another user changer

2002-03-14 Thread Alex Kitainik
The record you want to update is locked by another client. Check return value of your update() What you have to do is approx. the following: while( record_locked) { sleep(...) if( update(...) == OK ) break; } Roberto Freitas Alexandre wrote: > MySQL > > Hi all, > > I am rece

Multiple charsets

2002-03-13 Thread Alex Kitainik
I'm very much interested to know how do you manage multiple language support with mySQL. I haven't found how i can define different character sets for different tables or even for separate databases. Do i have to run several mySQL servers, one per each charset? Maybe, it is the solution for yo