Re: [OT] LEGAL information about MySQL.
Look! I already unsubscribed this. Do you understand what that mean? I have no interest to dealing with MySQL and have no time for this. You must understand that this thread was started from someone who were interested to sell his/her product that utilize MySQL. And I was trying to help both sides. One who is creating an innovative products as well as MySQL. Do you know how both sides get benefits? Actually, MySQL should appreciate them. Those folks actually help your business by moving your products. Also, you MUST understand that if one product provides the persistence service that only comes with JDBC/JDO/or similar functionality. So the product can adopt any back-end DBMS, for example, and leaving the choice of DBMS to thier customers. They will more than likely go with the *reliable* DBMS. In case the customers somehow select MySQL for thier DBMS solution, to wit, if they download and use it. You are out of luck! 1) The Product innovation group did not distributed; Their customers download it. 2) In their own license, they can declare own rights. Still want to chase them, it's your choice(I don't know what you are going to after for, but it will be your choice as well to spend the time and your own expenses.) Last, by no means least, put me out of this. I am no longer interesting to waste my time with MySQL. I already seen enough and got sense of attitudes from MySQL. Pae P.S.: If your intention was for commercializtion from the beginning, you should started with .com, not .org -- I can see your sly marketing strategy. - 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 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: [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.
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.
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.
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: LEGAL information about MySQL.
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. 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. Pae On Fri, 2002-11-29 at 14:59, Darney Lampert wrote: Hi, I'm beginner in maillist and my english is limited.. I want know about LEGAL MySQL software information. On www.mysql.com page, in download section I read that: You need to purchase commercial non-GPL MySQL licenses: If you distribute MySQL Software with your non open source software, If you want warranty from MySQL AB for the MySQL software, If you want to support MySQL development. distribute MySQL Software with means that my application (non open source) can use mysql if I not distribute MySQL with my application? In very brief: GPL licence protects original author of software from competing against own software. For example if somebody integrates MySQL into their software and starts to sell it, this is not allowed because then MySQL authors have do not have access to parts added to MySQL. You can integrate non-GPL software with GPL one only if: You never distribute it or You provide source code under GPL back to community. On all other cases you do not have this right under GPL licence. If you still want to integrate GPL and non-GPL software you need ask authors permission to use software under different conditions. In MySQL this means you have to pay for it and this seems fair to me. 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: MySQL secure access
If I am your customer and the data related to my web contents and/or services stored(this is more than likely if the hosting service is used) in the database at your site, I would definitely claim that the access to data will be appropriate. Ex, You have Web services using a hosting service. And the Web services collect the customers' info. Shouldn't you need to access the database which stored all your customers' info. In addition, it's a trust-based relationship. But the hosting service should not have access to the customers' data even though the customers' databases reside at the hosting site. That's more appropriate in the business process and prevent the possible legal matter. Because the customers can simply claim that It's my data and not yours! The right practice will be to seperate your company's database and customer's databases on different hosts. And your company can provide the proper access to your customers to their databases. Otherwise, they will move on to somewhere else who can do for their needs. Pae Hi, all, I am now using MySQL with MySQL Front, where i knew that it can access ALL the databases that store remotely. My company is doing hosting services. And we are using MySQL as our database system. Currently, we have our own databases + customer's databases store in our hosting server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. regards, alice /--- \ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - 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: Application level security
I've done a similar work in 1997 for one of my clients. The password method will be just part of the security system. But you may want to consider to implement the RBAC in the database. In that way, the users whether they are applications, e.g., business objects, DB interactive tool by human user, or so, will only access to the subset of database based on thier privileges by using ACLs which are also based on the defined security policy in the database. In addition, you may want to use the Asymmetric encryption for some data that needs to be considered a higher security. Pae Hi All, I'm writing a application that needs row level security in it so that only certain users can view/change etc. certain records. I know that MySQL currently does not have row level security, and when I've asked this list before I've been given some helpfull suggestions (although none of them would actually work for me). So I've decided that the only way to go is to put the security logic into the application I am building. This works fine for my application, but means that if anyone connects directly to the server using the MySQL client etc, then they'll be able to see/update everything - making it a pretty weak security system. I've had two thoughts about this, but am willing to hear of any other thoughts people might have. One that I could do right now is to get my program to add something to the password of every user (users are created using the program and passwords can be changed using it too). This way if they try to connect to the server directly they won't have the extra bit on their passwords and it won't let them connect. The program could take care of adding this extra bit each time anything password related was needed so it shouldn't be a problem in this respect, however if anyone discovered the extra bit then it would be imposible to change the extra bit without giving everyone new passwords (which would be a real pain). A second way would be if there was like an application password in the security area that could be set and would be needed for connection - sort of like the ssl extra stuff that's been added recently. The downside of this is it isn't currently there and I'd need to convince someone at MySQL that it was worth adding and then wait for it to be added, the upside is that it would be easier to change if the application password was discovered. I've looked a little at the ssl/encryption stuff to see if I could use that but I don't think it can really help me achieve what I'm trying to achieve but if someone thinks it can I'd love to hear how. If anyone has any other ideas, can see problems that I haven't seen in the above ideas then I'd appreciate knowing. Are there any others having this problem (or is it just me!)? Thanks for your thoughts, cheers, noel - 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
[MySQL v3.23.53a] BLOB Data and Table Size
I have two tables containing a BLOB cloumn as; -- supposed to be able to handle up to about 16MB CRETAE TABLE gallery1 ( idINTEGER, titleVARCHAR(255), mediumimageMEDIUMBLOB ); -- supposed to be able to handle up to about 4GB CRETAE TABLE gallery2 ( idINTEGER, titleVARCHAR(255), largeimageLONGBLOB ); Both table show the size about 48KB initially. And I added a 16MB(about 7,863KB) image into the table, gallery1 and a 4GB(about 11,620KB) into the table, gallery2, respectively. The size of gallery1, i,e, gallery1.db, shows 8,232KB and the size of gallery2, i.e., gallery2.db, shows 11,712KB. Each table contains only one entry. And I deleted both entries from two tables. So both tables contain no entry. However, the size of tables remain same as after insertion made. Q: How come the size of table does not decrease after deletion? Thank you. And regards, Pae P.S.: MySQL, SQL, and Query(to clarify that it's not spam nor OT). - 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: [MySQL v3.23.53a] BLOB Data and Table Size
First of all, thanks for your reply as well as a pointer to the Doc. I tried the OPTIMIZE command as follows: mysql optimize table gallery; mysql optimize table gallery2; Both does not contain any entry since I deleted the BLOB data. But the size of tables, gallery.db and gallery2.db does not decresed. It remains as it was. Any comments? Thanks. Pae P.S.: The table is created with type=bdb option as: CREATE TABLE ... TYPE=BDB; On 26 Nov 2002, at 8:52, Pae Choi wrote: Q: How come the size of table does not decrease after deletion? MySQL will reuse that space when you insert new records. To recover the space, you need to optimize the table: http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html P.S.: MySQL, SQL, and Query(to clarify that it's not spam nor OT). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - 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: SQL Row Counting in MySQL
There is SQL function called COUNT. Check it out and see of that helps you. Pae Hi All, Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10 (where rownum is not a specific column, just a count of how many rows have been returned) But MySQL doesn't like this. Anyone know the correct way to approach this?? Cheers Tom - 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: [MySQL v3.23.53a] BLOB Data and Table Size
Paul, It really did the trick. Thanks. Regards, Pae - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED]; Keith C. Ivey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 10:59 AM Subject: Re: [MySQL v3.23.53a] BLOB Data and Table Size At 10:36 -0800 11/26/02, Pae Choi wrote: First of all, thanks for your reply as well as a pointer to the Doc. I tried the OPTIMIZE command as follows: mysql optimize table gallery; mysql optimize table gallery2; Both does not contain any entry since I deleted the BLOB data. But the size of tables, gallery.db and gallery2.db does not decresed. It remains as it was. Any comments? Thanks. Pae P.S.: The table is created with type=bdb option as: CREATE TABLE ... TYPE=BDB; OPTIMIZE performs defragmentation only for MyISAM tables. You can shrink your tables by dumping and reloading them: mysqldump --opt db_name gallery gallery2 dump.sql mysql db_name dump.sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL v3.23.52-MAX on Win32
I have created a test table for different data types as follows: CREATE TABLE AllDataTypes ( id INTEGER, col_bit BIT, col_boolean BOOL, col_tinyint TINYINT, col_smallint SMALLINT, col_int INT, col_integer INTEGER, col_bigint BIGINT, col_float FLOAT, col_double DOUBLE, col_char CHAR, col_char1 CHAR(1), col_char255 CHAR(255), col_varchar1 VARCHAR(1), col_varchar255 VARCHAR(255), col_decimal DECIMAL, col_decimal2 DECIMAL(10,2), col_numeric NUMERIC, col_numeric2 NUMERIC(10,2), col_date DATE, col_time TIME, col_timestamp TIMESTAMP, col_datetime DATETIME, col_binary MEDIUMBLOB, col_varbinary MEDIUMBLOB, col_longvarbinary MEDIUMBLOB, col_blob MEDIUMBLOB, col_clob TEXT, col_longvarchar MEDIUMTEXT ); When I execute a query as follows: INSERT INTO AllDataTypes (id, col_date) VALUES (1, '2002-11-23'); The table contains the right values for 'id' and 'col_date' as well as all other columns with 'NULL', except a column, 'col_timestamp'. The column, 'col_timestamp' contains a value, '2002112412'. So I tested with more queries such as: INSERT INTO AllDataTypes (id) VALUES (2); INSERT INTO AllDataTypes (id, col_date, col_time) VALUES (1, '2002-11-23', '23:50:12'); But the results was same that the column, 'col_timestamp' is containing the values for above two entries. Isn't it suppose to be 'NULL'? Thanks 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: MySQL v3.23.52-MAX on Win32
Thanks. That explains it. Pae The first column of type timestamp will always be initialized with the current timestamp. See the fourth and fifth paragraphs of the following link. http://www.mysql.com/doc/en/DATETIME.html Isn't it suppose to be 'NULL'? Thanks -- Linux: Because rebooting is for adding hardware. Fingerprint = CE24 057D 1E88 A253 3196 89DB 9FF0 9EF0 2F70 8BE8 BE8 - 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
[Feature or Bug] Data Types: DECIMAL and DOUBLE
Say we create a table as follows: CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double DOUBLE(20,2)); And we insert 6 rows as follows: INSERT INTO account (id, balance, col_double) VALUES (1, 12345678901234567890.56, 12345678901234567890.56); INSERT INTO account (id, balance, col_double) VALUES (2, 1234567890123456789.56, 1234567890123456789.56); INSERT INTO account (id, balance, col_double) VALUES (3, 123456789012345678.56, 123456789012345678.56); INSERT INTO account (id, balance, col_double) VALUES (4, 12345678901234567.56, 12345678901234567.56); INSERT INTO account (id, balance, col_double) VALUES (5, 1234567890123456.56, 1234567890123456.56); INSERT INTO account (id, balance, col_double) VALUES (6, 123456789012345.56, 123456789012345.56); We I have from the table by executing a query as follows; SELECT * FROM account; ResultSet: === idbalancecol_double 1.9912345678901234567000.00 212345678901234567800.0012345678901234567800.00 3 123456789012345680.00 123456789012345660.00 4 12345678901234568.0012345678901234568.00 5 1234567890123456.50 1234567890123456.50 6123456789012345.56 123456789012345.56== Only correct one Is this a feature or bug? Any comments? Thanks you. Regards, Pae Under the section, 6.2 Column Types in the MySQL Documentation stated as follows: 6.2 Column Types snip/ DOUBLE[(M,D)] [ZEROFILL] A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. The M is the display width and D is the number of decimals. DOUBLE without an argument or FLOAT(X) where 25 = X = 53 stands for a double-precision floating-point number. DECIMAL[(M[,D])] [ZEROFILL] An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column: ``unpacked'' means the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these are reserved). If D is 0, values will have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE, but the actual range for a given DECIMAL column may be constrained by the choice of M and D. If D is left out it's set to 0. If M is left out it's set to 10. Note that in MySQL Version 3.22 the M argument had to includes the space needed for the sign and the decimal point. - 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: mysql return days in month?
Not all Feb. has 28 days. It depends on whether it is a lunar year or not. So Some Feb. will have 28 days and some have 29 days. Pae - Original Message - From: Andrew Braithwaite [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'Roger Baklund' [EMAIL PROTECTED] Sent: Monday, November 18, 2002 7:52 AM Subject: RE: mysql return days in month? Thanks for solving this all, I have do something ugly because I only have the -mm (3rd party DB) which ends up like this: Mysql select dayofmonth((concat('2004-02','-01') + interval 1 month) - interval 1 day); Urrggg ;) Still, much more graceful (and more future proof) than what I just came up with: select case when (right('2002-04',2) = '02') then 28 when ('%09%04%06%11%' regexp right('2002-04',2)) then 30 else 31 end as daysinmonth; lol Thanks Andrew Sql,query * Roger Baklund You can start with the first day of the _next_ month, and go 1 day back...: mysql select dayofmonth('2002-11-01' - interval 1 day); - 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: [Feature or Bug] Data Types: DECIMAL and DOUBLE
No execuse! My appologies for the cross posting. Your advice is well accepted. Also thank you for your explaination regarding on my inquiry as well. Regards, Pae - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 18, 2002 11:49 AM Subject: Re: [Feature or Bug] Data Types: DECIMAL and DOUBLE Hello. First, please stop cross posting. Pick one list and stay with it. Only post on another list if you get no reply for some time. Aside from that, one can argue if that belongs to the win32 list, but what has this to do with java at all? On Mon 2002-11-18 at 09:07:42 -0800, [EMAIL PROTECTED] wrote: Say we create a table as follows: CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double DOUBLE(20,2)); And we insert 6 rows as follows: INSERT INTO account (id, balance, col_double) VALUES (1, 12345678901234567890.56, 12345678901234567890.56); INSERT INTO account (id, balance, col_double) VALUES (2, 1234567890123456789.56, 1234567890123456789.56); INSERT INTO account (id, balance, col_double) VALUES (3, 123456789012345678.56, 123456789012345678.56); INSERT INTO account (id, balance, col_double) VALUES (4, 12345678901234567.56, 12345678901234567.56); INSERT INTO account (id, balance, col_double) VALUES (5, 1234567890123456.56, 1234567890123456.56); INSERT INTO account (id, balance, col_double) VALUES (6, 123456789012345.56, 123456789012345.56); We I have from the table by executing a query as follows; SELECT * FROM account; ResultSet: === idbalance col_double 1.9912345678901234567000.00 212345678901234567800.0012345678901234567800.00 3 123456789012345680.00 123456789012345660.00 4 12345678901234568.0012345678901234568.00 5 1234567890123456.50 1234567890123456.50 6123456789012345.56 123456789012345.56== Only correct one Is this a feature or bug? Any comments? Thanks you. Note that double floating point values have only a precision of about 15-16 digits. That explains the behaviour you see with col_double. The behaviour you see with balance is because you use doubles to initialize the column. So the precision is already lost after parsing the insert. Using string constants instead of numbers should work, i.e. INSERT INTO account (balance) VALUES (12345678901234567890.56) Except, of course, for the row with id=1 where the number is bigger than allowed by DECIMAL(20,2) and therefore set to the max value as explained in the manual. 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: [Feature or Bug] Data Types: DECIMAL and DOUBLE
Where can we find the info regardng on the DOUBLE precision 15 or 16? I searched the doc. and unable to locate it. JDBC mm.mysql-2.0.14-bin.jar + MySQL v3.23.52-MAX on WinNT. Regards, Pae CREATE TABLE account (id INTEGER, balance DECIMAL(20, 2), col_double DOUBLE(20,2)); And we insert 6 rows as follows: INSERT INTO account (id, balance, col_double) VALUES (1, 12345678901234567890.56, 12345678901234567890.56); INSERT INTO account (id, balance, col_double) VALUES (2, 1234567890123456789.56, 1234567890123456789.56); INSERT INTO account (id, balance, col_double) VALUES (3, 123456789012345678.56, 123456789012345678.56); INSERT INTO account (id, balance, col_double) VALUES (4, 12345678901234567.56, 12345678901234567.56); INSERT INTO account (id, balance, col_double) VALUES (5, 1234567890123456.56, 1234567890123456.56); INSERT INTO account (id, balance, col_double) VALUES (6, 123456789012345.56, 123456789012345.56); We I have from the table by executing a query as follows; SELECT * FROM account; ResultSet: === idbalance col_double 1.9912345678901234567000.00 212345678901234567800.0012345678901234567800.00 3 123456789012345680.00 123456789012345660.00 4 12345678901234568.0012345678901234568.00 5 1234567890123456.50 1234567890123456.50 6123456789012345.56 123456789012345.56== Only correct one Is this a feature or bug? Any comments? Thanks you. Note that double floating point values have only a precision of about 15-16 digits. That explains the behaviour you see with col_double. I searched the MySQL docuementation and unable to locate the info you mentioned above. Would you provide the specific info to locate it. The behaviour you see with balance is because you use doubles to initialize the column. So the precision is already lost after parsing the insert. Using string constants instead of numbers should work, i.e. I can see this part if the double uses the precision 15. INSERT INTO account (balance) VALUES (12345678901234567890.56) Except, of course, for the row with id=1 where the number is bigger than allowed by DECIMAL(20,2) and therefore set to the max value as explained in the manual. 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: Re: Age calculation
You probably need a computational module that calculates age with leap year calculation support. :-) Pae - Original Message - From: Kittiphum Worachat [EMAIL PROTECTED] To: Nick Stuart [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 6:38 PM Subject: Re: Re: Age calculation Hi, Nick Stuart,All Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers datecalculations and has specifics on Age calcs. -Nick Hello, mysql, How to get Age from field date-time that contain dateofbirth and then display as xx year yy month zz days. Yes I have ever seen it before but it not my answer. I really want to get result something like your age are 30 years old 6 month and 15 days. is it possible with SQL. Best regards. Kittiphum Worachat [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php