Re: subquery SQL help

I could not get the subquery to work, but the sql below did what I wanted:^) SELECT balloon_rec.* FROM `balloon_rec` LEFT JOIN `balloon_txt` USING (`access_no`) WHERE MATCH (`balloon_txt`.`access_no`,`balloon_txt`.`recs_txt`) AGAINST ('meteorology') On Sat, 17 Jul 2004 12:15:20 -0400, "leegold"

Re: connect via VB

can u kindly send me a sample coding for that requirement plz ?   crlys - Original Message - From: Peter Van Eeckhoutte To: Curlys ; MySql Sent: Saturday, July 17, 2004 7:46 PM Subject: Re: connect via VB Use a ODBC connection (I believe you can download

Re: MySQL blocking ACPI suspend

On Sat, Jul 17, 2004 at 11:25:33PM +0200, Loic Minier wrote: > Did other MySQL users experience this? I can confirm this on Debian testing and fedora core 2 -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.D

MySQL blocking ACPI suspend

Hi, It seems that MySQL blocks the attempts made by the kernel to suspend with ACPI. This is what syslog has to say: Jul 16 15:56:41 bee kernel: PM: Preparing system for suspend Jul 16 15:56:49 bee kernel: Stopping tasks: ==

Re: Animals Database Questions

David- generate a composite index on a unique combination such as genus/species Regards Martin - Original Message - From: "David Blomstrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 17, 2004 1:03 PM Subject: Animals Database Questions > I'm working on a big animals

Re: Problem with DATE_ADD - Michael Stassen, July 16 2004 7:48am

Gerard Gilliland replied: Michael: Thank you for your excellent suggestion and quick response. I now have an operable DATE_ADD. The solution to break nPeriod into n and Period would not work directly. That is, in the SELECT statement in the form of ... $qry = "SELECT PlantName, Unit, TagName, C

Re: stress test

super-smack: http://jeremy.zawodny.com/mysql/super-smack/ Or for stress testing the box itself checkout bonnie++ or http://people.redhat.com/dledford/memtest.html which isn't a memtest script but more of a general i/o cpu test. -Eric On Sat, 17 Jul 2004 00:07:12 -0700, Brad Waddell <[EMAIL PRO

Animals Database Questions

I'm working on a big animals database and have a question that's a little hard to explain, though I suspect it will make sense to the pros. First, a little background. I'm tentatively setting up a parent-child relationship and putting all the basic mammal data in a separate table. Below are some s

subquery SQL help

I tried what's below, seemed OK, so I replaced an "IN" for the "=" in the subquery below because of the subquery's error message. I thought w/"IN" I'd get three (3) records returned as expected. But when I tried "IN" I got my entire DB returned - I don't show that below - it kept scrolling so I ab

Re: Displaying Values With Commas.

Someone else might be able to provide a SQL query for formatting with commas, but otherwise just let PHP do all your formatting. PHP's number_format() function is probably your best bet. You might want to look at PHP's money_format() function also, since it might save you some time depending on

Displaying Values With Commas.

Hello everyone, I have a table with a column for real estate property listing values. The column is set up as float(8,2). How do I go about setting up so that the display on the web page includes a comma ? I get $155000.00 but would like to see $155,000.00. You may go here to view the results,

Commas Missing.

Hello everyone, I have a table with a column for real estate property values. The format of the column is float(8,2). When the results are presented on the web page I get $155000.00 versus $155,000.00. How do I go about getting the comma in the values. I am using a MySql table. Thanks in adva

RE: connect via VB

Look at vbmysql.com. You should find some tutorials and primers. -Original Message- From: Curlys To: MySql Sent: 7/17/04 8:05 AM Subject: connect via VB hi , mysql databse server is in Red Hat Linux 8 box. I have an application which is developed from Visual Basic . So that application

connect via VB

hi ,   mysql databse server is in Red Hat Linux 8 box. I have an application which is developed from Visual Basic . So that application included a reqiurement to connect mysql data base.   Can somebody help me how to connect mysql database via VB ?   thanx in advance curlys -- MySQL General

different kind of nested selects

Let's say I have two tables: T1: Name --- apple banana cherry T2: value| name -|-- 1 | apple 2 | banana 3 | banana 4 | cherry 5 | apple 6 | apple I want to get a result that looks like this: name| all_values apple| 1,5, 6 banana| 2,3 cherry| 4 In my head, t

stress test

hi does anyone have a stress test for mysql? i want to give my box a workout before deploying on the web. Maybe a PHP page which runs forever, creating, finding and deleting thousands of records? Maybe I can run it in several browsers at the same time? thanks! brad -- MySQL General Mailing List