When I woke up this morning...

2004-03-01 Thread Brian Power
? I'm considering reinstalling mysql. any toughts? please help Brian Power _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list arch

RE: How to construct this SQL statement?

2004-02-15 Thread Brian Power
luck, Brian Power From: "Mr. Justin G. Kozuch" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: "mySQL Help" <[EMAIL PROTECTED]> Subject: How to construct this SQL statement? Date: Sun, 15 Feb 2004 11:56:28 -0500 Hi All, I need with an SQL statemen

RE: GROUP BY question

2004-02-10 Thread Brian Power
ps I think you would need to do this with code. If anyone can suggest a way with SQL I'd be very interested Brian Power From: Bengt Lindholm <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: GROUP BY question Date: Tue, 10 Feb 2004 15:24:06 +0100 I have a table where I need to group

RE: Just simple question...

2004-02-06 Thread Brian Power
Yes , you are correct. There is no GUI with mySQL. You can down load one off the web. look on www.mysql.com. I think they have a free one there. I use SQLyog, but you must pay for that. I would advise the move to mySQL from access. I did it a month ago and have never looked back. There is a bit

RE: Another new list member with questions

2004-02-06 Thread Brian Power
It sounds a bit wierd, if you're searching thru a table getting one rec at a time. Suely you can go "Select * from myTable" to retrieve all recs. it sounds nuts to do it any other to be honest! As for the fields, mySQL treats booleans (yes,no) as Char (1). You should of course change the type

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-23 Thread Brian Power
KEY `H_Age` (`H_Age`), KEY `TrainerID` (`TrainerID`), KEY `H_ID` (`H_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 From: Mark Matthews <[EMAIL PROTECTED]> To: Brian Power <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: anybody used prepa

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-23 Thread Brian Power
stdout, something like "0 0 0 0 0 8 0 0 0 ..." It works when i don't use date fields. Do you think this will be fixed in the next release release ? Maybe I'm doing somthing wrong, who knows. From: Mark Matthews <[EMAIL PROTECTED]> To: Brian Power <[EMAI

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Brian Power
Thanks Mark I'll try that tonight. just curious, what sort of development process do you use ? Agile, XP ? Nightly builds, fortnightly releases. You must run a smooth ship over there. From: Mark Matthews <[EMAIL PROTECTED]> To: Brian Power <[EMAIL PROTECTED]> CC: [EMAIL PROTE

Re: anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Brian Power
r support would they respond to a direct email ? Brian Power. From: Richard Tibbetts <[EMAIL PROTECTED]> To: Brian Power <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: anybody used prepared statements in 4.1 succesfully? Date: Thu, 22 Jan 2004 08:18:45 -0500 Since you aren

anybody used prepared statements in 4.1 succesfully?

2004-01-22 Thread Brian Power
anybody used prepared statements in 4.1 succesfully? Has anybody used prepared statements in mySQL 4.1 succesfully. By succesfull I mean quicker ! I have some prepared statement in my app and they take just as long the second++ time as they do hte first. My querys may need to be optimized (i j