re[2]: Could we make this a web discussion forum?
I am with you jeremy... Web based discussion boards are horrible. I never remember to go daily. I can write my responses to this on the train and send them when I get to my desk. Rich On Mon, Mar 31, 2003 at 12:52:43AM -0800, Seth Brundle wrote: I really hate mailing lists - they are dinosaurs for this type of thing. I really hate on-line forums. They're difficult to track because I must remember visit them daily. And I can't use them while disconnected. With e-mail, I download it all in one shot and read it anywhere. I can write responses, queue them up, and send 'em when I have a connection. A web discussion board is a much more powerful and flexible tool for this type of community. Hmm. E-mail has been around for a long, long time. I'm skeptical of this claim. Thread tracking, archiving, searching E-mail gives you all of those. dont have to download 50 emails a day just to monitor a couple threads...cmon its 2003! That sounds like a problem with your choice of mail tools, unless I'm mis-understanding your gripe. Cant we convert this into a discussion board or better yet just make the usenet group mirror postable from google groups? I believe there is already a read-only NNTP mirror of this group. There are 4 lists like this one where I have to continuously subscribe and unsubscribe throughout the year when I want to participate. Why must you subscribe and unsubscribe to participate? There's no membership requirement to post here. And you can always read the messages on-line. There are at least 2 web archives of this group. You've seen those, right? I know that Google has. Also emails get mirrored on google groups for convenient spam harvesting - its really a pain in the butt. How would using a web forum help that? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 55 days, processed 1,882,414,788 queries (389/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: ERWin 4.1 not applicable for MySQL
You could try: Datanamic's Dezign - www.datanamic.com or you could use MS Visio Professional HTH Richard Dear MySQL users developers and programmers, ERWin 4.1 not applicable for MySQL I'd like to model some logical databases in Entity Relationships diagrams From here I found interesting software URL: http://www3.ca.com/trials/ https://www3.ca.com/register/form.aspx?cid=8403 Download ERwin 4.1 Evaluation Software ftp://ftp.ca.com/pub/erwin/EvalLic/ERwin41SP2-2765.exe According to the Documentation this visual tool supports a variety of databases: Target Databases Supported by ERwin Desktop Databases Microsoft Access Clipper DBASE IV FoxPro Paradox SQL Databases AS/400 DB2 390 DB2 UDB HiRDB INFORMIX Ingres II InterBase ODBC Generic OpenIngres Oracle PROGRESS Rdb Red Brick Warehouse SAS SQL Anywhere SQLBase SQL Server Sybase Teradata WATCOM/SQL Anywhere Since I am fond of MySQL I'd like to know your opinion, Is it possible to access MySQL from AllFusion ERwin Data Modeler ? What design tool do you use under Windows or Linux for modeling a logical database ? Yours Sincerely Morten Gulbrandsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL v SAB DB
Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than that the product works fine with MySQL) Does anyone have such experience. Is the support as good as MySQL? From what I can see, it is a fully featured DB engine. Thanks Richard - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Highly Reliable MySQL Installations
Hi, I am looking for advise on producing a MySQL platform which is reliable (i.e. fault resilient). I am not sure how, using MySQL's technology I can have two systems each one mirroring the other, and if the primary server fails, how the system can automatically use the other server for all DB access. What is the avg latency on the slave server in Replication? Any Ideas or Suggestions on this? Thanks Richard - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: InterBase vs. Mysql
Actually, I think you are not quite right in all respects. but feel free to correct me if I am wrong Somebody, or some entity still needs to hold the copyright of a product. How that entity chooses to sell or distribute that product is up to them. In this case MySQL AB is the copyright holder. They have a fast, highly reliable product which meets the need of the majority of web-developers (and other developers). It is not as feature rich as, say Interbase or MSSQL Server. (I would love triggers and stored procedures, so that I can store business logic in the RDBMS) This is my interpretation (after clarification from MySQL, and www.mysql.com ), of MySQL's licence: If a product is inherrently tied to using MySQL, i.e. without MySQL it would need re-development, alteration, or would not work. And you are profiting from the sale of that product, then MySQL insist a license should be purchased. If the product is DB Agnostic or if the product is open-source and is distributed under GPL, then it doesn't need a license. Basically, if you profit from MySQL's work, they want a very modest fee for there effort (much cheaper then other traditionally commercially available RDBMS.) HTH, Richad I'm not here to slag MySQL, but this point is extremely interesting. Benjamin Pflugmann wrote: Aehem. There seems to be some misconception here. Either your program is fine with MySQL being GPL or not. If it is (and your forking example would work for you) either by using MySQL in a way that your program is not required to be GPL'ed or by GPL'ing your program, you need no commercial license from MySQL AB either, and you can already distribute your program with MySQL without the need of a fork or whatever. Or your program needs a commercial license, than forking MySQL would not help, because you still have to adhere to the GPL. The only reason MySQL AB can hand out a commercial license is because they are also the Copyright holders, which you aren't even after forking. There is also some middle ground here. Which is the overlap of the two. Where the user (me) wants to use a OSS DBMS, is happy to forward the source code, inform the customer of the GPL licence etc. But at the same time produce a commercial application which then uses this installed DBMS server/client, without effecting the GPL package. MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. They are however, the only big GPL user who thinks this way. I note for example the number of companies selling commercial CGI software designed to run on Apache, server/client, to which no licence is mandatory. Also Sendmail, GCC, other DBMS's, and indeed GNU/Linux it's self. None of these very large groups consider a licence *mandatory* for use when supporting a commercial application. I use the term 'mandatory', they may still choose to purchase a licence. If they did insist on a licence, a very large number of very large companies would have to withdraw a very large number of products. Eg, IBM who use Sendmail to support their commercial email servers. Therefore, I can see no reason why not somebody could fork MySQL into FreeSQL. It would take a few hours at SorceForge, a 'sed' of MySQL into FreeSQL', and a good posting to Slashdot. Keep it 100% GPL without breaking either the wording or the spirit of the document. Remove all reference to copyright material belonging to MySQL. It's either GPL or cpryright, not both. Then use this without commercial licence... BTW, as to another posting. 'Either accept the GPL or purchase a licence'. I do note another option (apart from forking): Use something else. Is MySQL really that good? I do worry that with arrogant statements like this, this is exactly what people will do, in droves. If that's okay with you, well... HTH, Benjamin. - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: Can MySQL work on Windows XP?
Hi, Yes MySQL will work on XP-HomeEd To start it... open a command prompt, do this by... Start - Run - cmd.exe then cd c:\mysql\bin mysql-nt.exe this has started a mysql db engine. the command prompt will not return. to install it as a service instead do the following instead of the above Start - Run - cmd.exe then cd c:\mysql\bin mysql-nt.exe --install net start mysql in either case you now have to open a console window. do the following. Start - Run - cmd.exe then cd c:\mysql\bin then type mysql.exe this will open a console window for you to control the mysql db engine HTH Rich Does it (mysqld-shareware.exe) show up in the task managers listed processes? If not, it is not running (which is what I suspect). Through my experience with it, the DOS box does not close. Try opening a DOS box and starting it (type 'cmd' in the run box) and see what error comes up. If you are still stumped there, write again and include the error message and the c:\windows\my.ini and-or c:\my.cnf settings. -- Loren McDonald [EMAIL PROTECTED] -Original Message- From: Marg Brazil [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 11:31 AM To: MySQL Subject: Can MySQL work on Windows XP? Hello, Can anyone tell me if MySQL will work on Windows XP Home Ed.? I have MySQL installed according to the instructions on the CreateASite web page. I tried contacted CreateASite with this description of the problem: The start up looks good: when I use the Run function C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but I'm getting this error when using the MySQL test script (See below): Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in c:\usr\htdocs\mysql_test.php on line 7 Couldn't Connect I have followed the instructions for installing IndigoPerl, CreateASite, PHP, and for MySQL on www.createafreewebsite.net/mysql.html. Apache was running well at the time, and the perl and php test scripts were A-OK. Should MySQL show in WindowsXP task manager? I can only see 2 Apache.exe' s and HTMel30.exe. There's no C:\mysql\bin\mysqld-shareware.exe listed. CreateASite response was: I worked with a guy from Germany for 2 days trying to get the mysql package you are using to work on XP. No luck. I should probably put that on the site. I'm not saying you can't get the present package to work. Just saying I didn't on XP. Has anyone in this discussion group had success getting MySQL to work on Windows XP? Thanks! MB MySQL test script: html head titleMySQL Test/title /head body ? $link = mysql_connect(localhost); if (! $link) die (Couldn't Connect); $db_res = mysql_list_dbs($link); $num = mysql_num_rows($db_res); for($x=0;$x $num; $x++) print mysql_tablename( $db_res,$x).br; mysql_close($link); ? /body /html - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL PROTECTED] www.quantum-comms.com - This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to Quantum Communications and is intended for the recipient(s) named above only. If received in error please notify the sender and destroy the original message and attachments. Emails may be monitored or recorded. It is the responsibility of the recipient to ensure that the e-mail and/or any attachment is virus free. The views expressed by the author may not reflect the views of Quantum Communications Limited. - - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Off Topic - PHP/Mysql Development company
Hi, I am sorry this is a bit off topic. I am looking for recommendations of MySQL / PHP / HTML / Javascript development companies. Companies which you have previously worked and found to be very good at what they do and good value. They need to be English speaking. I am especially looking for companies in south of the UK. I have previously used a company in India and I am not averse to trying this again. Suggestions anybody... Thanks to all. Richard SQL - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Off Topic - PHP/Mysql Development company
Hi, I am sorry this is a bit off topic. I am looking for recommendations of MySQL / PHP / HTML / Javascript development companies. Companies which you have previously worked and found to be very good at what they do and good value. They need to be English speaking. I am especially looking for companies in south of the UK. I have previously used a company in India and I am not averse to trying this again. Suggestions anybody... Thanks to all. Richard SQL - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: Backups mechanism
Hi, I agree with the post... I feel there should be an inbuilt backup routine. (maybe built into something like MySQLFRONT or MyCC.) The shell script below, as far as I understand will not work with InnoDB only MyISAM tables. (please correct me if I am mistaken) It seems that MyCC is far far far behind commercial GUI's, but I feel that this is one part of the product that most people, even ISP's who use MySQL for free would pay for - i.e. a GREAT fully integrated MySQL GUI. Thanks Richard What we have done it right a small script: It logs on to the MySQL server. It then locks the databases and tables we have put in a config file. Simply copies the data files to a new directory. Unlocks the tables. Once this is done (copy if fast) you can tar or zip up the copied files. Simon -Original Message- From: Jonas Widarsson [mailto:[EMAIL PROTECTED]] Sent: 07 January 2003 15:07 To: [EMAIL PROTECTED] Subject: Backups mechanism Hello world! Every attempt I have made to find a decent way of backing up a database ends up with tons of reading to show hundreds of ways to do database backups. I want to know which way to do complete backups is most commonly used by professional users. (Windows and Linux) I have pleasant experience from Microsoft SQL Server 2000 where backung up is very confident, easy to understand and just a matter of a mouse click. Is there any similarily convenient way to do this with mysql, for example: * a shell script (windows / Linux) that works as expected without days of configuration? * scheduled backups, complete or differential? * GUI-solution ??? (mysql control center does not even mention the word backup) Backup is such an important issue. Why does it seem like it is something that the developers don't care about? - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL PROTECTED] www.quantum-comms.com - This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to Quantum Communications and is intended for the recipient(s) named above only. If received in error please notify the sender and destroy the original message and attachments. Emails may be monitored or recorded. It is the responsibility of the recipient to ensure that the e-mail and/or any attachment is virus free. The views expressed by the author may not reflect the views of Quantum Communications Limited. - - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: MySql 4.1 Sub Selects
Hi according to this link... 4.1 will have stored procedures http://www.mysql.com/products/mysql-4.0/index.html Rich With the efficiency comment below, I was using the strategy that I'd prefer to wait for 4.1's impending (?) release rather than rewrite SQL in a workaround way. It's a tradeoff based on our specific project and relating to time factors, etc, and the amount of SQL I'd have to rewrite. Yes i'm sure the hurdle could be overcome but I'd rather hold back on MySql support until subselect functionality is ready. Typically, database vendors seem to recommend using EXISTS because the query returns on finding the first row that meets whatever the subselect criteria is. Do those people working on 4.1 anticipate the performance of the MySql sub select functionality to be better than an equivalent query written as a join? I guess any answer to this should also include consideration of sometimes putting DISTINCT in the select statement. Thanks a lot, Greg. - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Greg Matthews [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 11, 2002 11:16 AM Subject: Re: MySql 4.1 Sub Selects Greg Matthews wrote: clause) instead of EXISTS -- seems like a tail wagging the dog strategy. Isn't EXISTS a lot more efficient than an inner join? Well, its more efficient if it exists, I guess ... but if it doesn't exist on your platform (MySQL), then its pretty inefficient, really. We're going to offering the application on Oracle and so I wouldn't like to de-optimize the SQL just so it works on mysql 4.0 if 4.1 will be out within a few months. If you're writing OO code, you might be able to easily flag your objects as to whether to use one or the other query based on the underlying database system (queried at run-time). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards, Richard Morton Quantum Communications +44 (0) 7899 750400 [EMAIL PROTECTED] www.quantum-comms.com - This email, its content and any attachments is PRIVATE AND CONFIDENTIAL to Quantum Communications and is intended for the recipient(s) named above only. If received in error please notify the sender and destroy the original message and attachments. Emails may be monitored or recorded. It is the responsibility of the recipient to ensure that the e-mail and/or any attachment is virus free. The views expressed by the author may not reflect the views of Quantum Communications Limited. - - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Info on 4.0.x release date
Hi Will, As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta as we speak and is likely to be released in the next month. V4.1 will most likely be released Early Sept in Src form and in Binaries two months later. 4.0.x branch will be allowed to stabalise from the release of 4.0.3, through the normal Beta, Gamma and Stable routine. In fact I believe there was an email to this effect earlier today Rich When will 4.0.x finally be released to beta? The facts as I understand them: - 4.0 went alpha in Nov or Dec of '01 - At the time, Monty and his gang projected stabilization by Jan or Feb - More than 6 months have passed since and the product is not yet stabilized - No meaningful information has been released about what a more realistic date might be - Anytime anyone dares to stick their head up and inquire about this issue, they get their hat handed to them with a glib when its ready response It is impossible for me to believe that I am the only one frustrated by this. I spent months evaluating the suitability of MySQL for our systems last summer/fall. At that time I made the determination that it would be quite well suited, but only with the addition of some functionality promised in 4.0 and 4.1. It is not my intention to put the MySQL team on the defensive about this -- I know they are working incredibly hard. I do not, however, feel it is unreasonable for the user community to ask for more information about upcoming releases. I know that you are probably thinking that I don't have the right to be demanding when the software is free. Well guess what, it isn't! Every company that uses MySQL spends money on it (remember, licensing represents only a small fraction of total cost of ownership). Furthermore, MySQL AB is a for-profit venture whose fortunes are tied to the continued spread and use of their flagship open-source product. So... How about cluing us in on what's left to do, what progress has been made and a best-guess as to what the release schedule might look like. I wouldn't worry too much if your dates slip over time (I think you will find a sympathetic group), but just keep us updated so we can adjust our own plans. Thanks Will French == NOTE: The information in this email is confidential and may be legally privileged. If you are not the intended recipient, you must not read, use or disseminate the information. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Cadwalader, Wickersham Taft for any loss or damage arising in any way from its use. == - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Versions
Hi, I am looking for dates for new versions and the bug fixes they will have contained. I am using 4.0.1... however I have a handles leak. I have been told by another source that this will be resolved in 4.1 My question is, using MyODBC(3.51.03)... Is this a problem with 3.x stable releases or just 4.0.x alpha releases. If this is an issue with both, does anybody know when this will be fixed or what versions don't have a problem? Does anybody else suffer with this? Has anybody found a resolution? Thanks Rich Filter Fodder: SQL - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: MySQL Errors -
What instances can cause a Table to crash? Is this caused by a bug in itself, a power failure, or something else? Richard William_dw, Tuesday, July 23, 2002, 10:34:16 AM, you wrote: WS I'm hoping someone can give me a pointer as to what's going wrong that's WS crashing our MySQL server, I've included a snippet of the log (for the last WS time it restarted and then the errors after that). WS I've been trying to read through the 'Debugging MySQL server' section, but WS there doesn't seem to be much to go on from the log, and the 'if you don't WS see anything something went terribly wrong' message with nothing but an WS 'aborting backtrace' message after it kinda has me worried over here. WS Any suggestions, pointers, or anything else would be really appreciated as WS my hair is turning gray by the second :). WS Thanks in advance, WS William. WS mysqld got signal 11; WS The manual section 'Debugging a MySQL server' tells you how to use a WS stack trace and/or the core file to produce a readable backtrace that may WS help in finding out why mysqld died WS Attemping backtrace. You can use the following information to find out WS where mysqld died. If you see no messages after this, something went WS terribly wrong WS Bogus stack limit or frame pointer, aborting backtrace WS Number of processes running now: 0 WS 020722 08:55:42 mysqld restarted WS /usr/sbin/mysqld: ready for connections WS 020722 8:55:45 read_key: Got error 127 when reading table WS './wahse/keywords' $ perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Your table is crashed. You should repair it using myisamchk: http://www.mysql.com/doc/m/y/myisamchk_repair_options.html http://www.mysql.com/doc/R/e/Repair.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: newbie SOUNDEX question
Hi, You are doing everything fine, however, soundex is not a perfect system and does not always work. It does simplify some types of queries. But in the vast majority of cases I don't think that it is worth the bother. It doesn't actually link all the same sounding sirnames, if there were a system like that life would be nice and simple, however (and correct me if I am wrong) there isn't one. Soundex was an attempt and it doesn't really work. It is used by the US government but it just means you have to search under a couple of different soundex codes rather than searching under 8 or 9 different spellings. See this example. mysql select soundex('morton'), soundex('moreton'), soundex('morten'); +---++---+ | soundex('morton') | soundex('moreton') | soundex('morten') | +---++---+ | M635 | M635 | M635 | +---++---+ 1 row in set (0.00 sec) mysql select soundex('callaghan'), soundex('callahan'), soundex('calahan'); +--+-++ | soundex('callaghan') | soundex('callahan') | soundex('calahan') | +--+-++ | C425 | C450| C450 | +--+-++ 1 row in set (0.00 sec) mysql I hope this helps. Richard I want to use SOUNDEX for name queries, but I don't seem to be doing it correctly. As a test, I made a small table and popluated it with my name. My goal is to be able to find my name 'Callaghan', with its most common misspelling 'Callahan'. I've read the MySQL doc, so I know how to actually invoke soundex at the mysql prompt. I read an article that said soundex queries move more quickly if you add a column for the soundex. Thus: CREATE TABLE sound ( id tinyint(3) NOT NULL auto_increment, name varchar(100) default NULL, sound varchar(100) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; select soundex('Callaghan'); result = C425 INSERT INTO sound VALUES (1, 'Callaghan', 'C425'); Simple enough. Now, I expected all three of the following queries to return a value. select id from sound where sound = soundex('Callaghan'); returns 1 records select id from sound where sound = soundex('Callahan'); returns 0 records select id from sound where name = soundex('Callaghan'); returns 0 records I'm missing something obvious here, but I've read the doc and I'm not sure what's wrong. -- Get your free email from www.linuxmail.org Powered by Outblaze - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FWD: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490
please see below -- Forwarded Message -- FROM: euro.support [EMAIL PROTECTED] TO: Richard Morton [EMAIL PROTECTED] DATE: Fri, 17 May 2002 10:26:06 +0200 RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490 Hi Richard, I have received an answer from our dev team, please see below: -- MySQL does not accept SQLSetConnectAttr function for setting the SQL_ATTR_CONNECTION_TIMEOUT which is added recently to the same value as the query timeout. Unfortunately although it is legal ODBC 3.0 parameter MySql crashes instead of reporting error if it does not support it. This should be considered MySQL bug. Code is changed in PU 8 not to call this function if timeout is set to 0. I will post here just a FDbase.fdl which can be used even on PU007 Release. But customer still needs to change its script to set query timeout to 0. -- Attached you can find the FDbase.fdl file, just unzip it into your Envox folder, then change your script as stated above. Please let us know the outcome of this. Best regards, ___ Andreas Persson Technical Support Envox EMEA Söder Mälarstrand 43 118 25 Stockholm Sweden www.envox.com Tel: +46 (0)8 56 256 000 Dir: +46 (0)8 56 256 062 Fax: +46 (0)8 56 256 050 mailto:[EMAIL PROTECTED] -Original Message- From: euro.support Sent: den 16 maj 2002 16:25 To: 'Richard Morton' Subject: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490 Hi Richard, I have not been able to reproduce the same problem herehowever I have sent this further to our developers so they can have a look at it as well. I'll get back to you as soon as I hear anything from them. Best regards, ___ Andreas Persson Technical Support Envox EMEA Söder Mälarstrand 43 118 25 Stockholm Sweden www.envox.com Tel: +46 (0)8 56 256 000 Dir: +46 (0)8 56 256 062 Fax: +46 (0)8 56 256 050 mailto:[EMAIL PROTECTED] -Original Message- From: Richard Morton [mailto:[EMAIL PROTECTED]] Sent: den 16 maj 2002 05:34 To: euro.support Subject: FWD: ECS Error with 4.0.07 opening DB (still) again Hi Guys, Sorry I lost the last email so I don't know the ticket number... Continuing problem I have just rebuild my system completely to remove any possibility of that causing the problem. (look at the time of this msg!). Any way: What am I using... D/120JCT-LS MyODBC and MySQL 4.0 Dialogic SR 5.01 Envox 4.0.07 Nuance v7.0.4a SP23. See attached files. On the installation I said 'Yes' to installing the MS MDAC 2.7 Basically I cannot open a DB connection with this version of Envox, it was working with 4.0.07 RC4 but not with this released version! Let me know what info you need. ( I have attached a simple application script which doesn't work ) Thanks for your help guys! Rich +44 (0) 7899 750400 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: backslash about MySQL++/Microsoft Visual C++ 6.0 (2)
Hi, I have had a similar problem... This also occurs with ' or . in any field you expect this character use: REPLACE(c:\mysql\test,\,/) Returns the string str with all all occurrences of the string from_str replaced by the string to_str: mysql select REPLACE('www.mysql.com', 'w', 'Ww'); - 'WwWwWw.mysql.com' to change '\' to '/' Rich -Original Message- From: Joerg Geistmann [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 1:59 PM To: Mysql-De; MySQL Win32; MySQL Plusplus Cc: Lazy Fox Subject: RE: backslash about MySQL++/Microsoft Visual C++ 6.0 (2) hello again! sorry, i know that i must use dopple backslash in c++ ;-) my problem is really to get backslash in database about mysql++/vc (1.7.1) also i try Query insert into blafasel values ('1', 'c:\\mysql\\test', '0'); i doesn´t work! a hint? if i do it manual about the console and i use ' in values it doesnt work too! if i use it works !!! any idea? @Darin: Use the API function mysql_escape_string to prepare the value for insertion. how can i use it? for the complette string or only for the backslash character? thanks, jörg hello there? :-) in which way can i handle backslashes in mysql++/vc? if i make a insert command like: Query insert into blafasel values ('1', 'c:\mysql\test', '0'); in c++ i get no backslash in db! if i do it manual about the console it works and i have a backslash in the db! somebody any idea? thanks, jörg - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Update
Thanks for your input! It is fixed now, by using the , instead of an and however, the thing that threw me was that it didn't complain about it! Thanks Again. Richard -Original Message- From: Chris Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 5:10 PM To: Salada, Duncan; 'Richard Morton'; MySQL List Subject: Re: Update I'd have to guess that MySQL is interpreting the set clause this way: Set events_ID = ( 512 AND ( term = 'changed' )) That is, a logical AND, so a zero result makes sense. Still, it seems a bit odd. - Original Message - From: Salada, Duncan [EMAIL PROTECTED] For one of two reasons (probably) - and I think you found a bug: 1. The syntax in your set clause is wrong. It should be set alternatepreference='C',AltContactID='1' *Notice the use of a comma instead of and* 2. The row that matched the conditions in the where clause may already be set to those values. MySQL will not update a row needlessly. I tried out your syntax on MySQL 3.23.47 (i.e. using and in the set clause) and got some unexpected results. Below is a synopsis of what happened when I ran a query with the and syntax on my machine. THE FIRST TIME update events_terms set events_ID=512 and term='changed' where ID=108; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 It says a row was changed and it was -- but not correctly! The events_ID column was set to 0 and the term column was not changed at all. That doesn't seem like the correct behavior. Then executed the query again... - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update
mysql update contact set alternatepreference='C' and AltContactID='1' where con tactid=2; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 any ideas why the UPDATE did not perform an update? Thanks Rich - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
versions
Hi, Has anybody heard how the next version of either MyODBC (3.51) or MySQL (4.0.1) are coming along and when they will be declared stable? I started developing with 4.0.1, and although I have had no failures to date, I was said that they would be declared stable in dec/jan. it is now several months later and my product is very close to some deployments. It would be quite comforting to hear that they are in the stable tree. Thanks Rich - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysqld as service
mysqld --remove use mysqld --help for more info. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:41 PM To: MySQL-Mailingliste Subject: Mysqld as service Hi How can i deinstall the mysqld as a service? Thx for help mfg Ely Van Kenobi - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: NT service problem
I am using MySQL4.02 as a service on W2Kpro. You need to install the service before you can start it. mysqld-nt --install Then try the net start, possibly after a reboot. Rich -Original Message- From: Tommy Claasens / QDC KZN [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 7:43 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: NT service problem Hi, What version of MySQL are you trying to get up and running ? If this version is the mysql max, You will have to run the standalone first in order to create the InnoDB datafiles, then it should start as a service. I have had this exact same issue and it seemed to go away once I have run the --standalone option. Hope this helps Tommy -Original Message- From: Alexander Hampel [mailto:[EMAIL PROTECTED]] Sent: Mon, 18 Mar 2002 09:38 To: [EMAIL PROTECTED] Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: C:\net start mysql System error 1069 Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex -Ursprüngliche Nachricht- Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. März 2002 08:04 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: New to MySQL - can't start server :-( Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0.1-max-nt - quick note
I have installed the above as a service. The service seems to start ok, but trying to run mysql console fails. I am running this on Win2k Pro. I have now reverted to MySQL4.0.1-NT running as a service and this works fine. Just a warning. Richard - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Selecting the row with largest number in a column
Thanks, but using SELECT MAX(age) FROM contacts only gives me the maximum age, not the person with that age. The table is tiny, changes very often and therefore indexes would be a waste of time. Thanks Richard -Original Message- From: Butch Bean [mailto:[EMAIL PROTECTED]] Sent: 25 January 2002 20:04 To: DL Neil; Richard Morton; [EMAIL PROTECTED] Subject: RE: Selecting the row with largest number in a column The fastest way I found would be: SELECT MAX(age) FROM contacts good luck bb -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 26, 2002 12:14 PM To: Richard Morton; [EMAIL PROTECTED] Subject: Re: Selecting the row with largest number in a column Hello Richard, I have a simple query, and a problem countless people must have had, I just cannot work it out at the moment, I am new to MySQL; I hope you can help. My current statement looking at the manual. SELECT * FROM contacts WHERE age=MAX(age); I started with: mysql select * from contacts where age=(select MAX(age) from contacts); In escence I am trying to ascertain the details of the person who is oldest. Any suggestions.? Use the ORDER BY clause to show the table's records in inverted age order, then require only the first row: SELECT * FROM contacts ORDER BY age DESC LIMIT 1 Regards, =dn - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selecting the row with largest number in a column
Hello, I have a simple query, and a problem countless people must have had, I just cannot work it out at the moment, I am new to MySQL; I hope you can help. My current statement looking at the manual. SELECT * FROM contacts WHERE age=MAX(age); I started with: mysql select * from contacts where age=(select MAX(age) from contacts); In escence I am trying to ascertain the details of the person who is oldest. Any suggestions.? Richard - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Nested Queries.
Hi, In alot of cases you can use the following query structure (extract from MySQL 4.0.0alpha manual)to negotiate the need for Sub-Selects. I hope this helps. -Rich 1.4.4.1 Sub-selects MySQL currently only supports sub selects of the form INSERT ... SELECT ... and REPLACE ... SELECT You can however use the function IN() in other contexts. In many cases you can rewrite the query without a sub-select: SELECT * FROM table1 WHERE id IN (SELECT id FROM table2); This can be re-written as: SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id; The queries: SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2); SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM table2 where table1.id=table2.id); Can be rewritten as: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id where table2.id IS NULL For more complicated subqueries you can often create temporary tables to hold the subquery. In some cases, however this option will not work. The most frequently encountered of these cases arises with DELETE statements, for which standard SQL does not support joins (except in sub-selects). For this situation there are two options available until subqueries are supported by MySQL. The first option is to use a procedural programming language (such as Perl or PHP) to submit a SELECT query to obtain the primary keys for the records to be deleted, and then use these values to construct the DELETE statement (DELETE FROM ... WHERE ... IN (key1, key2, ...)). The second option is to use interactive SQL to contruct a set of DELETE statements automatically, using the MySQL extension CONCAT() (in lieu of the standard || operator). For example: SELECT CONCAT('DELETE FROM tab1 WHERE pkid = ', tab1.pkid, ';') FROM tab1, tab2 WHERE tab1.col1 = tab2.col2; You can place this query in a script file and redirect input from it to the mysql command-line interpreter, piping its output back to a second instance of the interpreter: prompt mysql --skip-column-names mydb myscript.sql | mysql mydb MySQL 4.0 supports multi-table deletes that can be used to efficiently delete rows based on information from one table or even from many tables at the same time. -Original Message- From: Christian Andersson [mailto:[EMAIL PROTECTED]] Sent: 20 December 2001 19:36 To: Larry Reiter; MySQL Mailing list Subject: Re: Nested Queries. Subqueries are not (yet)working in mysql, they will be implemented in the 4.0.x or is it 4.x which hopefully will be out very soon :-) so if you are using the 3.23.xxx you have to stick with temporary tables /Christian - Original Message - From: Larry Reiter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 20, 2001 7:58 PM Subject: Nested Queries. I have constructed a query which requires a temporary table but I would rather use a nested query. In other words, I want to extract a set of data and then use that set of data as a query against some other data. Like some sort of SELECT within a SELECT. Can I do this in MySQL? Cheers, LTR -- Dr. Lawrence T. Reiter Postdoctoral Fellow Department of Biology, UCSD Bonner Hall Room 4221 9500 Gilman Drive La Jolla, CA 92093-0349 Phone: (858) 534-0442 FAX: (858) 822-2044 http://homophila.sdsc.edu email: [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php