Re: mySQL GUIs

I like PremiumSoft's MySQL Studio (now called Navicat, I believe). Very clean, easy to use interface. You can get a trial here: http://www.mysqlstudio.com/ --Scott Brown At 01:16 PM 6/11/2003 +0200, Rodolphe Toots wrote: hi! i am looking for a good mySQL gui for windows i have used

Re: Currency

I am guessing that you are trying to find a MySQL data type of "Currency", which does not exist. I generally use a column that is DECIMAL(150,2) for US currency. --Scott At 01:32 PM 10/2/2003, Fabio Bernardo wrote: I´m having some problems with currency´s fields. Actually I dont know what mys

MySQL max_connections on Windows

00-1000 is good for Solaris/Linux systems, but that is all I can find. Anyone have a good place to start for Windows, with the hardware mentioned? TIA, --Scott Brown -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.1 and TIMESTAMP Column Types

languages. Is this a known issue? Anybody got any pointers to info on this? Thanks, --Scott Brown -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1 and TIMESTAMP Column Types

them are fine, and appear to have been properly stamped. So, my guess is, the error, or whatever it is that is happening, is occurring upon retrieval? Is this actually an ODBC driver issue? I am using the latest MyODBC, beta, I believe, 3.51.06.00 for Windows... Thanks! --Scott Brown -- MySQL

Need help on WHERE ... LIKE Query

with A, B, or C). Anybody got a how-to? I'm sure there must be some way, other than to do this three times. Some of these can vary; that is, it may be 0-9, or 0-Z (show all), even, so I don't want to do a bunch of OR'ing, either. Thanks! --Scott Brown -- MySQL General Mailin

Re: Need help on WHERE ... LIKE Query

Thanks for all of the responses! Actually, Brent Baisley wins the syntax question of the day. The BETWEEN syntax is what I needed. REGEXP and RLIKE do not return any records, they return a count of the number of rows matching the expression. Thanks! --Scott Brown At 11:22 AM 10/30/2003, you

Re: Need help on WHERE ... LIKE Query

econd is not, which is why it is D and not C. On Thursday, October 30, 2003, at 02:22 PM, Scott Brown wrote: I want to do a string comparison like this: SELECT * FROM sometable WHERE surname LIKE '[A-C]%' ORDER BY surname; -- Brent Baisley Systems Architect Landover Associates, Inc.

Re: Need help on WHERE ... LIKE Query

Oh, well, chalk it up to experience. RLIKE is what works the way I want. DOH! Thanks, --Scott Brown At 12:34 PM 10/30/2003, you wrote: Thanks so much Brent, this is what I was looking for. However, what do I do when I get to 'Z'? I looked here, and now I am really confu

Query syntax help?

er thelabel it happens to grab, based on however it is indexing, which would be the first saveorder it stumbles upon. Any help would be appreciated! TIA, --Scott Brown - Before posting, please check: http://www.mysql.com/ma

Random 32bit number for columns?

manage this column... Thanks! --Scott Brown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

Building php4.0.4pl1 with mysql 3.23.32

I've got a real weird problem happening after building 4.0.4pl1 and mysql 3.23.32 on my test machine. I previously had 4.0.1 up and running with an earlier version of mysql - I think it was 3.22.xx - and this combination worked fine. I *seem* to successfully connect to my mysql database... it's

Is updating a subsection of a field possible?

I've got a table with 500+ records in it now... and I need to update just a small section of one of the fields (an URL) to change a parameter on it... I know I'm probably going to be told "NO", but I thought I'd ask before I go start writing a program to do this Is it possible to upd

MySQL table locking?

that should matter? Am I missing something here? I am using iHTML for this particular eCommerce app, BTW. If anyone is familiar with this and knows if the issue is in iHTML, let me know that as well. TIA, --Scott Brown - Be

Storing queries

there a better, more efficient way? Any help greatly appreciated! TIA, --Scott Brown -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]