Re: Problem with CREATE TABLE/DROP TABLE

On Jun 24, 2008, at 2:57 AM, Gwynne Raskind wrote: I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513 ). To summarize, a table which previously existed, and then is dropped by DROP TABLE IF EXISTS, becomes randomly unable to be recreated.

force row to appear at top of results using order by

Hello, I have an order by question... This is the raw data... mysql SELECT events_groups_id, events_groups_name FROM events_groups; +--+-+ | events_groups_id | events_groups_name | +--+-+ |1 | Personal

RE: Queues on MySQL?

-Original Message- From: Waynn Lue [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2008 8:01 PM To: Jerry Schwartz Cc: MySQL List Subject: Re: Queues on MySQL? Thanks for the suggestion--is that essentially using http://www.php.net/posix_mkfifo within PHP? [JS] Yes, that's what I had in

Re: force row to appear at top of results using order by

Many thanks for the quick replies! This solution appears the most elegant: -- Forwarded message -- From: Markus Grossrieder [EMAIL PROTECTED] Date: 2008/7/1 Subject: Re: force row to appear at top of results using order by To: Andrew Martin [EMAIL PROTECTED] Andrew, something

RE: force row to appear at top of results using order by

SELECT events_groups_id, events_groups_name FROM events_groups ORDER BY IF(events_groups_id=1,0,1),events_groups_name ASC; -Original Message- From: Andrew Martin [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:20 AM To: mysql@lists.mysql.com Subject: force row to appear at top of

RE: force row to appear at top of results using order by

-Original Message- From: Andrew Martin [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 9:20 AM To: mysql@lists.mysql.com Subject: force row to appear at top of results using order by Hello, I have an order by question... This is the raw data... mysql SELECT events_groups_id,

Merge-table Question

Hello, I remember some activity regarding some flakiness when using merge-tables. I searched out and reviewed this: http://bugs.mysql.com/bug.php?id=26881 Using 5.0.51a on RHEL 4 box, I'm still seeing similar issues. The INFORMATION_SCHEMA shows the merge table as follows TABLE_CATALOG:

Running 2 versions of MySQL on same server

Hi: I've been running 3.23 for years, but several users are clamoring for new versions, as many php apps are using newer features, so I downloaded the source for 5.0.51b to run on a different TCP port. I found a reference on a couple of ways to do this here:

Re: Queues on MySQL?

Thanks for the suggestion--is that essentially using http://www.php.net/posix_mkfifo within PHP? [JS] Yes, that's what I had in mind. Be warned, though: I've never used this from PHP; and, although I found no references to this in the PHP documentation, I couldn't find the POSIX functions in a

Re: Running 2 versions of MySQL on same server

Hi James, If I telnet to port 3306, I get the old version as I should and when I telnet to the new port I get the new version as I should, but if I do a: mysqladmin -P (new port) variables I get the old variables. I'd suspect mysqladmin's using the unix socket, and ignoring your -P

ONLY IN

Possible duplicate, sorry if so. Schema below. I am trying to select from a many-to-many relationship all edition_ids that have records for, and only for, certain run_id values. I have no idea how to do this outside of a subquery, which I'd rather avoid. Any thoughts? Here's what I have

Re: Running 2 versions of MySQL on same server

On Tue, 1 Jul 2008, Kevin F. O'Riordan wrote: Hi James, If I telnet to port 3306, I get the old version as I should and when I telnet to the new port I get the new version as I should, but if I do a: mysqladmin -P (new port) variables I get the old variables. I'd suspect mysqladmin's

Re: Running 2 versions of MySQL on same server

On Tue, 1 Jul 2008, [EMAIL PROTECTED] wrote: I would think this would be a relatively simple thing to do. I guess I'm going to try to build MySQL with the config options instead of invoking at runtime...both versions seem hopelessly confused. Well, I rebuilt and installed 5.0 again using