RE: Another Newbie Question

George, Try in the folder with the same name as your database, under the data folder. Andy -Original Message- From: Degan, George E, JR, MGSVC [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 13:30 To: [EMAIL PROTECTED] Subject: Another Newbie Question I am finally able to enter

RE: MySQL vs. PostgreSql -- speed test

When I benchmarked PostgreSql against MySql for my application, MySql was 15 times faster, so 18% wouldn't make much difference for me! Andy -Original Message- From: Robson Oliveira [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 15:35 To: [EMAIL PROTECTED] Subject: Re: MySQL vs

Ver 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

MySQL, linux, ia32, 4GB RAM

as anything other than a big disk cache? If anybody is familiar with this scenario, I'd be very grateful for your insights. Regards, Andy -- Andy Stubbs, B.A. (Hons.), Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: Can mysql handle this load?

Adam, Mysql will easily handle this. This certainly doesn't constitute a large database. Correctly indexing the database should see you doing speedy queries on years worth of data. Sounds like you've used access in the past :-) Andy -Original Message- From: Adam Gerson [mailto

RE: concat() differences between mssql and mysql

Note that trailing spaces are not removed when you insert data into a TEXT (or BLOB for that matter) column. This may be of use to you, but TEXT does have limitations. Andy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: 08 July 2003 09:31 To: [EMAIL PROTECTED

RE: [HELP] Newbie experiences problems AND receives no help for the moment

know you originally tried to attach something, but there was no attachment to your message. I looked for it, saw it wasn't there and thought I'll ignore that - he's bound to repost when he sees that his attachment didn't get through... Andy -Original Message- From: Matthias Fischer

RE: issue with 'count'

Paul, Try SELECT c.id, count(cug2.id_curso) as num_profe_curso FROM nuke_elearning_curso as c, LEFT JOIN nuke_elearning_curso_usuario_grupo as cug2 ON c.id = cug2.id_curso group by c.id HAVING num_profe_curso 0 Andy -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: 07

RE: Counting question

Try this: select delivery, count(*) as ticketcount from ticketsales where delivery=post or delivery=pickup group by delivery Andy -Original Message- From: Ville Mattila [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 11:28 To: [EMAIL PROTECTED] Subject: Counting question Hi

RE: CSV Formated output

Jeff, Use SELECT INTO OUTFILE and FIELDS TERMINATED BY ',' See the manual for more info. Andy -Original Message- From: Jeff McKeon [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 12:38 To: [EMAIL PROTECTED] Subject: CSV Formated output Is there a way to output the results

RE: CSV Formated output

Jeff, By manual, I mean http://www.mysql.com/documentation/index.html It's worth downloading the all in one HTML file version so you can search through the whole document for things like SELECT INTO OUTFILE or FIELDS SEPARATED BY All the best, Andy -Original Message- From: Jeff

clustering mysql, e.g., EMIC software

Hi, I've seen this question once already on this list, but no answer - has anybody here used or otherwise have any experience of the cluster software from www.emicnetworks.com ? What other clustering packages exist? Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44

RE: sum() problems

Pat, I think it might be caused by the fact that you are grouping by a column that isn't being selected - ordini.numordine is not in the select part. Andy -Original Message- From: PaT! [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 12:50 To: [EMAIL PROTECTED] Subject: sum() problems

Re: user@% vs user@localhost question

communications channel on the localhost rather than over the 127.0.0.1 network interface? Andy On Wed, 25 Jun 2003, Roman Neuhauser wrote: your MUA doesn't properly represent quotation marks, breaking them in other MUAs. # [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700

RE: search and replace.

Try something like this: UPDATE tablename SET url = concat(programs, substring(url,12)) where url like (disciplines/%); Andy -Original Message- From: Craig Harding [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 17:31 To: [EMAIL PROTECTED] Subject: search and replace

RE: probably a stupid question

Jonas, After the insert, execute SELECT LAST_INSERT_ID(); This always gives the last auto increment value generated by your database connection. Andy -Original Message- From: Jonas Geiregat [mailto:[EMAIL PROTECTED] Sent: 18 June 2003 19:26 To: 'Mysql' Subject: probably a stupid

upgrading, tuning and performance

- is it really not used by the database anywhere? what kind of performance boost does it give? Regards, Andy -- Andy Stubbs, B.A., Ph.D. Network Manager, Active Hotels Ltd. +44 1223 578106 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: question?

Jerry, Try this link: http://www.phpbuilder.com/columns/moon19990716.php3 Andy -Original Message- From: JeRRy [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 14:35 To: [EMAIL PROTECTED] Subject: question? Hi, I want to run my php scripts, mysql from home. Now after being

Re: upgrading, tuning and performance

-sz avgqu-sz await svctm %util /dev/sdb12.74 4.63 8.58 7.10 90.54 94.5845.2747.2911.81 0.054.73 4.10 0.64 I'd say the 95-percentile for load is rather more like 1.4 than 2. Thanks for the input, A On Mon, 16 Jun 2003, walt wrote: Andy Stubbs wrote

mysqld_safe process

1044 S 0.0 0.0 0:00 mysqld 10362 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld Greetings Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: mysql linux user

Hi, I?ve forgot to say, that i?m a newbie to linux. So, what do you want to say, with these lines? That the 'mysql' user is not a shell user? Greetz Andy -Ursprungliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 6. Juni 2003 17:01 An: [EMAIL

RE: Getting the last entered row from a relational table

Try: select * from comments where (place_holder id) = (id in main table) order by id desc LIMIT 1 Andy -Original Message- From: Petre Agenbag [mailto:[EMAIL PROTECTED] Sent: 05 June 2003 11:05 To: [EMAIL PROTECTED] Subject: Getting the last entered row from a relational table

mysql linux user

Hello, if I install mysql under linux, there is a user created calld 'mysql'. My question is, whether this user has a default password, which should be changed to avoid security problems? Regards Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: full text searching question

won't execute the full text query more than once so this is not inefficient. Andy -Original Message- From: Chris Wilkinson [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 13:12 To: [EMAIL PROTECTED] Subject: full text searching question can anybody explain this to me please! I search

RE: full text searching question

Chris, I should have added that the explanation is that the full text query does not automatically sort on the score when boolean mode is selected. Andy -Original Message- From: Chris Wilkinson [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 13:12 To: [EMAIL PROTECTED] Subject: full

RE: password not working from command line

Eldon, Make sure you don't enter a space between -u and the username and -p and the password ie mysql -uuser -ppassword Andy -Original Message- From: Eldon Ziegler [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 16:15 To: [EMAIL PROTECTED] Subject: password not working from command

RE: Opposite of DISTINCT()

Bob, You have to do a self join - try this off the top of my head... - Select p1.email FROM tblperson p1, tblperson p2 WHERE p1.email = p2.email GROUP BY p1.email HAVING count(p1.email) 1 Andy -Original Message- From: Bob Sawyer [mailto:[EMAIL PROTECTED] Sent: 01 April 2003 21:04

compressed replication

, or is the option something that has never been implemented? Regards, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Backup on Windows machines

to have pretty good reviews. It's only for Windows, mind you, but as we run our server(s) under Windows 2000, that's what I'm interested in! Anyone using this? Andy Lawton sql, mysql etc etc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: UPDATE syntax help

with your code (or directly from SQL if you're a martyr) and then run it. I've used both methods successfully, Andy -Original Message- From: JJ [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 23:45 To: MySQL Cc: Paul DuBois Subject: Re: UPDATE syntax help That explains

RE: What to Download?

asking this question (no offence intended), I think you'll probably just want the server and client programs. Andy mysql query -Original Message- From: Jeremy Whitlock [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 16:39 To: 'MySQL' Subject: What to Download? MySQL List

LOAD DATA INTO not working

had this problem before? or should I give more privileges to this user? The manual says that SELECT/INSERT should be sufficiant. The exact error I get is: Access denied for user 'myuser@localhost' (Using password: YES) Any feedback would be appreciated. -Andy -- Andy De Petter - http

Re: LOAD DATA INTO not working

it ? Jerry - Original Message - From: Andy De Petter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 12:40 PM Subject: LOAD DATA INTO not working Hello gurus, When I try to perform a LOAD DATA INTO, I get a Permission Denied problem, although I

Re: LOAD DATA INTO not working

, then use Load data local infile Andy De Petter [EMAIL PROTECTED] Thursday, February 20, 2003 6:10:40 PM Hello gurus, When I try to perform a LOAD DATA INTO, I get a Permission Denied problem, although I (should) have the correct privileges, for a specific user: GRANT SELECT

Re: LOAD DATA INTO not working

I've just tried, and it seems to work This means, there is an error in the O'Reilly book (July 1999, 1st Edition) then. ;) Thanks a lot, -Andy On Thu, 20 Feb 2003, Jerry wrote: The search engine on www.mysql.com is always worth a look first ... For security reasons, when reading

Re: InterBase vs. Mysql

On Tue, Feb 18, 2003 at 05:06:17PM +, Ben Clewett wrote: This will be my last posting. I don't belive I am being constructive and have no wish to instantly be hated by the whole of MySQL. Probably wasn't wise to make a post about how you felt MySQL was expensive (huh?) and their staff

RE: Recursion

remove the objects own id from the fullpath and make it effectively parent path Hope this helps. All the best, Andy -Original Message- From: Rob [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 07:18 To: [EMAIL PROTECTED] Subject: Recursion Hi all, I need some help

Re: Generating an automatic e-mail via MySQL

) or even directly into sendmail. It works fine. Andy - 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

RE: Recursion

children of a node, it's a more efficient query to use where parentid = x, rather than where fullpath like '1/2/3/4/%' All the best, Andy Yes, excellent idea. It's the classic 'linked list' from my old Pascal days. While playing with it I realized that you only have to save the ID, Name

RE: Very slow request with many ORs in where parts

Artem, Have you considered using a full text index? I don't really understand exactly what you are trying to do, but consider it if you haven't already. Andy -Original Message- From: Artem Koutchine [mailto:[EMAIL PROTECTED]] Sent: 11 February 2003 14:23 To: [EMAIL PROTECTED

Re: CREATE TABLE, NOT NULL fields, and empty strings (auto)

On Fri, Feb 07, 2003 at 04:33:15PM -0700, [EMAIL PROTECTED] wrote: Hi Doug Beyer [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: Please could these stop. Already I have noticed various people reposting old

Re: working around lack of subselects

On Thu, Feb 06, 2003 at 09:52:11AM -0500, Brent Baisley wrote: As long as the foreign keys are index it should be pretty quick. There really is no way to get around processing every record in table data. As that table grows, your query will get slower. But a 157K rows isn't really a whole

working around lack of subselects

Hi folks, I have a problem that normally I'd want to use subselects on. Here it goes: Table t1 has a column data_id. Table t2 has a column data_id. Both are foreign keys for the autoincrement primary column id of the table called data. I wish to delete every row from data which is NOT

Where have SRPMs gone?

Hi folks, Where have the links to MySQL SRPM packages gone from http://www.mysql.com/downloads/mysql-4.0.html ?? I found being able to build binary RPMs from your SRPMS to be useful, please could you make these files available again? (yes I am aware I could build them from a .spec file if that

RE: [ gamma file ]

.NET SP19stable Andy mysql query -Original Message- From: Elby Vaz [mailto:[EMAIL PROTECTED]] Sent: 16 January 2003 13:46 To: [EMAIL PROTECTED] Subject: [ gamma file ] --Im brazilian. Sorry by my english hello! I installed mysql-4.0.9-gamma

RE: Need help with UNION

members where fd_status = A); Andy -Original Message- From: Garry Rothert [mailto:[EMAIL PROTECTED]] Sent: 16 January 2003 14:11 To: [EMAIL PROTECTED] Subject: Need help with UNION Hi I am attempting a simple union. select cnumber from spouse where fd_status = A union select

RE: Solaris Performance

a fast Intel Linux box behind the sun box as a database server, and leaving the sun to run apache and tomcat. Hopefully this will give me the best of both worlds. Thanks again, Andy -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 18:50 To: Andy

Solaris Performance

support)? Has anyone got any similar experience? Can any one recommend trying anything? Any help, comments or suggestions would be very much appreciated. Thanks very much, Andy [mysql query] - Before posting, please check

Solaris Performance

support)? Has anyone got any similar experience? Can any one recommend trying anything? Any help, comments or suggestions would be very much appreciated. Thanks very much, Andy [mysql query] - Before posting, please check

general query log

and restart? (2) Is there some way to get similar output with a different tool? [mysql query] TIA, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] - Before posting

RE: Solaris Performance

Simon, Thanks, for the reply. I guess I better try the 64 bit version and see if it makes a difference. I'll report back what I find. Cheers, Andy -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 16:58 To: 'Andy Eastham'; [EMAIL PROTECTED

tailoring result display from multitable select

) Thanx for any help! -- Andy - 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 PROTECTED] To unsubscribe, e

Re: mailing list problem?

temporarily. (#4.4.3) andy - 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 PROTECTED] To unsubscribe

handling of diacritics?

characters. Additionally, there is a way to retrieve the ASCII number assigned to a given character, but not vice versa. Is there any way to have 'ü' match on a 'u' in a search string, etc., etc., etc.? sql TIA, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962

Re: subtraction on datetime fields

comparsion (using and ) still work because the date is arranged with the most signifcant portion being further left. Andy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Can I get the matching expression from REGEXP

; and for the update: update table set colY = substring_index(colX, ' ', -1) where substring_index(colX, ' ', -1)) colX; Andy. On Tue, 2002-12-10 at 17:40, Mike Bosschaert wrote: Hi, In one of my tables I have a column which contains a combination of a string (characters only), a space and a 1

Re: Select * From table where name Like 'help'; Help

You still have not mentioned what language you are using to interface with MySQL. If you are using PHP or Perl, then things like single and double quotes will make a difference here, and looking in the MySQL manual will not help you. Check the string that contains the query, if it looks like

Re: Select * From table where name Like 'help'; Help

On Mon, 2002-12-09 at 16:10, Beauford.2003 wrote: Andy, I mentioned in my previous email that I am using PHP, and I have also tried putting quotes around $var (many different ways) with no better results. REGEXP just gives a syntax error when I do this. I'm sorry, I did miss the where you

replication, multiple masters

-conflicting, server independant key values without the need for the auto_increment, but has anyone had any experience with this? Is this the only impediment to doing full two-way replication? What other 'data corruption' or 'out of sync' issues are there to worry about? Andy. [EMAIL PROTECTED

Problems with upper/lowercase mappings

Hi folks. I have an application in which I require the only case equivalencies to be a-z A-Z. What I mean is, e/E should be regarded as identical in strings, but neither e/É (E-acute) nor é (e-acute)/É (E-acute) should be regarded as identical. When the application was first written I was

Re: Serwer Hardware p4 or pIII ?

should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy

RE: converting from foxpro to mysql ???????

I do speak English natively, and I haven't a clue what you're talking about either. Andy mysql query -Original Message- From: Tonu Samuel [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 09:48 To: toby z Cc: [EMAIL PROTECTED] Subject: Re: converting from foxpro to mysql

RE: Application level security

). Andy -Original Message- From: Noel Clarkson [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 11:10 To: [EMAIL PROTECTED] Subject: Application level security Hi All, I'm writing a application that needs row level security in it so that only certain users can view/change etc

Re: performance tuning (generating summary tables)

On Thu, 2002-11-21 at 09:47, Johannes Ullrich wrote: And more difficult, try to look at your application design and try to come up with 'cache tables' that are generated by a cron job periodically and are used for most queries. This is an excellent suggestion and may make you think about your

Re: Incorrect DATE_FORMAT output for weeks with year e.g. '%v-%y'

or monday. Andy. - 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 PROTECTED] To unsubscribe, e-mail

RE: Mysql Encryption

secure tunnelling. But as this tunelling is a fundamental part of SSH, there must be some open source implementation too? Anyone else like to add to this? Andy mysql query -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED]] Sent: 18 November 2002 13:54 To: Alexandre

Re: PHP bias

as much database support, which is why PHP has become popular in the web community. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

RE: Newbie: Intersecting entities

John, You're making sense. If you wanted to find all the systems used on project Test Bed Alpa, you'd do something like this: Select sys_name, s.id, project_name FROM systems s, new_req n,ie_sys_req i WHERE s.id = i.sys_id AND n.id = i.proj_name_id AND n.id = 344; Hope this helps, Andy mysql

Re: mysql 4.x for debian?

platforms. Proprietary packaging formats such as those used by Debian, Red Hat, etc are not directly supported but contributed by others. regards, Andy - Before posting, please check: http://www.mysql.com/manual.php

query optimization with CONCAT query

ideas of how to address this issue? TIA for any insights, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: query optimization with CONCAT query

| title | +-+--+ | The | catcher in the rye | CONCAT allows me to do this, but I'm hoping to optimize that operation somehow, perhaps with an index. Andy olinux wrote: Mysql 4.0.1+ supports searches IN BOOLEAN

RE: select using regexp

Mark, It looks like you should be using full-text indexes and the match and against functions to me. Check out section 6.8 in the manual. Andy mysql query -Original Message- From: Mark Goodge [mailto:mark;good-stuff.co.uk] Sent: 04 November 2002 11:21 To: [EMAIL PROTECTED] Subject

mysql compile problem under Solaris 9

sugguestions? Thanks! Andy - 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 PROTECTED] To unsubscribe

Re: Too Many Aborted Connects

I know I'm not the only one experiencing this problem. The solutions recommended in the documentation haven't helped resolve it. I've heard of people using flush-hosts as a solution, but that's just a band-aid. Any ideas? - Original Message - From: Andy Etemadi [EMAIL PROTECTED

Too Many Aborted Connects

are in full duplex mode. Can anyone shed some light on this problem? Thanks, -- Andy Etemadi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: ERD, Scripts, and Reverse Engineering

is covered. So far I'm finding it stable and very easy to work with. Andy On 20 Oct 2002 at 19:07, Randy Garland wrote: Hello, all: I'm looking for a well-designed Windows-based database design tool that: 1) (Most importantly) Supports MySQL 4.x: a) supports all of its datatypes

High Load Average

spike soon after we restarted the server but we have not seen one today yet. Any suggestions? I need a vacation! Andy Yates [EMAIL PROTECTED] Senior Software Developer NetNearU The question should be, is it worth trying to do, not can it be done. Allard Lowenstein

RE: High Load Average

the load average problem, but it still has other issues. BTW Thanks for all the vacation spot suggestions! -Original Message- From: Andy Yates Sent: Tuesday, October 15, 2002 11:11 AM To: [EMAIL PROTECTED] Subject: High Load Average HELP! We are running RH 6.2 and when we applied all

Mysqld DNS lookup causes crash

: To reintroduce the problem take out --skip-name-resolve and connect remotely. Fix: Add --skip-name-resolve to the startup script. Submitter-Id: submitter ID Originator:Andy Ciordia Organization: Planned Giving Design Center MySQL support: none Synopsis: Mysqld crashing on DNS

Re: SELECT COUNT

On Fri, 27 Sep 2002, Michael J. Fuhrman wrote: Hello All, I seem to be running into a very strange problem. In the mySQL command line interface I issue SELECT COUNT (*) FROM The correct syntax is SELCT COUNT(*) ie, there's no space between SELECT and the (*). Andy

persistant db connections?

connection anyway? Is is persistant when the user is browsing all the sites in my sytem? And when do I have to build the connection? Thanx for any help on that, Andy query - Before posting, please check: http://www.mysql.com

Re: Bug ?

On Mon, 2 Sep 2002, Marian wrote: Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 Good sys admins don't let filesystems become full Andy

Re: convert ms access mdb file to file that can be imported in mysql

you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. Andy - Original Message - From: Mertens Bram [EMAIL PROTECTED] To: mysql mailing list [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 4:17 PM Subject: convert

full text search problems

characters? 2. Is it possible with php to underline the keyword inside the search results. This might be more tricky. Thank you for any help on that, Andy query - Before posting, please check: http://www.mysql.com/manual.php

Difference between MySQL 4 and MySQL Max 4

with MySQL 4 or MySQL Max 4. hence my question. Thanks a lot. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

RE: Cyber security

Spam is such an ugly word. We believe that the attached piece, while not directly concerned with MySQL directly, may be of general interset to the list subscribers. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 12:08 PM To: Andy Wood

Re: libmysqlclient.so.10

On Tue, Jul 23, 2002 at 09:22:55PM -0600, Steve Dickey wrote: Can anyone tell me how to get an RPM that provides the libmysqlclient.so.10? I am trying to install the php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It comes in an older version of the mysql database rpm

./configure failure when building from source

... no checking DEC 3.2 threads... no checking SCO threads... no checking SCO UnixWare 7.1 native threads... configure: error: Can't find thread libs on SCO UnixWare7. See the Installation chapter in the Reference Manual. How-To-Repeat: run ./configure script again Fix: Submitter-Id: andy lever Originator

./configure failure when building from source

: andy lever Originator:Special Admin login Organization: Torex Retail Ltd MySQL support: [email support] Synopsis: synopsis of the problem (one line) Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Source

Three easy, FAST-REPLY questions re: MySQLGUI

for MySQLGUI ___ ___ ___ ___ ___ ___ ___ __Yes __ No The newest MySQL C++ library ___ ___ ___ ___ ___ ___ ___ Thanks for your kind assistance and reply at your earliest convenience. Respectfully yours, Andy Fields [EMAIL PROTECTED] Santa Clara, CA (in the heart

Opposite of --skip-networking?

Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I see skip_networking=ON yet I am not starting mysql with --skip-networking. To reverse this situation I tried putting: set-variable =

Re: Opposite of --skip-networking?

On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote: On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote: Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I

calculating inside query

see the error: SELECT ID, rating_total / ratings_amount AS top10 FROM rating ORDER BY top10 desc LIMIT 10 Thanx for any help, Andy query - Before posting, please check: http://www.mysql.com/manual.php (the manual

sorting values not so easy!

to sort the other arrays with the same sorting algo? Or a way to include a iff clause in the query? currently I am doing: SELECT u_name, id, points FROM user WHERE points 0 ORDER by points desc LIMIT 5 and the top10 reports extra. Has anybody a good idea on that? Andy

Re: Moving a DB from one Server to another

it a couple times. and it stil works :) I use mysqldump to create dumps of all the databases/tables, ftp or sftp them to the other server, create new databases there using mysqladmin and then pipe the dump into mysql, eg: cat database.dump | mysql -u root -p database Andy

resizing images in blobs

in advance, Andy query - 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 PROTECTED] To unsubscribe, e

RE: mysql.com site down

for European connectivity. ebone have gone bust I think ... Andy -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: 02 July 2002 10:45 To: [EMAIL PROTECTED] Subject: RE: fulltext searching Hi If anybody from mysql is listening / watching, www.mysql.com is down

blob versus file

) to show up on the site. Is there a way to improve the performance, and why is this happening? I thought the performance might even boost after storing them to blobs. Thank you for any comments on that, Andy PS: I was planing to store all the other images (20 - 50 KB) to blobs as well (thousands

saving modified image to blob

on that. Thanx for any help, Andy query - 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 PROTECTED

Stored procedures

Does anyone know if stored procedures have been implemented in MySQL? Getting into the MySQL web site from the UK is almost impossible these days so I thought I'd ask here. Thanks in advance for any information, Andy

<    1   2   3   4   5   6   7   >