Re: LEGAL information about MySQL.
I know the GPL and seen many commercial software using the software and/or tool under GPL. Btw, which paragraph are you referring to? Pae -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pae Choi wrote: If your software utilize the software under GPL license, you can simply add those GPL licenses as well as make a note that you are only selling, i.e. the price is only for your own software, your own software, you should be fine. Uh, no. See http://www.gnu.org/licenses/gpl.html if you're not sure what you're agreeing to when using GPL software. Just to pretect your own benefit, you can add a statment saying that all rights of GPL license reserved by them. And those are provided just for your convenience. If you are not sure exactly how the GPL works, and you have read the license terms that I've referenced above, and still want to distribute your software that uses and/or links to software licensed under the GPL, I suggest you first seek a lawyer's opinion, and have it explained to you in non-legalese. In basic terms, the GPL says if you include GPL software via use and-or linking in your software, you must distribute _your_ software under GPL terms. What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE96D8CtvXNTca6JD8RAga+AJ9I4TCWenn5VvhmXW9LyUBMza4SiQCfS7nF n7vAbQDwcBLfVb4MLnXrEck= =clzO -END PGP SIGNATURE- - 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: LEGAL information about MySQL.
mysql, sql, query What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. Your example is totally out of case. GPL says that it can freely distribute as long as the copyright is included. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Pae - 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: LEGAL information about MySQL.
- Original Message - From: Mark Matthews [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED] Cc: Tonu Samuel [EMAIL PROTECTED]; Darney Lampert [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 5:30 AM Subject: Re: LEGAL information about MySQL. If you are not sure exactly how the GPL works, and you have read the license terms that I've referenced above, and still want to distribute your software that uses and/or links to software licensed under the GPL, I suggest you first seek a lawyer's opinion, and have it explained to you in non-legalese. Are you suggesting that every program that uses MySQL has to be GPL?? I doubt that. If so, you are effectively saying, for instance, that no program written in Perl could ever be non-GPL (as all Perl scripts use/link to GPL Perl). And this is, of course, not the case. There are many commercial products out there, like Perl debuggers, for example, that are definitely NOT licenced GPL, yet still use/link to Perl. I read the MySQL Licensing Policy, and, to me, it said: If your application is NOT licensed under GPL or compatible OSI license approved by MySQL AB and you intend to distribute MySQL software (be that internally or externally), you must first obtain a commercial license to the MySQL software in question. The licence talks about DISTRIBUTING the MySQL software itself; or, as it says, More specifically: a) If you include the MySQL server in your non Open Source application, you need a commercial licence for the MySQL server, b) If you include one of the MySQL drivers in your non Open Source application (so that your application can run with MySQL), you need a commercial licence for the driver(s) in question. The MySQL drivers currently include an ODBC driver, a JDBC driver and the C language library. Except, of course, that most people do NOT distribute MySQL software, or drivers with their own programs. Besides, if I write a program in Perl, which uses MySQL, it is still Perl that distributes drivers and such. My OWN program does no such thing. My program just says: Use DBI;. - Mark - 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: [OT] LEGAL information about MySQL.
Hello. This is quickly heading towards off-topic. If you are interested in a discussion of what the GPL means, a different forum would be more adequate, I think. I do not necessarily completely agree with MySQL AB's interpretation of the GPL, but since it's their product, I am fine with it. But what you wrote is simply wrong. On Fri 2002-11-29 at 19:28:09 -0500, [EMAIL PROTECTED] wrote: If your software utilize the software under GPL license, you can simply add those GPL licenses as well as make a note that you are only selling, i.e. the price is only for your own software, your own software, you should be fine. The GPL never says anything about distributing a copy for free. I does not matter if you want $100.000 per copy. It only says that you also have to provide the source code (and that, if you offer to get the source seperately, you may not charge more than your transfer costs for the source - section 3.b). On Sat 2002-11-30 at 03:18:58 -0500, [EMAIL PROTECTED] wrote: [...] Just to pretect your own benefit, you can add a statment saying that all rights of GPL license reserved by them. And those are provided just for your convenience. What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. Your example is totally out of case. No. You said implicitly, that you can disregard the GPL by simply pointing out you only included the software for convenience. With the GPL, such a notice makes no sense. Either you comply with it, in which case you need no notice, or you do not, in which case you may not distribute the program. Such a notice does not change anything. That is what Mark tried to point out. GPL says that it can freely distribute as long as the copyright is included. That is the BSD license. The GPL indeed requires to leave the copyright notice intact, too (section 1), but also requires, that you either distribute a _verbatim_ copy (section 1) or distribute any changes or additions with the exception of mere aggregation (section 2). If a program uses MySQL in any way, you cannot claim mere aggregation, IMHO. Bye, Benjamin. -- [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
Re: [OT] LEGAL information about MySQL.
Didn't you the previous posting that contains two paragraphs from GPL? And if someone wants to sell the software that use the MySQL, then simply let them downlaod it. Then you will be out of this crap. Also, PostgreSQL will be your alternative option as well. Pae P.S.: There are many commercial software using and distributing the software/packages under GPL, why don't you sue them then. Huh, you will not getting anything other than your own expenses. Hello. This is quickly heading towards off-topic. If you are interested in a discussion of what the GPL means, a different forum would be more adequate, I think. I do not necessarily completely agree with MySQL AB's interpretation of the GPL, but since it's their product, I am fine with it. But what you wrote is simply wrong. On Fri 2002-11-29 at 19:28:09 -0500, [EMAIL PROTECTED] wrote: If your software utilize the software under GPL license, you can simply add those GPL licenses as well as make a note that you are only selling, i.e. the price is only for your own software, your own software, you should be fine. The GPL never says anything about distributing a copy for free. I does not matter if you want $100.000 per copy. It only says that you also have to provide the source code (and that, if you offer to get the source seperately, you may not charge more than your transfer costs for the source - section 3.b). On Sat 2002-11-30 at 03:18:58 -0500, [EMAIL PROTECTED] wrote: [...] Just to pretect your own benefit, you can add a statment saying that all rights of GPL license reserved by them. And those are provided just for your convenience. What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. Your example is totally out of case. No. You said implicitly, that you can disregard the GPL by simply pointing out you only included the software for convenience. With the GPL, such a notice makes no sense. Either you comply with it, in which case you need no notice, or you do not, in which case you may not distribute the program. Such a notice does not change anything. That is what Mark tried to point out. GPL says that it can freely distribute as long as the copyright is included. That is the BSD license. The GPL indeed requires to leave the copyright notice intact, too (section 1), but also requires, that you either distribute a _verbatim_ copy (section 1) or distribute any changes or additions with the exception of mere aggregation (section 2). If a program uses MySQL in any way, you cannot claim mere aggregation, IMHO. Bye, Benjamin. -- [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
Re: LEGAL information about MySQL.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pae Choi wrote: mysql, sql, query What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. Your example is totally out of case. GPL says that it can freely distribute as long as the copyright is included. I'm referring to term #2. If your software is 'forming a work based on the Program', then your software falls under the GPL. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish Yes, if you're doing something like RedHat, where you bundle a bunch of GPL software together, that's okay. However if you create some product that is built upon GPL software, but it is not GPL itself, then you most likely need to release it under GPL. We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Under the terms of the license. You can't take these paragraphs out of context. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE96KnjtvXNTca6JD8RAvtoAKC4sBneJS7/yi9BdvoutfPxJNnEowCfaviJ 085lJkmvwyqSZ0wAfjHHtlA= =Ik5X -END PGP SIGNATURE- - 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: Enforcement of foreign keys
Paul, - Original Message - From: Paul Vincent Craven [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, November 30, 2002 6:32 AM Subject: Enforcement of foreign keys Shouldn't the following be illegal? drop database registry; create database registry; use registry; CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE SET NULL ) TYPE=INNODB; insert into child values(1,1); insert into child values(1,1); insert into child values(1,1); insert into child values(1,1); MySQL is inserting these items just fine. As there are no parent records, I'm not sure why it doesn't error out. When I do a status command, the server version comes across as: Server version: 3.23.53a-Max What am I missing? probably you have not put the line innodb_data_file_path=ibdata1:10M:autoextend to the [mysqld] section of my.cnf. You have InnoDB disabled and MySQL creates your tables in the MyISAM type. You can use SHOW CREATE TABLE tablename to check what is the table type. I tested the script: heikki@hundin:~/mysql/client mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53a-max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql drop database registry; ERROR 1008: Can't drop database 'registry'. Database doesn't exist mysql create database registry; Query OK, 1 row affected (0.01 sec) mysql use registry; Database changed mysql mysql CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; Query OK, 0 rows affected (0.03 sec) mysql CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), - FOREIGN KEY (parent_id) REFERENCES parent(id) - ON DELETE SET NULL - ) TYPE=INNODB; Query OK, 0 rows affected (0.00 sec) mysql mysql insert into child values(1,1); ERROR 1216: Cannot add a child row: a foreign key constraint fails mysql insert into child values(1,1); ERROR 1216: Cannot add a child row: a foreign key constraint fails mysql insert into child values(1,1); ERROR 1216: Cannot add a child row: a foreign key constraint fails mysql insert into child values(1,1); ERROR 1216: Cannot add a child row: a foreign key constraint fails mysql mysql show create table child; +---+--- --+ | Table | Create Table | +---+--- --+ | child | CREATE TABLE `child` ( `id` int(11) default NULL, `parent_id` int(11) default NULL, KEY `par_ind` (`parent_id`), FOREIGN KEY (`parent_id`) REFERENCES `registry.parent` (`id`) ON DELETE SET NU LL ) TYPE=InnoDB | +---+--- --+ 1 row in set (0.00 sec) mysql Paul Vincent Craven Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql 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-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: getting InnoDB running on windows 2000
Bruce, - Original Message - From: OS2000 [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, November 30, 2002 9:11 AM Subject: getting InnoDB running on windows 2000 I have mysql running using its standard myisam database. The server is version 3.23.39-max, client 3.23.36 Operating system Windows 2000 5.00.2195 Service pack 2 I am using the following my.ini #This File was made using the WinMySQLadmin 1.1 Tool #11/21/2002 9:16:12 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=192.168.1.100 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # my.ini file to invoke InnoDB option for mysql # - example form page 508 of manual # innodb_data_file_path = ibdata1:50M:autoextend autoextend is only available starting from 3.23.50. Please upgrade to 3.23.53a, as your MySQL version is very old! ... Bruce A R Kuppers B.Sc.(Hons), M.Sc., Ph.D. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query Phone: (250) 656-3678 Toll Free: (866) 605-0259 E-Commerce -- Wave of the Future! Get Involved! Claim Your Future! Ask How! Visit: www.kuppersinernational.com Password: bruce - 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: [OT] LEGAL information about MySQL.
All who haven't read GPL FAQ, go and read it: http://www.fsf.org/licenses/gpl-faq.html Current discussion is covered beginning from: http://www.fsf.org/licenses/gpl-faq.html#ModifiedJustBinary http://www.fsf.org/philosophy/free-sw.html Also, discussion here reminded me MySQL vs Progress case when subsidiary of Progress named NuSphere violated MySQL AB rights in similar way as defended now by some persons. It is very similar to current discussion, so I think it is correct to include Eben Moglen's point of view here: http://www.gnu.org/press/mysql-affidavit.html Tonu - 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: Innodb Hash search
Tony, - Original Message - From: ³Â ½Äþ [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, November 29, 2002 8:08 AM Subject: Innodb Hash search hi, I now test Mysql+innodb performance, my platform is Solarise 5.8 1G RAM . I use my-huge.cnf, set the buffer_pool_size = 400M , my bench table is about 100M . I run 10 threads to Query a innodb table. Query 1* 10 thread would cost 30 second . When I look the Innodb monitor , i fund : INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 1660247, used cells 0, node heap has 1 buffer(s) 0.00 hash searches/s, 2471.41 non-hash searches/s Why the Hash search = 0? thanks! if you have many recurring index searches to the same rows, and those rows are not modified or flushed out of the buffer pool, then there should be hash searches. Difficult to say anything in this case because I do not know the query load nor EXPLAIN SELECTs. Tony chen Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql 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-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LEGAL information about MySQL.
I do not know about MySQL marketing strategies. But as far as GPL goes, it even encourge to sell. Does the GPL allow me to sell copies of the program for money? Yes, the GPL allows everyone to do this. The [1]right to sell copies is part of the definition of free software. Except in one special situation, there is no limit on what price you can charge. (The one exception is the required written offer to provide source code that must accompany binary-only release.) [1] http://www.gnu.org/philosophy/selling.html Maybe MySQL.com is concern about own profit so does other commercial vendors. They all use public-domain code in some degree. I do encourge everyone same as GPL to sell your own products without concerning about license violation. Just put the copy of GPL license, as well as source and binary combo. in the corresponding package. (I personally think that the binary will be a necesssary portion when you distribute your own products and provide the URL where they can download the source.) And you can have your own license in your products. You have all the rights for your own products same as the GPL packages do for their own. Pae -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pae Choi wrote: mysql, sql, query What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. Your example is totally out of case. GPL says that it can freely distribute as long as the copyright is included. I'm referring to term #2. If your software is 'forming a work based on the Program', then your software falls under the GPL. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish Yes, if you're doing something like RedHat, where you bundle a bunch of GPL software together, that's okay. However if you create some product that is built upon GPL software, but it is not GPL itself, then you most likely need to release it under GPL. We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Under the terms of the license. You can't take these paragraphs out of context. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE96KnjtvXNTca6JD8RAvtoAKC4sBneJS7/yi9BdvoutfPxJNnEowCfaviJ 085lJkmvwyqSZ0wAfjHHtlA= =Ik5X -END PGP SIGNATURE- - 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: [OT] LEGAL information about MySQL.
If MySQL plays so dirty, go with PostgreSQL. It's been known to be better and more acceptable in all platforms. Ex, they have triggers, etc that MySQL does not have. Pae - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 7:33 AM Subject: Re: [OT] LEGAL information about MySQL. All who haven't read GPL FAQ, go and read it: http://www.fsf.org/licenses/gpl-faq.html Current discussion is covered beginning from: http://www.fsf.org/licenses/gpl-faq.html#ModifiedJustBinary http://www.fsf.org/philosophy/free-sw.html Also, discussion here reminded me MySQL vs Progress case when subsidiary of Progress named NuSphere violated MySQL AB rights in similar way as defended now by some persons. It is very similar to current discussion, so I think it is correct to include Eben Moglen's point of view here: http://www.gnu.org/press/mysql-affidavit.html Tonu - 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: [OT] LEGAL information about MySQL.
One final thouhgt for the people who wish to sell your own products. You can distribute your own products, but let your customers download the GPL packages. In that way, you are not distributing that. And you can include your license saying that something like any utilziation of third-party packages will be solely your(i.e., your customers) responsibilities. In that way, you do not have to concern about legal obligations while at the same time you can freely sell your own products. Pae P.S.: Just for MySQL, you should appreciate those people who make their products utilizing MySQL. That will actually help your business by helping MySQL move more. - 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: [OT] LEGAL information about MySQL.
On Sat, 2002-11-30 at 14:46, Pae Choi wrote: If MySQL plays so dirty, go with PostgreSQL. It's been known to be better and more acceptable in all platforms. Ex, they have triggers, etc that MySQL does not have. FUD. I pointed to information of FSF and people not related to MySQL. Seems like you name FSF understanding about GPL dirty. I can't agree with you. Tõnu - 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: [OT] LEGAL information about MySQL.
No. You are complete WRONG. I am encouraging people who trying to sell their own products same as GPL. So I am in the same line. In addition, I am not expecting anyone has to agree with me. That includes you as well. And do not accuse me in such comment. You are starting the flame. This is a warning! Pae - Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 7:59 AM Subject: Re: [OT] LEGAL information about MySQL. On Sat, 2002-11-30 at 14:46, Pae Choi wrote: If MySQL plays so dirty, go with PostgreSQL. It's been known to be better and more acceptable in all platforms. Ex, they have triggers, etc that MySQL does not have. FUD. I pointed to information of FSF and people not related to MySQL. Seems like you name FSF understanding about GPL dirty. I can't agree with you. Tõnu - 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: [OT] LEGAL information about MySQL.
Hi. On Sat 2002-11-30 at 06:43:11 -0500, [EMAIL PROTECTED] wrote: Didn't you the previous posting that contains two paragraphs from GPL? I saw these paragraphs. How do they relate to anything of this discussion? They are taken out of context from the Preamble of the license and only state some general intention. If you want to make a point, please refer to the legal binding part. And if someone wants to sell the software that use the MySQL, then simply let them downlaod it. Then you will be out of this crap. You obviously understand the GPL differently than the FSF does (see the GPL FAQ: http://www.gnu.org/licenses/gpl-faq.html). The MySQL list is not the appropriate forum to discuss this. Also, PostgreSQL will be your alternative option as well. PostgreSQL is an interesting database, but the question was whether software using MySQL must be distributed under GPL. P.S.: There are many commercial software using and distributing the software/packages under GPL, You keep repeating that, but this proves nothing. First, doing something does not make it right. Second, there are quite some possibilities for commercial software to comply with GPL. If you want to make a point relevant to this list, cite a specific commercial software package which is using a GPL product in a similar situation as using MySQL would mean. why don't you sue them then. Because I do not own the copyright on this software? Only the copyright holder can sue. Well, as I said last time, the question is what MySQL AB thinks is legally and it is up to them to sue if they consider it appropriate. And it is ill-advised to suggest people to disregard what MySQL AB thinks the GPL means. I seriously wonder if you are just trolling. Regards, Benjamin. -- [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
Re: [OT] LEGAL information about MySQL.
Seems like all against I see are coming from MySQL team. I know MySQL is stealing a lot of code from the public domain, inclduing the SSL part. How funny! I already mentioned in the previous message. I am only encouraging the people to create more innovative works, and Open Source based product team, MySQL, is actually discouraging them. How beautiful! Once again, all product inventors, use your own license to pretoect your own rights. And let your customers download any troublesome packages if necessary. Pae - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 8:18 AM Subject: Re: [OT] LEGAL information about MySQL. Hi. On Sat 2002-11-30 at 06:43:11 -0500, [EMAIL PROTECTED] wrote: Didn't you the previous posting that contains two paragraphs from GPL? I saw these paragraphs. How do they relate to anything of this discussion? They are taken out of context from the Preamble of the license and only state some general intention. If you want to make a point, please refer to the legal binding part. And if someone wants to sell the software that use the MySQL, then simply let them downlaod it. Then you will be out of this crap. You obviously understand the GPL differently than the FSF does (see the GPL FAQ: http://www.gnu.org/licenses/gpl-faq.html). The MySQL list is not the appropriate forum to discuss this. Also, PostgreSQL will be your alternative option as well. PostgreSQL is an interesting database, but the question was whether software using MySQL must be distributed under GPL. P.S.: There are many commercial software using and distributing the software/packages under GPL, You keep repeating that, but this proves nothing. First, doing something does not make it right. Second, there are quite some possibilities for commercial software to comply with GPL. If you want to make a point relevant to this list, cite a specific commercial software package which is using a GPL product in a similar situation as using MySQL would mean. why don't you sue them then. Because I do not own the copyright on this software? Only the copyright holder can sue. Well, as I said last time, the question is what MySQL AB thinks is legally and it is up to them to sue if they consider it appropriate. And it is ill-advised to suggest people to disregard what MySQL AB thinks the GPL means. I seriously wonder if you are just trolling. Regards, Benjamin. -- [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
[FYI] All Innovative Product Inventors
The following is the copyright note for PostgreSQL. That's simple and you can avoid all the obstacles to invent your products. It's free. Pae // # PostgreSQL Copyright ## PostgreSQL Database Management System (formerly known as Postgres, then as Postgres95) Portions Copyright (c) 1996-2001, The PostgreSQL Global Development Group Portions Copyright (c) 1994, The Regents of the University of California Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN AS IS BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] [FYI] All Innovative Product Inventors
ENOUGH ALREADY!!! Either take this inane exchange to private ranting or to a more appropriate forum. DET MySQL, 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-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] LEGAL information about MySQL.
Hello. I do not intent to follow-up on the issue, as you are either trolling or clueless (and not willing to inform yourself) or both. On Sat 2002-11-30 at 08:30:52 -0500, [EMAIL PROTECTED] wrote: Seems like all against I see are coming from MySQL team. But I want to prevent a misconception: I am in no way affiliated to MySQL AB than being an user of their software. Bye, Benjamin. I know MySQL is stealing a lot of code from the public domain, inclduing the SSL part. How funny! I already mentioned in the previous message. I am only encouraging the people to create more innovative works, and Open Source based product team, MySQL, is actually discouraging them. How beautiful! [...] -- [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
Re: Date()
Is it possible for mySQL to recognize and compare dates written in this format: MM/DD/YY? =the short answer is yes and no: yes it can be done by combining various SQL/MySQL functions, but no there is no easy 'built-in' method. I know standard date format for mySQL is YYY-MM-DD, but I need to be able to =typo: -MM-DD or CCYY-MM-DD support this other format if possible. For example, I have a string of 01/30/02 and I just need to compare it to another value already in the dB, being held as a varchar with a value of 02/28/02. I need to compare these to determine if one date preceeds the other. =this is a perennial question. Check the archives for ready-solutions. =Be aware of ignorance/arrogance. Some countries use a MM/DD/YY format, others DD/MM/YY. Because of this, it might be better to avoid both (what do you think I mean if I write 01/02/03?) =From a logical point of view, the month-day-year is irrational because there is no succession of size/metric. We (humans) are used to thinking/writing in a succession, hence 1,234 is understood to be one thousand, two hundreds, thirty (three tens), and four singles/units, in descending succession of size/ascending levels of accuracy/precision. Thus day-month-year (succession from smallest to largest) seems to have some 'method' to recommend it. =The ISO (international) standard is CCYY-MM-DD. One suspects many international standards are chosen simply because the method is NOT in use anywhere and thus does not favor one 'group' over another - but in reality requires everyone to change. However... =when it comes to dates, most systems regard them as a sub-class of string/characters (cf numbers). Thus this format is really neat (or as mathematicians say elegant) because with no 'calculation' they will do exactly as you ask: 2002-11-31 2002-12-01 (qed - no functions to call, no code to write)! =Now 'all' you need to do is to decide how to convert your incoming user data from human-speak to ISO, and any output vice-versa... =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
RE: No port listed
what you can do is check if port 3306 is listening try lsof -i :3306 and about connecting to a remote mysql server via the -h switch check your firewall to see if your IP or whatever you specify is allowed to connect to the mysql server. If it is not that try and add a -u and -p switch to the command and enter the appropriate values for those switches. Hope i have understood ya problem well cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 -Original Message- From: David Hayes-Moats [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 30, 2002 5:58 AM To: [EMAIL PROTECTED] Subject: No port listed I'm running mysql 3.23.53 on Red hat linux 7.1. When i do mysqladmin version, it does not list a port and when I do mysqladmin -h 'hostname' version, it says that Host 'hostname' is not allowed to connect to this MySQL server. Any help would be appreciated David --- [This E-mail scanned for viruses by Declude Virus] - 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
backing up mySQL database ?
Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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
Select: JOIN magic?
Hello. I'm trying to select and display from a couple tables I have. I have an awards table, which has info on an award a user has earned. I've also a user table which lists all the users. What I'm trying to do is display information about an award, but can't find the right SELECT syntax to make it work the way I want. The award table has two associations to the user table: the nominee and the proposer: What I want: Award | Nominee | Proposer | Awarded on | 1| Joe Shmoe | Fred Smith | 2002-11-29 | What I get: Award | Nominee | Proposer | Awarded on | 1| Joe Shmoe | 3 | 2002-11-29 | The (simplified) tables look like this: +---+ +-+ | award | | user| +---+ +-+ | uid (int) | | uid (int PRI) | | nominee (int) | | name (varchar) | | proposer (int)| +-+ | awarded (Date)| +---+ I've been doing the following to get the basic info: SELECT * FROM award LEFT JOIN user ON award.nominee=user.uid; This gets me the info for the nominee, including name and everything else. I'd like to spare making a whole other query to the DB to get the name for the Proposer, but I can't think of a way to make it work! Any help would be appreciated. :) Regardez, Michael Carter Pilot/Programmer - 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: backing up mySQL database ?
I might be totally off track here, but a simple shell script works fine for me. /bin/sh, tar, and cron are a powerful team. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 10:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: backing up mySQL database ?
You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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
OT: what list software is this?
I'm getting ready to set up a list server, and I very much like the way this list orders topics by thread in the digest. Can someone who knows tell me what list software is being used? Or if you have an alternate suggestion that can be set up to order digests by thread, let me know? I'll be running it on UNIX (MacOS X). Since this is OT, please reply privately, and in a couple days I'll summarize if I get more that one or two replies. SQL -- : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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: backing up mySQL database ?
I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 10:23:22 -0600 You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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 _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: Select: JOIN magic?
SELECT t1.name AS Nomi, t2.name AS Propo FROM award t0 INNER JOIN user t1 ON t0.nominee=t1.uid INNER JOIN user t2 ON t0.proposer=t2.uid -Original Message- From: Michael Carter [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 30, 2002 11:51 AM To: [EMAIL PROTECTED] Subject: Select: JOIN magic? Hello. I'm trying to select and display from a couple tables I have. I have an awards table, which has info on an award a user has earned. I've also a user table which lists all the users. What I'm trying to do is display information about an award, but can't find the right SELECT syntax to make it work the way I want. The award table has two associations to the user table: the nominee and the proposer: What I want: Award | Nominee | Proposer | Awarded on | 1 | Joe Shmoe | Fred Smith | 2002-11-29 | What I get: Award | Nominee | Proposer | Awarded on | 1 | Joe Shmoe | 3 | 2002-11-29 | The (simplified) tables look like this: +---+ +-+ | award | | user| +---+ +-+ | uid (int) | | uid (int PRI) | | nominee (int) | | name (varchar) | | proposer (int)| +-+ | awarded (Date)| +---+ I've been doing the following to get the basic info: SELECT * FROM award LEFT JOIN user ON award.nominee=user.uid; This gets me the info for the nominee, including name and everything else. I'd like to spare making a whole other query to the DB to get the name for the Proposer, but I can't think of a way to make it work! Any help would be appreciated. :) Regardez, Michael Carter Pilot/Programmer - 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: Select: JOIN magic?
try aliasing your right table twice and join it both ways. something like: select award.*, a.name, b.name from ( award left join user a on award.uid = a.uid) left join user b on award.uid = b.uid if you have a windows box to use as a front end, download a copy of corereader to help you develop queries. it uses point and click, so you can quickly work them out. http://corereader.com i'm not sure about the parentheses in the above, but that's the way that corereader did it with the tables that i was experimenting on. it does seem logical, i suppose, but i'm pretty sure of the idea involved: alias the table twice so you can use it both ways. Hello. I'm trying to select and display from a couple tables I have. I have an awards table, which has info on an award a user has earned. I've also a user table which lists all the users. What I'm trying to do is display information about an award, but can't find the right SELECT syntax to make it work the way I want. The award table has two associations to the user table: the nominee and the proposer: What I want: Award | Nominee | Proposer | Awarded on | 1 | Joe Shmoe | Fred Smith | 2002-11-29 | What I get: Award | Nominee | Proposer | Awarded on | 1 | Joe Shmoe | 3 | 2002-11-29 | The (simplified) tables look like this: +---+ +-+ | award | | user| +---+ +-+ | uid (int) | | uid (int PRI) | | nominee (int) | | name (varchar) | | proposer (int)| +-+ | awarded (Date)| +---+ I've been doing the following to get the basic info: SELECT * FROM award LEFT JOIN user ON award.nominee=user.uid; This gets me the info for the nominee, including name and everything else. I'd like to spare making a whole other query to the DB to get the name for the Proposer, but I can't think of a way to make it work! Any help would be appreciated. :) Regardez, Michael Carter Pilot/Programmer -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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
Synchronizing MySQL Databases HELP NEEDED
I am currently developing a website that would use a MySQL database to store data. The company using this website would require users to be able to make changes to information on the site (LIVE - database on webserver), but they would also need to be able to make changes on their copy (which is offline). I am still a bit of a novice and need to set up this kind of arrangement. I have seen users referring to using replication, but I do not have a particular master-slave relationship plus this update needs to go both ways. Can one effect the synchronising by using PHP to send a query to the server? This site will have minimal traffic and updates will only happen about once every two days. I really hope someone can help me in this regard. Thanks!! KOBUS EHLERS Whizbiz Technologies Solutions -- [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
Re: sarnia - problem one solved
The pest from Sarnia. I think I solved the first problem, made them as a csv file, but my DOS program will only write 64 characters per line (doesn't csv have to be on one line)?? I have a few records with over 3,000 characters. Still haven't figure out how to use MySQL. Would it be better if I found a search engine that could do text files?? You people are geniuses. I wish there was a group for beginners to databases. For MySQL, this is it - for newbies and experts. Don't forget the newsgroups: comp.databases.rdb and gated.mysql.misc are good ones. Use Google groups. I strongly suggest you get well-versed in relational database design by getting yourself some good books. Here's a few that I can recommend: MySQL Paul Dubois Database design for mere mortals Michael J. Hernandez SQL queries for mere mortals Michael J. Hernandez MySQL Cookbook Paul Dubois If you get stuck with something try this list or the newsgroups. SAR0260,999 feb try13,INFORMATION SARNIA LAMBTON,,, ,,,180 North College Avenue,Sarnia,ON,N7T 7X2, (519) 332-2814,,,(519) 542-4566,, ,[EMAIL PROTECTED],http://www.informsarnialambton.org,; Ray Beggs,Chairman,,,Norm Lamoureux,Database Manager,Sue Wright, Secretary,,Assists the public in locating or obtaining information about any organization, agency, program, club, group, event, or service in Sarnia- Lambton from a computer database. Provides appropriate resources. Numbers available for out-of-town services. The database is also available on the Internet.,INFORMATION AND REFERRAL,2002-01-15, Whew, if that's one record, then you are going to need some changes. It looks as though all the information about this entity is in this one record, is that right? What you are running into is trying to convert an old flat file database (say from FoxPro) into a relational one. We've all ran into this at one time or another and it can be a real bear, but not impossible. It will require some programming to extract the individual pieces of data from the entries like the one above, and enter them into the correct tables once you have that part figured out. Using the above 'record', here's what I'm guessing the fields are: ID: SAR0260 SubID: 999 feb try13 ( ? ) OrgName: INFORMATION SARNIA LAMBTON Blank1: Blank2: Blank3: StreetAddress1: 180 North College Avenue (* you might wish to add a second street address) StreetAddress2: 2nd Floor, Selby Building City: Sarnia Province: ON PCode: N7T 7X2 VoiceAreaCode: 519 (* note that I break out the area code into a separate field) VoicePhone: 332-2814 Blank4: Blank5: FaxAreaCode: 519 FaxPhone: 542-4566 Blank6: Blank7: ContactEmail: [EMAIL PROTECTED] OrgURL: http://www.informsarnialambton.org OrgName1: Ray Beggs OrgName1Position: Chairman Blank8: Blank9: OrgName2: Norm Lamoureux OrgName2Position: Database Manager OrgName3: Sue Wright OrgName3Position: Secretary (* note that I broke this into 2 fields) Blank10: OrgDescription: Assists the public in ... OrgCategory: INFORMATION AND REFERRAL OrgEntryDate: 2002-01-15 Relational database design takes information about something and breaks it up into separate chunks, each chunk handling only one aspect of the whole ball of wax. The chunks are called tables, and in your case I can immediately see 3 or 4 tables that this data could be broken into. I'm assuming 'SAR0260' is a unique identifier for this entity, and that every entity also has a unique identifier? If so, that is an excellent start, as that will be used to tie the different records together. There seems to be several fields of contact information (names, addresses, emails, URLs, phones etc.) Look at every individual piece of information and decide exactly what it is 'about'. When you have a few collections of these, they will make up your tables. For example, I might break up the information into these tables and fields: Organizations (these fields describe only the organization) ID: SAR0260 SubID: 999 feb try13 ( ? ) OrgName: INFORMATION SARNIA LAMBTON Blank1: Blank2: Blank3: OrgEntryDate: 2002-01-15 StreetAddress1: 180 North College Avenue (* you might wish to add a second street address) StreetAddress2: 2nd Floor, Selby Building City: Sarnia Province: ON PCode: N7T 7X2 VoiceAreaCode: 519 (* note that I break out the area code into a separate field) VoicePhone: 332-2814 ( some would even break out the exchange, depending on their needs) Blank4: ( voice extension ?) Blank5: FaxAreaCode: 519 FaxPhone: 542-4566 OrgURL: http://www.informsarnialambton.org Contacts (these only describe contacts) ID: SAR0260 ContactEmail: [EMAIL PROTECTED] OrgName1: Ray Beggs OrgName1Position: Chairman Blank8: Blank9: OrgName2: Norm Lamoureux OrgName2Position: Database Manager OrgName3: Sue Wright OrgName3Position: Secretary (* note that I broke this into 2 fields) Categories ID: SAR0260 OrgCategory: INFORMATION AND REFERRAL Descriptions ( some would leave this in the Organizations table ) ID: SAR0260 OrgDescription: Assists the public in ...
MySQL Mandrake 9.0
Hi all I am trying to follow the guide HOWTO provide Microsoft Access-like functionality on Linux with open-source tools - OpenOffice.org 1.0, unixODBC, and MySQL @ http://www.unixodbc.org/doc/OOoMySQL.pdf. Got past the first few obstacles, (f)lex (b)yacc not installed. Just want to know if anybody has got OpenOffice.org 1.0, unixODBC, and MySQL to work together. Regards, Stuart --- - 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: Complex Query
this doesnt do the trick as it will produce a table containing the following columns: 1- stations.name 2- invitations.invitation_status 3- count(*) , which is the count of the number of invitations which have this status for this particular stations. this is not what i need, the output should be something like that stations.name | # of invitations | # confirmed | # cancelled | # postponed --- - station A|30|20 | 5 |5 station B|25|14 | 3 |8 --- - station C|47|29 | 6 |12 --- - to remind you about the problem: 1) stations -id -name 2) invitations -id -station_id -invitation_status (confirmed, cancelled, postponed) I need a query that generate a report about each station with ther corresponding number of invitations and a breaddown of inviations to show total number of each invitation_status - Original Message - From: Sammy Lau [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 6:01 AM Subject: Re: Complex Query try this: select a.name, b.invitation_status, count(*) from stations a, invitations b where a.id = b.station_id group by a.name, b.invitation_status - Original Message - From: Ahmed Farouk [EMAIL PROTECTED] Date: Fri, 29 Nov 2002 22:50:34 +0200 To: [EMAIL PROTECTED] Subject: Complex Query Hi, I need help with a complex query that I can't figure it out myself. Suppose that I have the following tables 1) stations -id -name 2) invitations -id -station_id -invitation_status (confirmed, cancelled, postponed) I need a query that generate a report about each station with ther corresponding number of invitations and a breaddown of inviations to show total number of each invitation_status stations.name | # of invitations | # confirmed | # cancelled | # postponed -- -- - station A|30|20 | 5 |5 -- -- - station B|25|14 | 3 |8 -- -- - station C|47|29 | 6 |12 -- -- - what query should I use to get the previous output, and if I can't get these results with a direct query how would I manage to generate this report. Thanks Ahmed - 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
Re: sarnia - problem one solved
In my previous posting, I misspelled a name: Paul Dubois should be Paul DuBois. Sorry about that - I should know by now. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - 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
Multiple Inserts and updates
Can anyone give me an example of how to insert and/or update multiple records in the same table simultaneously? I have a table with three fields; ID, PartNum, Qty. The user enters PartNum and Qty data in an unbound grid UI. When the user hits Save I'd like to build a single SQL statement from the data in the grid and have that one statement update or insert the rows in the table as necessary. I don't wanna have to build a separate SQL statement for each row of the grid (which is the only way I know how at this moment). Any help would be appreciated. - 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: backing up mySQL database ?
OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename/dbbakup/databasename.sql # Add the following to your crontab: # Make backups of databases at 4am daily 0 4 * * * /usr/local/bin/mydbbak.sh - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:11 PM Subject: Re: backing up mySQL database ? I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 10:23:22 -0600 You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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 _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
default mySQL buffer cache size
Hello, We want to know the default buffer cache size that mySQL uses with the traditional Myisam tables...that is, when it does not rely on bdb for buffer management? Do you know what that is? Actually, we would also be interested in the bdb_cache_size? Thanks, Laura - 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: Multiple indexed images or property id or both
Greetings mysql gurus! I have a client who has specified using 5 fields, each indexed with an image id. Would it be better to have a separate table using image urls, with each set of images using the corresponding property id? I'm not clear why he wants to index the image ids. Thanks. Ruusvuu - 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
fatal error
Hi all, I'm not really sure if I'm posting this to the right list or not, but I've recently installed mysql on a Linux machine in order to learn some mysql/php stuff. However, I've obviously configured something wrongly and can't work out what. The output i get when I try to do anything mysql-ish from my php code is: Fatal error: Call to undefined function: mysql_connect() in /var/www/testphp.php on line 7 To me this says 'mysql isn't installed as far as I can tell' since the connect function is the first thing it does.. but I've looked through documentation and configuration files and I'm stumped. Any help would be appreciated. Thanks, Brendan. - 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: fatal error
compile php with mysql-support, i.e. configure --with-mysql and so on. If you are on a redhat system and using the installed apache-webserver, then there should be a package php-mysql*.rpm or similar which needs to be installed. Thats not a real mysql-problem. ;-) Thomas On Sun, 1 Dec 2002 07:34:19 +1000 Brendan Mansell [EMAIL PROTECTED] wrote: Hi all, I'm not really sure if I'm posting this to the right list or not, but I've recently installed mysql on a Linux machine in order to learn some mysql/php stuff. However, I've obviously configured something wrongly and can't work out what. The output i get when I try to do anything mysql-ish from my php code is: Fatal error: Call to undefined function: mysql_connect() in /var/www/testphp.php on line 7 To me this says 'mysql isn't installed as far as I can tell' since the connect function is the first thing it does.. but I've looked through documentation and configuration files and I'm stumped. Any help would be appreciated. Thanks, Brendan. - 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
attempting to use DATE_FORMAT function in a SELECT STATEMENT
I am trying to format a TIMESTAMP column on output by using the DATE_FORMAT() function: Can someone tell me why this does not change the format - no error message - just does not do anything? $sql = SELECT * from arviContacts WHERE fid=$zz AND DATE_FORMAT(date_rec,'%Y-%m-%d %T'); I have also tried $sql = SELECT *,DATE_FORMAT(date_rec,'%Y-%m-%d %T') from arviContacts WHERE fid=$zz; and various other permutations which actually result in error messagets. I think I am missing a basic concept here TIA, Nicole Resources accessed: mysql manual, MySQL Cookbook, MySQL Reference Manual -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innob next-key locking, please help!
Hello, I have a question about Innob next-key locking. I'm using mysql 3.23.49. The following is writen on the manual: You can use the next-key locking to implement a uniqueness check in your application: if you read your data in share mode and do not see a duplicate for a row you are going to insert, then you can safely insert your row and know that the next-key lock set on the successor of your row during the read will prevent anyone meanwhile inserting a duplicate for your row. Thus the next-key locking allows you to 'lock' the non-existence of something in your table. Than I tried to simulate with two mysql monitors windows (process 1 and 2): process 1 - mysql begin; Query OK, 0 rows affected (0.00 sec) mysql select * from LOGON_Chunk where chunkId=5 LOCK IN SHARE MODE; Empty set (0.00 sec) process 2 - mysql insert into LOGON_Chunk values (5, 'chunk5', 'meaning5', NULL, NULL, NULL); I got no answer for process 2. Then I got back to process 1: process 1 - mysql insert into LOGON_Chunk values (5, 'chunk5', 'meaning5', NULL, NULL, NULL); ERROR 1213: Deadlock found when trying to get lock; Try restarting transaction and on process 2 I got: Query OK, 1 row affected (12.83 sec) Is that correct? The manual says I can lock the non-existence of something but I couldn't. Can anyone help me? What am I doing wrong? I also tried selecting for update and got the same result. Thanks, Joao. sql, 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-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Innob next-key locking, please help!
Joao, - Original Message - From: João Borsoi [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, December 01, 2002 1:20 AM Subject: Innob next-key locking, please help! Hello, I have a question about Innob next-key locking. I'm using mysql 3.23.49. The following is writen on the manual: You can use the next-key locking to implement a uniqueness check in your application: if you read your data in share mode and do not see a duplicate for a row you are going to insert, then you can safely insert your row and know that the next-key lock set on the successor of your row during the read will prevent anyone meanwhile inserting a duplicate for your row. Thus the next-key locking allows you to 'lock' the non-existence of something in your table. Than I tried to simulate with two mysql monitors windows (process 1 and 2): process 1 - mysql begin; Query OK, 0 rows affected (0.00 sec) mysql select * from LOGON_Chunk where chunkId=5 LOCK IN SHARE MODE; Empty set (0.00 sec) process 2 - mysql insert into LOGON_Chunk values (5, 'chunk5', 'meaning5', NULL, NULL, NULL); I got no answer for process 2. Then I got back to process 1: process 1 - mysql insert into LOGON_Chunk values (5, 'chunk5', 'meaning5', NULL, NULL, NULL); ERROR 1213: Deadlock found when trying to get lock; Try restarting transaction and on process 2 I got: Query OK, 1 row affected (12.83 sec) Is that correct? The manual says I can lock the non-existence of something but I couldn't. Can anyone help me? What am I doing wrong? I also tried selecting for update and got the same result. please test 4.0.5a. MySQL/InnoDB-4.0.3, August 28, 2002 Removed unnecessary deadlocks when inserts have to wait for a locking read, update, or delete to release its next-key lock. ... Thanks, Joao. sql, query. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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
mysql join problem (bug?)
Hi all, I found this join problem using mysql 3.23.53-max-nt (on WinXP). It works fine on MySQL 3.23.52-log (on Linux). Could someone please confirm that it is a bug? Or enlighten me on writing the correct sql? I have a table and data as shown in the script below. CREATE TABLE test ( f1 int(11) NOT NULL default '0', f2 int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Dumping data for table `test` # INSERT INTO test VALUES (1, 2); INSERT INTO test VALUES (1, 4); Then I do a join with this query: SELECT t1.*, t2.* from test as t1, test as t2 where t1.f1 = t2.f1 Unfortuantley, I got this output. f1 f2 f1 f2 1 2 1 2 1 2 1 2 1 4 1 4 1 4 1 4 I would expect the output like this (which I get on Linux using MySQL 3.23.52-log). I also get this using other DB (e.g. Access). f1 f2 f1 f2 1 2 1 2 1 4 1 2 1 2 1 4 1 4 1 4 Does anyone else experience the same problem? Thanks. Haksun
OT: what list software is this?
Okay, okay -- before anyone else bothers to email me, the answer is right in the header. Doh! :-) I really did glance at the headers, but it slipped by me! SQL -- : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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
Help Transferring Data from MS Access to mySQL
I'm very new to mysql and haven't got much of a background in databases generally, so thanks in advance to any who have the patience to deal with my question. I'm trying to get data from ms access 97 to mysql by exporting to a text file then using the load data command to import it. The data in one of the fields contains all sorts of text, punctuation and formatting characters, even some html tags and linefeed characters (there's all kinds of crap in there). On export, ms access will put quotes around my large text field. I was hoping that mysql would accept everything inbetween the quotes as the field value, but it doesn't...it starts a new record with each linefeed character it encounters. I believe I read that I can change the record delimiter mysql uses from a linefeed to something else, but I don't seem to be able to do the same with the export in ms access (it will let me change the field delimiter but not the record delimiter). I've pretty much resigned myself to writing some kind of script to manually export these records using some kind of unique record delimiter, but I thought I'd check and see if anyone has any other better ideas on how to get my data transferred. Thanks - 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: Help Transferring Data from MS Access to mySQL
At 04:12 PM 11/30/02, you wrote: I've pretty much resigned myself to writing some kind of script to manually export these records using some kind of unique record delimiter, but I thought I'd check and see if anyone has any other better ideas on how to get my data transferred. You'll find all kinds of converters (including Access to MySQL) at: http://www.mysql.com/doc/en/SEC669.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
Re: sarnia - problem one solved
This is the list of fields, originally there are over 80 fields, but I cut it down. Go to our website to see what I am doing right now, making them .htm pages so EXCITE can search on them. I put all 800 entries into ASK SAM and tried to export as a csv file, but won't do over one line per field. Thanks Norm Field name ..:no Field name ..:comments Field name ..:ORG_LEVEL_1 Field name ..:STREET_BUILDING Field name ..:STREET_ADDRESS Field name ..:STREET_CITY Field name ..:MAIL_CARE_OF Field name ..:BUILDING Field name ..:ADDRESS Field name ..:CITY Field name ..:PROVINCE Field name ..:POSTAL_CODE Field name ..:OFFICE_PHONE Field name ..:TDD_PHONE Field name ..:TOLL_FREE_PHONE Field name ..:FAX Field name ..:CRISIS_PHONE Field name ..:AFTER_HRS_PHONE Field name ..:e_mail Field name ..:www_address Field name ..:CONTACT_NAME_1 Field name ..:CONTACT_TITLE_1 Field name ..:CONTACT_ORG_1 Field name ..:CONTACT_PHONE_1 Field name ..:CONTACT_NAME_2 Field name ..:CONTACT_TITLE_2 Field name ..:CONTACT_ORG_2 Field name ..:CONTACT_PHONE_2 Field name ..:DESCRIPTION Field name ..:subjects Field name ..:UPDATE_DATE Whew, if that's one record, then you are going to need some changes. It looks as though all the information about this entity is in this one record, is that right? What you are running into is trying to convert an old flat file database (say from FoxPro) into a relational one. We've all ran into this at one time or another and it can be a real bear, but not impossible. It will require some programming to extract the individual pieces of data from the entries like the one above, and enter them into the correct tables once you have that part figured out. Using the above 'record', here's what I'm guessing the fields are: ID: SAR0260 SubID: 999 feb try13 ( ? ) OrgName: INFORMATION SARNIA LAMBTON Blank1: Blank2: Blank3: StreetAddress1: 180 North College Avenue (* you might wish to add a second street address) StreetAddress2: 2nd Floor, Selby Building City: Sarnia Province: ON PCode: N7T 7X2 VoiceAreaCode: 519 (* note that I break out the area code into a separate field) VoicePhone: 332-2814 Blank4: Blank5: FaxAreaCode: 519 FaxPhone: 542-4566 Blank6: Blank7: ContactEmail: [EMAIL PROTECTED] OrgURL: http://www.informsarnialambton.org OrgName1: Ray Beggs OrgName1Position: Chairman Blank8: Blank9: OrgName2: Norm Lamoureux OrgName2Position: Database Manager OrgName3: Sue Wright OrgName3Position: Secretary (* note that I broke this into 2 fields) Blank10: OrgDescription: Assists the public in ... OrgCategory: INFORMATION AND REFERRAL OrgEntryDate: 2002-01-15 Relational database design takes information about something and breaks it up into separate chunks, each chunk handling only one aspect of the whole ball of wax. The chunks are called tables, and in your case I can immediately see 3 or 4 tables that this data could be broken into. I'm assuming 'SAR0260' is a unique identifier for this entity, and that every entity also has a unique identifier? If so, that is an excellent start, as that will be used to tie the different records together. There seems to be several fields of contact information (names, addresses, emails, URLs, phones etc.) Look at every individual piece of information and decide exactly what it is 'about'. When you have a few collections of these, they will make up your tables. For example, I might break up the information into these tables and fields: Organizations (these fields describe only the organization) ID: SAR0260 SubID: 999 feb try13 ( ? ) OrgName: INFORMATION SARNIA LAMBTON Blank1: Blank2: Blank3: OrgEntryDate: 2002-01-15 StreetAddress1: 180 North College Avenue (* you might wish to add a second street address) StreetAddress2: 2nd Floor, Selby Building City: Sarnia Province: ON PCode: N7T 7X2
Re: attempting to use DATE_FORMAT function in a SELECT STATEMENT
Thanks very much Robert, that worked. I was surprised at the effect of the '*'. Best regards, Nicole Robert Kostko wrote: Hi, Nicole IMHO after * all additional field statements DATE_FORMAT(date_rec,'%Y-%m-%d %T') are ignored. Try to list all neccessary fields after SELECT and give an alias to DATE_FORMAT(date_rec,'%Y-%m-%d %T') for example: SELECT [fld_1], [fld_2], ...,[fld_n], DATE_FORMAT(date_rec,'%Y-%m-%d %T') as nice_date FROM arviContacts WHERE fid=$zz; After that You'll have $row[nice_date] when You fetch mysql result Regards, Robert - Original Message - From: Nicole Lallande [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 11:38 PM Subject: attempting to use DATE_FORMAT function in a SELECT STATEMENT I am trying to format a TIMESTAMP column on output by using the DATE_FORMAT() function: Can someone tell me why this does not change the format - no error message - just does not do anything? $sql = SELECT * from arviContacts WHERE fid=$zz AND DATE_FORMAT(date_rec,'%Y-%m-%d %T'); I have also tried $sql = SELECT *,DATE_FORMAT(date_rec,'%Y-%m-%d %T') from arviContacts WHERE fid=$zz; and various other permutations which actually result in error messagets. I think I am missing a basic concept here TIA, Nicole Resources accessed: mysql manual, MySQL Cookbook, MySQL Reference Manual -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Nicole Lallande [EMAIL PROTECTED] 760.753.6766 - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.5(a) is released
Stefan, Lenz, et al., May I suggest, for backward compatibility, obsolescing the variable (NOOP) instead of removing it. Happy Holidays. :-) ==_-+- Steve - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Lenz Grimmer [EMAIL PROTECTED]; MySQL announce list [EMAIL PROTECTED] Cc: MySQL mailing list [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 4:32 PM Subject: Re: MySQL 4.0.5(a) is released Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Lenz Grimmer [EMAIL PROTECTED] To: MySQL announce list [EMAIL PROTECTED] Cc: MySQL mailing list [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 10:41 PM Subject: MySQL 4.0.5(a) is released -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.5, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is a new beta development release, adding new features and fixing recently discovered bugs. This will be the last release labelled as beta - the upcoming MySQL 4.0.6 will be labelled gamma, which emphasizes the fact that the MySQL 4.0 code base has further stabilized and is becoming ready for productive use. To avoid confusion between the product names of the GPL and non-GPL (commercial) binaries, MySQL AB has now further refined the new naming scheme. Starting with MySQL 4.0.5 and onwards, the following binaries will be available: MySQL Standard (GPL) This is the recommended binary for most users that want to use MySQL under the terms of the GNU General Public License (GPL). It includes the InnoDB Storage Engine and all default features that are considered stable and useful enough for general usage. MySQL Max (GPL) This is an enhanced version of the Standard GPL package. In addition to the InnoDB Storage Engine, it includes additional features like the Berkeley DB (BDB) Storage Engine (certain platforms only) as well as other additional features that are either not exhaustively tested yet or not required for most users, e.g. OpenSSL (where available), User defined functions (UDFs), or BIG_TABLE support. When these features have matured and proven to be stable enough, they will be part of future versions of the Standard binaries. Please note, that not all of these features are included in all binaries. MySQL Classic (Commercial License) Similar to MySQL Standard, but *without* InnoDB and only available as a commercial licensed version. MySQL Pro (Commercial License) Similar to MySQL Standard (*including* InnoDB), but only available as a commercial licensed version. - From the 4.0.5 ChangeLog: Functionality added or changed: * Changed handling of last argument in `WEEK()' so that one can get week number according to the ISO 8601 specification. (Old code should still work). * Fixed that `INSERT DELAY' threads doesn't hang on `Waiting for INSERT' when one sends a `SIGHUP' to `mysqld'. * Change that `AND' works according to SQL ANSI99 when it comes to `NULL' handling. In practice, this only affects queries where you do something like `WHERE ... NOT (NULL AND 0)'. * `mysqld' will now resolve `basedir' to its full path (with `realpath()'). This enables one to use relative symlinks to the MySQL installation directory. This will however cause `show variables' to report different directories on systems where there is a symbolic link in the path. * Fixed that MySQL will not use an index scan on an index that has been disabled with `IGNORE INDEX' or `USE INDEX'. * Added `--use-frm' option to `mysqlcheck'. When used with `REPAIR', it gets the table structure from the `.frm' file, so the table can be repaired even if the `.MYI' header is corrupted. * Fixed bug in `MAX()' optimization when used with `JOIN' and `ON' expressions. * Added support for reading of MySQL 4.1 table definition files. * `BETWEEN' behaviour changed (*note Comparison Operators::). Now `datetime_col BETWEEN timestamp AND timespamp' should work as expected. * One can create `TEMPORARY' `MERGE' tables now. * `DELETE FROM myisam_table' now shrinks not only the `.MYD' file but also the `.MYI' file. * When one uses the `--open-files-limit=#' option to `mysqld_safe' it's now passed on to
Re: MySQL 4.0.5(a) is released
Stefan, Lenz, et al., May I suggest, for backward compatibility, obsolescing the 'safe_show_database' variable (a NOOP) instead of removing it? Also, IMPO, it is better practice to grant each customer's user access to their own database(s). Each customer's rights can then be specifically managed by security administrators and/or automagically via script, as apposed to relying on the database to do the job. Happy Holidays. :-) ==_-+- Steve - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Lenz Grimmer [EMAIL PROTECTED]; MySQL announce list [EMAIL PROTECTED] Cc: MySQL mailing list [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 4:32 PM Subject: Re: MySQL 4.0.5(a) is released Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Lenz Grimmer [EMAIL PROTECTED] To: MySQL announce list [EMAIL PROTECTED] Cc: MySQL mailing list [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 10:41 PM Subject: MySQL 4.0.5(a) is released -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.5, a new version of the world's most popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. This is a new beta development release, adding new features and fixing recently discovered bugs. This will be the last release labelled as beta - the upcoming MySQL 4.0.6 will be labelled gamma, which emphasizes the fact that the MySQL 4.0 code base has further stabilized and is becoming ready for productive use. To avoid confusion between the product names of the GPL and non-GPL (commercial) binaries, MySQL AB has now further refined the new naming scheme. Starting with MySQL 4.0.5 and onwards, the following binaries will be available: MySQL Standard (GPL) This is the recommended binary for most users that want to use MySQL under the terms of the GNU General Public License (GPL). It includes the InnoDB Storage Engine and all default features that are considered stable and useful enough for general usage. MySQL Max (GPL) This is an enhanced version of the Standard GPL package. In addition to the InnoDB Storage Engine, it includes additional features like the Berkeley DB (BDB) Storage Engine (certain platforms only) as well as other additional features that are either not exhaustively tested yet or not required for most users, e.g. OpenSSL (where available), User defined functions (UDFs), or BIG_TABLE support. When these features have matured and proven to be stable enough, they will be part of future versions of the Standard binaries. Please note, that not all of these features are included in all binaries. MySQL Classic (Commercial License) Similar to MySQL Standard, but *without* InnoDB and only available as a commercial licensed version. MySQL Pro (Commercial License) Similar to MySQL Standard (*including* InnoDB), but only available as a commercial licensed version. - From the 4.0.5 ChangeLog: Functionality added or changed: * Changed handling of last argument in `WEEK()' so that one can get week number according to the ISO 8601 specification. (Old code should still work). * Fixed that `INSERT DELAY' threads doesn't hang on `Waiting for INSERT' when one sends a `SIGHUP' to `mysqld'. * Change that `AND' works according to SQL ANSI99 when it comes to `NULL' handling. In practice, this only affects queries where you do something like `WHERE ... NOT (NULL AND 0)'. * `mysqld' will now resolve `basedir' to its full path (with `realpath()'). This enables one to use relative symlinks to the MySQL installation directory. This will however cause `show variables' to report different directories on systems where there is a symbolic link in the path. * Fixed that MySQL will not use an index scan on an index that has been disabled with `IGNORE INDEX' or `USE INDEX'. * Added `--use-frm' option to `mysqlcheck'. When used with `REPAIR', it gets the table structure from the `.frm' file, so the table can be repaired even if the `.MYI' header is corrupted. * Fixed bug in `MAX()' optimization when used with `JOIN' and `ON' expressions. * Added support for reading of MySQL 4.1 table definition files. * `BETWEEN' behaviour changed (*note Comparison Operators::). Now `datetime_col BETWEEN timestamp
creating related tables
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I would like to create a couple of related tables (just for starters) but I can't figure out how to do it; there are lots of CREATE TABLE examples in the mysql manual but nothing that shows related columns. For instance, I'd have a client table with name, address, etcetc, and client ID columns. Then I'd also have a room table with room listings, capacities, locations, etcetc, and room ID columns. Add to that a classes table showing info about classes offerred and, of course, a class ID column. Finally maybe an instructor table with the same sort of columns. Now I want a schedule table that will instantiate a course and track what clients are in it, using the client ID from the client table and the class ID from the class table and the room and the instructor and such. How do I specify a foreign key or a related column or a whatever when I create this table? TIA HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE96XHRGb7uCXufRwARAiB2AJ49zRrJWsTF/eMwwoC8I4Ao3wk9SQCfdDXY AVkqYPa71Hvj+ZPYsNyCJ5g= =zryv -END PGP SIGNATURE- - 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
mysql not working behind linksys router
Hi, apologies upfront since this is not directly a mysql question. I have a mysql host sitting behind a linksys router/wireless ap. The mysql host is configured as a DMZ host in the router. All web/ftp other connections are working fine, however mysql connection from outside the network is not working. Not only that if there is any inbound connection mysql crashes hard and does not accept any connection or process anymore queries. Any idea what could be the possible cause? Does mysql need other ports ope besides 3306 ? Other DB (postgres) and services work fine. Although I had to do some tricky stuff for the same host before I could get proFTPD working for passive ftp. Thanks Mir - 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
mi_test_all error help
I am using BSDI 4.3, and downloaded MySql source code 3.23.53. After untarring it, it passed ./configure --prefix=/usr/local/mysql. But when I run make, finally it says make: don't know how to make mi_test_all. Stop *** Error code 1 Your help will be appreciated Shawn Xu __ Post your free ad now! http://personals.yahoo.ca - 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
Simple Linux RPM error question
I'm attempting to install the following Linux RPMs: MySQL-3.23.53a-1.i386.rpmMySQL-client-3.23.53a-1.i386.rpm MySQL-Max-3.23.53a-1.i386.rpmMySQL-devel-3.23.53a-1.i386.rpm MySQL-bench-3.23.53a-1.i386.rpm MySQL-shared-3.23.53a-1.i386.rpm When I do so I get the following error: rpm -ivh MySQL*3.23.53a-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.53a-1 The only Perl DBI module on the MySQL website is the DBI-1.18.tar.gz tarball. Where is said RPM located? Thanks for any pointers to the location. MB -- e-mail: [EMAIL PROTECTED] /~\ The ASCII \ / Ribbon Campaign X Against Visit - URL: http://www.vidiot.com// \ HTML Email - 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: Fulltext index on a mediumblob column?
Thanks Paul - it worked perfectly. And for anyone else listening, modifying the table did not adversely affect the data (although I did back up just in case). --Aaron On 11/1/02 7:34 PM, Paul DuBois [EMAIL PROTECTED] wrote: At 15:25 -0600 11/1/02, Aaron Merrick wrote: Ladies Gentlemen, The manual says FULLTEXT indexes are used with MyISAM tables and can be created from VARCHAR and TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX. Believe the manual. I get the following error when I try to add a full text index for a mediumblob column - but not when I add it to any other columns - mysql alter table knowledge add fulltext (k_body); ERROR 1005: Can't create table './preferred/#sql-c2_44.frm' (errno: 140) If it is true I can't use full text on a medium blob - can I do it on a mediumtext field? It's true. Yes, you can use mediumtext. More precisely, you can use: CHAR and VARCHAR, if they're not declared as BINARY, and any of the TEXT types. You cannot use binary string columns. Is there a way to convert a column from one to the other? Yes: ALTER TABLE tbl_name MODIFY col_name MEDIUMTEXT; Thanks, Aaron myql - 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