Merge-table Question

2008-07-01 Thread Michael DePhillips
to take my word that they are identical. This was working fine in 4.1.22. I tried repairing all the underlying tables and recreating the merge table. No Luck. Any ideas ? Thanks, Michael -- Michael DePhillips www.star.bnl.gov -- MySQL General Mailing List For list archives: http

Re: OT: Sun to buy Mysql

2008-01-16 Thread Michael DePhillips
will help of course ... -- Michael DePhillips www.star.bnl.gov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication not working?

2007-01-30 Thread Michael DePhillips
Should be almost instantaneous. Do a show slave status on the slavealso check the error log. Jesse wrote: I'm playing with setting up replication on two MySQL Servers that I have set up here. I set it up according to the instructions found on the MySQL web site, then I went in on the

User Table - exposed

2006-10-16 Thread Michael DePhillips
. Thanks, Michael -- Michael DePhillips www.star.bnl.gov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query Question

2006-08-14 Thread Michael DePhillips
this doesn't work) I would want to return 1234 1235 1236 or; select ID from T1 where ID = 1237 and ID1237 and ID 1237 LIMIT 3 I would want 1236 1238 I would be surprised if there was no way of doing this.but then again, I'm often surprised Thanks Michael -- Michael DePhillips

Re: Query Question

2006-08-14 Thread Michael DePhillips
DePhillips www.star.bnl.gov -- Michael DePhillips www.star.bnl.gov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Question

2006-08-14 Thread Michael DePhillips
Hi Nigel, A and B...please. Perhaps a UDF could achieve my initial request...any ideas. Thanks, Michael nigel wood wrote: Michael DePhillips wrote: Hi Dan, Thanks for the prompt reply, As I described it yes, you are correct, however, the id may not always be one(1) value away. So