RE: Searching for matching zipcode in a list of (ranges of) zipcodes

they are different Then to locate an engineer: Select * from engineer e, engineer_zipcodes z where e.engineer_id = z.engineer_id and min_zipcode = zzz and max_zipcode = zzz zzz is the zipcode you're searching for. Hope this helps, Andy -Original Message- From: Tom Hesp [mailto:[EMAIL PROTECTED] Sent

Re: mysqld without LinuxThreads

to changes in 2.6 talk about how 2.6 has additional clone() options that NPTL takes advantage of (most of them reference a text that is available at http://kerneltrap.org/node/view/422). Also, why are you down on clone() -- I trust you, but I want to learn! :) -- Andy Bakun [EMAIL PROTECTED

Re: mysqld without LinuxThreads

On Fri, 2004-01-09 at 05:14, Chris Nolan wrote: On Fri, 2004-01-09 at 20:58, Andy Bakun wrote: On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux

RE: MySQL as document storage?

decide to go that way. I'd be interested to hear if you genuinely feel it has been a success, especially after you've recovered from your first major data loss :-) (This is not meant to be sarcastic) Best regards, Andy -Original Message- From: Steve Folly [mailto:[EMAIL PROTECTED] Sent

Re: mysqld without LinuxThreads

? -- Andy Bakun [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Very large update

. In databases like Teradata and Redbrick, there are tools that will do the update directly from a file if it is formatted correctly. What is the most efficient way to do it in MySQL? I'm willing to write as complex Perl, C, or whatever is necessary to make this fast. Thanks, Andy -- MySQL General

Re: How to use API to write blobs

rather than sprintf, if your platform supports it, in order to avoid buffer overruns). -- Andy Bakun [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Request help with error 1236

the size of the binary log file! Any help would be greatly appreciated. At this point replication is unreliable enough that it doesn't do us any good. Thanks for your help! - Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Replication slave gets fatal error 1236 on an almost daily basis.

of the binary log file! Any help would be greatly appreciated. At this point replication is unreliable enough that it doesn't do us any good. -- Andy DePue Software Developer Software Services, Inc. (864) 271-8053 x104 -- MySQL General Mailing List For list archives: http://lists.mysql.com

HELP!

hi I bought a book with your mySQL program and seemed to have installed it worng and i cant stop it. I never set a user name or a password. ~AndyR.

RE: Security Question

would not be too significant? Best regards, Andy -Original Message- From: Curley, Thomas [mailto:[EMAIL PROTECTED] Sent: 26 November 2003 13:22 To: [EMAIL PROTECTED] Subject: RE: Security Question Importance: High thanks for reply - the requirement comes from a security audit - so

RE: Index before or after inserts?

Mirza, Definitely, index after insert. Andy -Original Message- From: Mirza [mailto:[EMAIL PROTECTED] Sent: 27 November 2003 15:33 To: [EMAIL PROTECTED] Subject: Index before or after inserts? I need to insert hundreds of milions of records to a table and make several

RE: DB design question

that you're not searching the earliest or latest available table, and if so, modify the union so that you don't try to search a non-existent table. Hope this helps, Andy -Original Message- From: Julian Zottl [mailto:[EMAIL PROTECTED] Sent: 21 November 2003 12:03 To: [EMAIL PROTECTED

RE: SQL query question

] with the primary key of the person table. Andy -Original Message- From: Paal Eriksen [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 12:11 To: [EMAIL PROTECTED] Subject: SQL query question Hi, i have the following query: SELECT person.name as Name, firmal.beskrivelse

RE: Need ur help ..........

-static-1.7.5 /usr/local/mysql read the installation instructions in the INSTALL-BINARY file in /usr/local/mysql Hope this helps, Andy -Original Message- From: Renuka Prasad [mailto:[EMAIL PROTECTED] Sent: 07 November 2003 08:00 To: [EMAIL PROTECTED] Subject: Need ur help

HELP is missing

Hi I'm attempting to use your mysql control center v. 0.9.3 beta. I want to load information into a database from a file, but am having problems. Why don't you have any HELP contents? Thanks, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: MySQL query question

Chris, You're almost there! select * from temp where col2 like concat('%',col1, '%'); Andy -Original Message- From: Chris A. Mattingly [mailto:[EMAIL PROTECTED] Sent: 07 November 2003 17:01 To: [EMAIL PROTECTED] Subject: MySQL query question I've searched around on the lists

RE: DB not restoring from dump file

you might encounter with reserved words being used in column and table names. -- Andy Bakun: when uselessness just isn't enough [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Faster Query Method?

). As it looks like you may be searching like %foo% on text fields. If this is the case, you should consider using full text search on these as it can use indexes and could therefore be quicker. Hope this helps, Andy -Original Message- From: Scott Turnbull [mailto:[EMAIL PROTECTED] Sent: 22

FW: SELECT 9 BETWEEN 1 AND 0

This went direct and not to the list. Andy -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: 21 October 2003 08:19 To: Steven Ducat Subject: RE: SELECT 9 BETWEEN 1 AND 0 Steve, I'd add an extra column with modified code in it, where I subtracted 1 from the number

RE: [mysql] MYSQL

, which is a serious machine for the money, such that it's hardly worth buying anything less for most commercial deployments. Move down the list according to your budget! Hope this helps, Andy -Original Message- From: Bill Kendrick [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 00:25

RE: printing reports

Please take this flame war off list. -Original Message- From: Wang Feng [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:31 To: Michael Haunzwickl; 'Director General: NEFACOMP'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: printing reports Importance: Low So listen guy,

RE: how to export data from multiple tables

Nitin, Create a temporary table, then select each table into it in turn, then output that to the file? Andy -Original Message- From: Nitin [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 11:40 To: [EMAIL PROTECTED] Subject: how to export data from multiple tables Hi all, I've

RE: Newbye speed question - which setup to use for indexing

easily be so (as could your data file). Indexing my db takes under 2 hours on a sloow 400MHz Sun E250. I don't think the index process will use two processors, but I don't think your problem is related to processor speed. Andy -Original Message- From: Peer Reiser [mailto:[EMAIL

RE: GRANT update query: Updating host access entry for users but retaining existing passwords

tried this for real. Also, hopefully someone else will comment on whether this will actually work, or whether their is a fatal flaw in the idea. Best regards, Andy -Original Message- From: Shin [mailto:[EMAIL PROTECTED] Sent: 30 September 2003 11:02 To: [EMAIL PROTECTED] Subject

Re: JDBC : determining the schema name for MySQL

for this table as (i.e no catalog) if catalog maps across to 'database' in MySQL ? TIA -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

JDBC : determining the schema name for MySQL

the second String and it just returns null. Any ideas? TIA -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

CAST with UNION

Hello, I am trying to select records from two tables, all the fields in both tables are varchar's but some of the fields I would like returned as DATETIME types. I have no problem using the CAST(field as DATETIME) function on one table, but as soon as I try to union two selects the CAST no

Re: InnoDB MySQL-4.0.11a using Linux Mandrake RPMs

Andy Jefferson wrote: a simple question ... I have MySQL installed on my Mandrake Linux system, via the RPM's MySQL-4.0.11a-5.1mdk MySQL-common-4.0.11a-5.1mdk MySQL-client-4.0.11a-5.1mdk Can anyone tell me how a) I check if InnoDB is available with this version ? (in the RPM release

Re: Sub-selects

you should find subselects ... not 4.0 -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB MySQL-4.0.11a using Linux Mandrake RPMs

default-table-type=InnoDB Do I need to do anything else ?] The background is that I want to have MySQL check foreign key constraints, and hence prevent deletion from some table if another has a foreign key constraint to that record. Currently it allows deletion with no error. TIA -- Andy

Re: OS X Installation and Setup

on with this. Sorry to be bothering the list again but i followed the directions the best I could and this really shouldn't be this problematic, hopefully if i can get it work I can help clarify the documentation with my experiences. Thanks again -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd

RE: join not using first primay key, per explain

Jeff, Try creating a new index on Question containing just the question_key field, and try it again. Andy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 September 2003 13:23 To: [EMAIL PROTECTED] Subject: join not using first primay key, per explain

RE: Do I use Except?

1.7.4.1 Sub queries in the manual on how to change this into a join supported in mysql prior to 4.1 Andy -Original Message- From: Matt MacLeod [mailto:[EMAIL PROTECTED] Sent: 19 September 2003 16:38 To: [EMAIL PROTECTED] Subject: Do I use Except? Hi, I'm building an online fantasy

RE: Platform vs. Performance

Jeremy, I don't think there's a huge difference in WinTel performance and Linux, given the same hardware. Anyway, your application is so lightweight, it's not really going matter very much. Ease of administration for you and your client will be far more important. Andy -Original Message

RE: Performance Problems

only 3 columns) and a search like the one you've got takes 0.07 seconds on a box similar to your dev box. Andy -Original Message- From: Schonder, Matthias [mailto:[EMAIL PROTECTED] Sent: 18 September 2003 10:25 To: '[EMAIL PROTECTED]' Subject: Performance Problems Hei :) I have

RE: Platform vs. Performance

I don't see anything in there that is relevant to the original posting. Andy -Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs Sent: 18 September 2003 14:04 To: [EMAIL PROTECTED] Subject: Re: Platform vs. Performance In article [EMAIL PROTECTED

RE: Platform vs. Performance

Alec, My point was that in a 40,000 row database, server speed is irrelevant - it's going to be sub second on anything more powerful than my mobile phone. Cost of ownership is much more important for this application, and that depends on the particular circumstances. Andy -Original

RE: Platform vs. Performance

of reality... Andy -Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs Sent: 18 September 2003 17:00 To: [EMAIL PROTECTED] Subject: Re: Platform vs. Performance In article [EMAIL PROTECTED], Andy Eastham [EMAIL PROTECTED] writes: I don't see anything

RE: Blasted #$%$^$^ host has v3.23 when i need UNION

Ryan, As you probably found out, union is only available in version 4 of mysql. As you're using PHP anyway, why don't you just break it up into 5 separate selects and combine the results in PHP? Andy -Original Message- From: Ryan A [mailto:[EMAIL PROTECTED] Sent: 15 September 2003

RE: Blasted #$%$^$^ host has v3.23 when i need UNION

Ryan, If this query worked, it would return you 5 rows, one for each separate count. If you execute 5 separate counts in PHP, you'll get 5 separate values with the same numbers as above. Not radically different? Andy -Original Message- From: Ryan A [mailto:[EMAIL PROTECTED] Sent

RE: Blasted #$%$^$^ host has v3.23 when i need UNION

you've got the right indexes on all of the tables though (ie put an index on each table that matches the where clause against that table). All the best, Andy -Original Message- From: Ryan A [mailto:[EMAIL PROTECTED] Sent: 15 September 2003 13:31 To: [EMAIL PROTECTED]; [EMAIL PROTECTED

RE: random record

39? -Original Message- From: tuncay bas [mailto:[EMAIL PROTECTED] Sent: 15 September 2003 13:32 To: mysql Subject: random record hi, why its mysql database over random record use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Convert with Unions

Hello all, I've tried searching through the lists but haven't been able to find an answer to my problem. If any one can help I would be very grateful, Thanks in advance. Anyway, on to the problem. I have two tables each with field that contains a date in string format 'YYMMDDhhmmss' I want to

Re: OS X Installation and Setup

get msqld ended immediately afterwards, I tried to follow the two posts about that with the online documentation with no luck. If you need anymore info just let me know, thanks a lot for your response. Cheers, Andy -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd

RE: How to generate sql scripts in Mysql?

in batch mode, use mysql -t. To echo to the output the commands that are executed, use mysql -vvv. You can also use scripts in the mysql command-line prompt by using the source command: mysql source filename; Andy -Original Message- From: florence florence [mailto:[EMAIL PROTECTED] Sent: 12

Re: UNION

the queries for correct result. Thanks, thats a workaround and I can move on but certainly is NOT accepted behaviour in RDBMS. Is there a plan for fixing this ? i.e Is there a list of known bugs with MySQL that I can see somewhere so I can report it or monitor it ? -- Andy -- MySQL General

OS X Installation and Setup

thanks in advance. Andy Callan -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OS X Installation and Setup

thanks in advance. Andy Callan -- Andy Callan St. Thomas More College Rm M112 Mounts Bay Rd. Crawley, WA 6009 IM: CALid05 www.nd.edu/~acallan1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UNION

| ++--+---+ Notice that the JPOXMETADATA column is incorrect for PRODUCT_ID=1 and 2. Any ideas anyone ? -- Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with compiling MySQL

is appreciated. Thanks !! Andy Andy Kannberg wrote: Hi all, I'm trying to compile MySQL 4.0.14 on a SUN Enterprise 220R, running on Solaris 9 12/02 with the latest patch clusters installed. I use gcc 3.2.3 to compile, along with gnu make 3.80 I've followed instructions in the MySQL Docs from

Re: Problems with compiling MySQL

People, I've found the solution. It appears that the math_iso.h is a header file provided by SUNWlibm. Installed the package and tried again. It doesn't fail at the same point. At this moment, the make is still running, so far so good. Cheers, Andy OK Daniel, thanks for your tips

More problems during make of mysql

to these kind of errors. Any hints our tips would be really appreciated. cheers, Andy People, I've found the solution. It appears that the math_iso.h is a header file provided by SUNWlibm. Installed the package and tried again. It doesn't fail at the same point. At this moment, the make

RE: Query won't use index

Ken, The problem is that you've got a compound index on files which type_id isn't the first item. If you create a new index on files, just on type_id, all will be fine. Mysql would only be able to use a compound index for this query if type_id was the first column in it. Andy -Original

Problems with compiling MySQL

, I also see messages like this: gcc: unrecognized option '-03' while the documentation says the option '-03' is necesary. Can anybody help me on this ? Cheers, Andy

SubQueries and IN

in MS-SQL) There must be a way to do this, but I dont seem to be able to put my finger on it and I would appreciate any help! Thanks Andy Hall. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SubQueries and IN

Thanks for the query suggestions, but unfortunately none of them seem to do the trick. Not possible to upgrade to 4.x at the moment, so I am going to have to do it in 2 queries; one to get the list of ID's, then create a list in PHP and drop it into the second query. Thanks for the help! Andy

Re: SubQueries and IN

last email - this did do the trick! I was not aware that you could stick multiple clauses for the ON section. It all makes sense now! Thanks again Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Search?

lists of valid options - then your searches will suceed. If this is your first database then you may want to avoid a full-blown search engine. Regards, Andy. Extraordinaire wrote: Hi I builded a little propert database. I added a search function to the site but have the following problem: I

Re: Oracle DBA here looking for advice on MySQL ....

a wealth of datatime functions, this one isn't available unless you convert to 'Unix' dates which expire in 2036) and I've written functions to handle the fact that in 'C' all data is returned as strings rather than as native data types. Sigh. - Andy Johnson, Michael wrote: What is the best book

Re: Better query method?

order by ChildCount desc; Regards, Andy. John Macon wrote: Hi all, Long time reader, first time poster, I hope that I get this right. I am setting up a database that reflects a relationship between two records without using the primary key as the tie between the two. I need to make

Re: Double entries

Trevor, Why not try simplify it to 2 fields and remove most of the validation code? If that works, then you can binary add/delete code until it fails. BTW 'Red' I guess only works on certain mail clients, but not mine, so sorry if I missed something obvious. Regards, Andy. Trevor Morrison wrote

Re: replication problem

On Wed, Aug 06, 2003 at 12:16:40PM -0400, walt wrote: On Wednesday 06 August 2003 11:50 am, Andy Smith wrote: $ cat mysql/master.info angora-bin.001 20102800 127.0.0.1 repl removed 3306 60 Looks fine to me. :( Looks fine to me as well Are you still getting the 1200

Re: replication problem

On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote: So does anyone else have any ideas what is going on here? Shall I report this as a bug? Did you post how you setup the servers to load the different my.cnf files? Hopefully you don't have one at a default location. I don't

Re: replication problem

On Wed, Aug 06, 2003 at 11:23:31AM -0400, walt wrote: On Wednesday 06 August 2003 11:13 am, Andy Smith wrote: On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote: On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote: Andy, I don't see log-slave-updates in your master

Re: how to 'tell' the select what to omit

As Victoria says, you can't. However I agree that this syntax is useless in many real-world situations. You are not the only one who finds this behaviour annoying. It's about time someone made SQL a 21st century language... Miroslav I. wrote: Hallo suppose you have a table with great

Unix date problems

compiled with a larger time_t? Regards, Andy +---+ | from_unixtime(2147483648) | +---+ | 1900-01-00 00:00:00 | +---+ 1 row in set (0.00 sec) mysql select unix_timestamp(); +--+ | unix_timestamp

Re: replication problem

On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote: On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote: Andy, I don't see log-slave-updates in your master setup. I see log-bin, but I think that only applies to updates done directly to the database (not replication updates

Re: Newbie SQL question

or OpponentTeams.id =140) and (HomeTeams.id=Schedules.Team_ID and OppenentTeams.id=Schedules.Opponent_ID) order by Game_Date; The 3 tables are joined in the last line. The previous line limits the results to where the home or opponents are '140'; Excuse any typos. Regards, Andy. Warren, Keith wrote: I'm

Re: Use Like or =

Eli, Use = for exact matches and LIKE for partial matches using a wild card e.g. WHERE column_name LIKE ab% will match 'ab', 'abc' and 'ABC' but not 'acb'. Regards, Andy eli wrote: Hi, I have a question about using LIKE or equal. I mean, comparing two strings with exact coincidence

Re: Unix date problems

- that's the scary bit. - Andy Keith C. Ivey wrote: On 7 Aug 2003 at 15:27, Andy Jackman wrote: 1) I was investigating the unix_timestamp routine in mysql (version 3.23.46-nt) and for some reason the unix epoch (1-1-1970) was returned with a value of -3600. That's what I'd expect

RE: STUMPED: How Can I Pull Related Info Using Subqueries/Joins?

Patrick, You need outer joins to do this. Try searching for outer join sql tutorial on Google. Hope this helps, Andy -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED] Sent: 07 August 2003 16:51 To: [EMAIL PROTECTED] Subject: STUMPED: How Can I Pull Related Info

Re: arbitrary ordering

the question order field in the question table. Best regard, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help debugging this Query?

of stuff that has nothing to do with the problem. Regards, Andy. Aaron Wolski wrote: Hi Guys, I have 2 queries: select * FROM kcs_threadgroups AS t1, kcs_threads AS t2 WHERE t2.manufacturer='DMC' AND t1.thread_index=t2.id ORDER BY t2.type, t1.groupName Using the explain command (explain

Re: replication problem

On Wed, Aug 06, 2003 at 11:39:26AM -0400, walt wrote: On Wednesday 06 August 2003 11:26 am, Andy Smith wrote: Andy, I just noticed that you have a mix of port numbers. Can you try `netstat -an | grep 3306` from the command line and see if the master is indeed listening

Re: arbitrary ordering

the questions in any order for that survey. (You just put arbitary numbers in QUESTION_ORDER to make the order work e.g. 10, 20, 30 - by using multiples of 10 you can insert a question without renumbering the order.) I hope that helps, Andy David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1

FROM_DAYS doesn't take timestamp?

as the date? I don't want to use from_unixtime() as I think the dates screw up in 2038. Thanks, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication problem

So does anyone else have any ideas what is going on here? Shall I report this as a bug? On Wed, Aug 06, 2003 at 02:19:21PM +0100, Andy Smith wrote: Hi folks, trying to set up replication and I'm getting this problem which I can't see how to fix despite reading of the manual and google. I

Re: replication problem

On Thu, Aug 07, 2003 at 07:54:18AM +0100, Andy Smith wrote: On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote: So does anyone else have any ideas what is going on here? Shall I report this as a bug? Did you post how you setup the servers to load the different my.cnf

replication problem

Hi folks, trying to set up replication and I'm getting this problem which I can't see how to fix despite reading of the manual and google. I have set up a master and a slave according to the manual. The master runs 4.0.12 and the slave runs 4.0.14, they are both actually on the same machine

Re: replication problem

On Wed, Aug 06, 2003 at 10:32:23AM -0400, walt wrote: Andy, Can you send a copy of your my.cnf file for both the slave and master database. Sure. Slave: [client] port=3307 socket=/data/mysql-backup/mysql.sock [mysqld] port=3307 socket=/data/mysql-backup/mysql.sock server-id=4 log-warnings

RE: Problems with spatial extensions

Enrique, Your English is great so don't apologise! Looking on the web site at http://www.mysql.com/doc/en/Spatial_extensions_in_MySQL.html , it appears that this feature was introduced in server version 4.1, so I'm afraid you'll have to upgrade your server. Best regards, Andy -Original

RE: Problem reading my.cnf

Ganbold Because the bug that did not recognise the comment character in the password line has been fixed? Andy -Original Message- From: Ganbold [mailto:[EMAIL PROTECTED] Sent: 04 August 2003 09:51 To: Primaria Falticeni Cc: [EMAIL PROTECTED] Subject: Re: Problem reading my.cnf

Re: Adv. Mysql query

like this. Regards, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Slowing brute force attack

for the result and then do it all again. I don't think there is a way out of this problem. I would be interested in other answers. Regards, Andy. David Garamond wrote: Is there an option for mysqld to add a sleep() call after each failed connection request, before reporting to the client (to slow

Re: C API AND MYSQL

Dave, The documentation has several examples. Here's a function we use. Are you having a particular difficulty? Regards, Andy. snip MYSQL *aDb = NULL; int xConnect() { #define MYSQL_HOST 192.168.103.112 // or host name #define MYSQL_DBfoodb // database

Re: ERROR while compiling:

Prem, I had this problem and adding the library 'z' (whatever that is) helped. Try putting -lz at the end of your compile line. Regards, Andy. Prem Soman wrote: i am using Linux 6.2(Zoot) and MySql 2.23.36and found the following error while compiling the C program using mysql APIcc -o test

Re: Date to Days Query

and then calculate the number of days to expiry in a query like this: select (to_days(expdate) - to_days(curdate()) as days_to_expire from xxx...; If you get a negative answer then the record has already past it's expiry date. If I've misunderstood then sorry, please try again. Regards, Andy. Mike

Re: Adv. Mysql query

and then you will have to fix every table and query and program, so if you're still in design phase - then IMHO it's time to rethink the structure. Best regards, Andy jim smith This is a classic problem known as a Bill of Materials explosion and unfortunately relational databases don't handle it very

Re: NON web based client server applications

(but it need not be a 'server'), VB can be slower than raw JSP and you need to keep an eye on the VB program cos if it crashes the whole shooting match goes down. I'd be interested in the other answers. Regards, Andy. Java: A sledgehammer to crack a nut? No, more like a sledgehammer to paddle a canoe

Re: UNION or not?

users WHERE unix_timestamp(last_access) unix_timestamp()-1440 AND user_id '9' ORDER BY SortOrder, last_login LIMIT 20); Regards, Andy Gary Broughton wrote: Hi all I want to provide a list of up to 20 online users on our network of football forums, but would like to list those

RE: my.cnf is not available under windows 2000

Morten , The file used is my.cnf on unix and my.ini on windows. You should only have one file. Andy -Original Message- From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED] Sent: 01 August 2003 14:23 To: [EMAIL PROTECTED] Subject: my.cnf is not available under windows 2000 Hi

Re: Advice wanted on Data Structure

contains ITEM1 ITEM2 KIT2 KIT2 contains ITEM3 The issue came when trying to decide if we had 3 of KIT1 in stock. I couldn't find a single query (that allowed n levels) so I wrote a function that iterated the tree. Andy. Donald Tyler wrote: I have a question that I

Re: When mysql ruinned by Disaster

MaFai, But the ip address would change too If this system is running on a LAN why would it be a problem to change the DNS or are you trying to connect other clients (e.g. from the web?) - Andy MaFai wrote: Hello, mysql, We have 1 master and salve in my lan. If the master failed,coze

Re: dbase calculations

field_1, field_2, (field_1 + field_2) AS my_sum FROM my_table; This print 3 'fields', the third one is called my_sum and contains the sum of the other two (the AS keyword gives a field a name). Hope this helps, Andy. Kalle Saarinen wrote: Hello I'm rather new when it comes to databases

Atomicity of a SELECT/UPDATE

round and do it again } This sounds long winded to me. Anyone got a better suggestion? Thanks, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleting duplicating records

There a bit of discussion like this in the user comments of the manual: http://www.mysql.com/doc/en/example-Maximum-row.html - Andy Venelin Arnaoudov wrote: I would copy all the records (_email_, max(version)) to a new table, drop the old one and then rename the new one Regards, Venelin

How to retrieve integer in C prog?

to assume that all data is ascii. What I'd like to be able to do is something like this: int i = (cast)row[0]; Please tell me what I'm doing wrong - or is this a limitation? Thanks, Andy. Here's my code fragment if it helps: int checkWaitList(MYSQL *aDb) { // aDb connection is already

Version 5

After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for Compile it fails looking for .c pgms How do I get this to work... would like to use

RE: Can someone help me??

Try using only single quotes rather than a mixture of single and double quotes? Andy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 10:32 To: Rudy Metzger; [EMAIL PROTECTED] Subject: RE: Can someone help me?? I use phpmyadmin At 11.26 16/07/2003

<    1   2   3   4   5   6   7   >