Re: Fwd: why must user variable in EXECUTE USING clause ?

2012-03-26 Thread Walter Tross
Harald, keep in mind that a) this mailing list is badly set up: unless you do a "reply all", the reply goes only to the poster (happened to me too) b) Microsoft products have made inline (bottom) answering almost impossible. I, like many others, am forced to used Outlook at the office, and theref

Re: big character constant

2012-03-26 Thread Hal�sz S�ndor
;>>> 2012/03/25 23:26 +0200, Walter Tross I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and U+2718 'HEAVY BALLOT X' (http://www.fileformat.info/info/unicode/char/2714/index.htm and http://www.fileformat.info/info/unicode/char/2718/index.htm). Unicode has several enco

Fwd: why must user variable in EXECUTE USING clause ?

2012-03-26 Thread Cifer Lee
-- Forwarded message -- From: Reindl Harald Date: Mon, Mar 26, 2012 at 9:17 PM Subject: Re: why must user variable in EXECUTE USING clause ? To: Cifer Lee would you PLEASE send to the list instead off-list and put your answer BELOW instead to-posting? is it really so difficult

Re: 1 client is using or hasn't closed the table properly

2012-03-26 Thread Johan De Meersman
- Original Message - > From: "Brent Clark" > > Mar 26 14:43:54 xyz-web02 mysqld: 120326 14:43:54 [ERROR] > /usr/sbin/mysqld: Table './db/comm_opens' is marked as crashed and should be > repaired That needs a 'repair table' command; probably because the snapshot was taken while the tabl

1 client is using or hasn't closed the table properly

2012-03-26 Thread Brent Clark
Hi Guys I got a problem whereby replication (Master - Master) is broken between my two nodes. But whats really interesting is that, when I try and recover, i.e. take a LVM snapshot (mylvmbackup), and uncompress / recover on the slave. On starting mysql, I just see a range of Mar 26 14:43:54

Re: why must user variable in EXECUTE USING clause ?

2012-03-26 Thread Reindl Harald
Am 26.03.2012 14:13, schrieb Cifer Lee: > why can't be local variable which declared in DECLARE clause? what are you speaking about? keep in mind that we can not read your thoughts signature.asc Description: OpenPGP digital signature

Re: Database Workbench 4.2.3, the multi-DBMS IDE now available!

2012-03-26 Thread Martijn Tonies
Hello Daevid, Any plans to add sqlite to your list of supported DBs there? I develop Android and use LAMP as the server backend. Currently I use SQLYog as I have for like 10 years. But I would really like one GUI to work on both the android sqlite and the mysql backend since they usually ti