Re: Suppression of result in SELECT @temp := column?
Hi! On Aug 25, 2004, at 8:16, [EMAIL PROTECTED] wrote: Is there any way to not sending the result of a user variable assignment to the client? I.e. Suppress the result of; SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1 ...since I only use @temp in my next statement to produce the actual result. Use DO instead of SELECT. DO is like SELECT, except that it doesn't return any results. Also, is there a equivalence to the MSSQL statement; SET NOCOUNT ON ...in MySQL, which suppresses the rows affected messages? Not AFAIK. You can make the MySQL client less verbose (which includes suppressing the rows affected message) by starting the client with the --silent/-s option. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Clarifying the MySQL Licensing Policy Documents Pt. II
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings All, Sorry for the long delay in following up! First, I have resigned from my position as MySQL AB Community Advocate for personal reasons. If you have concerns regarding licensing and community issues that you wish to directly engage MySQL in, you should write to either [EMAIL PROTECTED] or [EMAIL PROTECTED] Also, rather than create a separate request tracker for the licensing issues, our webmaster has (smartly) added a category in the standard MySQL bug tracker (http://bugs.mysql.com/). So, let us recap where we left off in these discussions with a slightly modified version of the notes from my prior message on this issue: As a way to cooperatively work to address some of the licensing concerns held by members of the MySQL community and the broader Free Software/Open Source community, we are initiating a community review of our licensing policy documents. This means that we are soliciting feedback about issues in the policy documents that people find inaccurate or unclear. From this feedback we will work to improve the policy documents. Please note that we cannot guarantee that we will address or accept all of the issues raised or suggestions made. The licensing is both complex and is the cornerstone of our business. Past experience shows that we must work carefully, incrementally and with community involvement in this area. As with development of the FLOSS exception though, I hope that we can reach a compromise that is satisfactory for almost everyone. If you wish to participate, the process for doing so is simple. Review some or all of the following documents: * http://www.mysql.com/products/licensing/ * http://www.mysql.com/products/licensing/commercial-license.html * http://www.mysql.com/products/licensing/opensource-license.html * http://www.mysql.com/products/licensing/faq.html When you encounter an issue that you find confusing or inaccurate, please file a bug report in the MySQL bug tracking system at http://bugs.mysql.com/. Please check to see if the bug has already been reported - if so, consider commenting on the existing bug. If creating a new bug, please make sure to set the category of the bug to Licensing. Additionally, it would be optimal if you could send a note to the MySQL community list on the issue - forwarding the message provided by the bug tracking system should be an easy way to do this. I would like the discussion to take place on the MySQL community list, as it is easier to keep track of the issues in a single, low-traffic setting. I prefer not to Cc the MySQL General list beyond this initial email, so as to avoid cluttering an already busy mailing list. As for the policy documents, MySQL CEO MÃ¥rten Mickos made a small set of alterations to the docs that he noted at http://slashdot.org/comments.pl?sid=118195cid=9987564 Thanks to everyone for their input and effort here! It has been good working with you! Cheers! - -- Zak Greant -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (Darwin) iD8DBQFBL3x8ctLVEMjfMB0RAjmIAJ40f+eyAO6m3alwA4Nb1aZb2dOZ2wCg4w6t OHCGMCl1oMZGxuNfYC/SaGA= =cR3c -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Clarifying the MySQL Licensing Policy Documents
Greetings All, As a way to cooperatively work to address some of the licensing concerns held by members of the MySQL community and the broader Free Software/Open Source community, we are initiating a community review of our licensing policy documents. This means that we are soliciting feedback about issues in the policy documents that people find inaccurate or unclear. From this feedback we will work to improve the policy documents. Please note that we cannot guarantee that we will address or accept all of the issues raised or suggestions made. The licensing is both complex and is the cornerstone of our business. Past experience shows that we must work carefully, incrementally and with community involvement in this area. As with development of the FLOSS exception though, I hope that we can reach a compromise that is satisfactory for almost everyone. If you wish to participate, the process for doing so is simple. Review some or all of the following documents: * http://www.mysql.com/products/licensing/ * http://www.mysql.com/products/licensing/commercial-license.html * http://www.mysql.com/products/licensing/opensource-license.html * http://www.mysql.com/products/licensing/faq.html When you encounter an issue that you find confusing or inaccurate, please send a note to the MySQL community list or to me personally on the issue: Ideally the note will state: * where the issue is (which document, where in the document) * what specific aspects of the issue concern you * the severity of the issue (is it cosmetic, minor or major) * a suggested fix or set of fixes You are also welcome to directly file an issue report in the system that I use for tracking these issues. Visit http://zak.greant.com:/licensing/tktnew to do so. I would like the discussion to take place on the MySQL community list, as it is easier to keep track of the issues in a single, low-traffic setting. I prefer not to Cc the MySQL General list beyond this initial email, so as to avoid cluttering an already busy mailing list. An initial list of issues raised by various community members exist at: * http://zak.greant.com:/licensing/tktview?tn=32 * http://zak.greant.com:/licensing/tktview?tn=40 I am currently working on new draft policy documents to correct some of the simple issues and errors, and hope to post it next week for community review after it goes through internal review. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: On the licensing once again
On Aug 12, 2004, at 2:38, Issac Goldstand wrote: What if a company hires me to build an application for them. They already have MySQL downloaded and installed. Do I/they need a license? What if the software is open-source, but not free? Hi Issac, We always recommend that proprietary applications that use MySQL use the proprietary version of MySQL. This recommendation helps us fund development of the database and is always accurate. However, if you are working for a company, you are likely not distributing anything to them and can likely use MySQL under the terms of the GPL - it should not matter if they download and install MySQL before or after the work starts. Also, there is no problem selling software that is based on GPL-licensed MySQL and other GPL-licensed software (or some other Free Software*/Open Source** licenses. See http://www.mysql.com/products/licensing/foss-exception.html for a list of licenses that are accepted in addition to the GPL.) * See http://www.gnu.org/philosophy/free-sw.html for more information ** See http://www.opensource.org/docs/definition.php for more information Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: On the licensing once again
On Aug 11, 2004, at 1:21, DebugasRu wrote: 1) LM If your software is licensed under either the GPL-compatible Free Software LM License as defined by the Free Software Foundation or approved by OSI, then LM use our GPL licensed version. 2) LM If you distribute a proprietary application in any way, and you are not LM licensing and distributing your source code under GPL, you need to purchase LM a commercial license of MySQL To be honest i don't understand the double licensing issues at all. Does the second part 2) applies to the developer of proprietary software only or does it apply to its users too ? Hi! The second part only applies to the distributed copies of MySQL. Each distributed copy of MySQL needs to have a valid license. This can be the GPL, or if the distributor cannot comply with the GPL, then they should have one proprietary license for every copy of the software that they ship. To make our money on licensing and to keep things simple, we always recommend that proprietary use of MySQL be done under a proprietary license. This is not required in all cases though. Why a user cannot install and use MySql under GPL and then install and use proprietary software under whatever licence he got it. A user can do this. However, if a developer of proprietary software that is based on MySQL distributes that software, then they need to make sure that the distributed copies have valid non-GPL licenses. Or do you want to say that the end user can in general use MySQL under GPL, but as soon as he tries to use it with that particular proprietary software then he can no longer use MySQL under GPL ? This seems to contradict the GPL license terms Users are free to use MySQL under the terms of the GPL as long as they comply with the terms of the license. They can even use GPL licensed MySQL and proprietarily licensed versions of MySQL at the same time. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: On the licensing once again
On Aug 11, 2004, at 2:42, [EMAIL PROTECTED] wrote: Thank you Zak for correcting me. Much appreciated ;-) Hi Nils, Glad to help! Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: R: On the licensing once again
On Aug 11, 2004, at 7:09, Leonardo Francalanci wrote: If you develop a product, say, some kind of online shopping system that you distribute on a CD which installs Linux, Apache, MysQL, PHP and your App and distribute that, then you probably should be paying for a license. This is because instead of you handing over full code (and it's rights) to the client as their property, you are placing licensing limitations on it. Ok, but if I say to a client (that has his own web server) you will need to install Mysql on your server to run the site I'm writing for you, will he need a license? Hi Leonardo, We always recommend that proprietary use of MySQL be done under our for-pay license. This is a simple recommendation that helps us fund development and is always correct. However, if you are creating a work for a client who has hired you to build something for them, then chances are quite good that MySQL can legally be used under the GPL. If you build a proprietary software product that is based on MySQL and distribute this to customers, then you probably can't do so with the GPL licensed version of MySQL and would need to purchase non-GPL licenses for MySQL. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: R: On the licensing once again
On Aug 11, 2004, at 11:45, Santino wrote: I think that the license scheme is very simple reading gnu faq: If you distribute your software under GPL you and your customer don't need a commercial license but the user can change your code and give it away with a GPL license. In every other case you need a commercial license. The point of GPL are: - full source of all the code - every work derived from the original must be distributed under gpl - right to modify and distribute all the software (with gpl). So you can not distribute any software that requires MySql (or other gpl source code) without a GPL license. Now a question: Where is the text of commercial license; I have one trouble: Can I buy a license (1 for each server) and sell my application to a reseller that will sell my application, hardware and technical support to the real customer? Hi Santino, Good question! I don't usually deal with the details of the proprietary MySQL licensing, but I would guess that as long as a MySQL server has a valid license, we don't care how it gets to then end user. I can put you in touch with one of our sales team members to get you more information. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using mysql in commercial software
On Aug 09, 2004, at 17:56, Jeremy Zawodny wrote: This is confusing. There are *two* official places to discuss the licensing and community issues? Ugh. Or am I misunderstanding things? The licensing forum seems to generally be used provide quick answers on licensing questions for proprietary software developers, while the community forum is more for discussing any non-technical issue that relates to the MySQL community. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using mysql in commercial software
Greetings All, LinuxWorld is now finished (meaning that some of the key MySQL people who need to be in on these discussions will be back to a more normal working setup) and the weekend is more or less here. I hope to pick up discussions on these issues with the other MySQLers on Monday (or to word it differently, I hope to avoid talking about licensing on my weekend! ;) Also, this discussion is a better fit for the community list ([EMAIL PROTECTED]). There are already a group of people interested in the licensing issues on that list. Unless people feel strongly, I will move this issue to that list. I urge those with an interest in our licensing and other community issues to subscribe to the community list. Those who are subscribed to our community list but not the MySQL general list, see http://lists.mysql.com/mysql/169680 to catch up on the discussion thread this message refers to. Also, those of you with an interest in licensing might also be interested in the licensing forum at http://forums.mysql.com/list.php?4 - there are additional discussions there on a variety of licensing issues. Have a good weekend! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using mysql in commercial software
Hi Mike, On Aug 06, 2004, at 18:08, mos wrote: This means that, according to the most common interpretation of the GPL, just linking with them automatically requires your code be under the GPL. License: The GPL license is contagious in the sense that when a program is linked to a GPL program, all the source code for all the parts of the resulting product must also be released under the GPL. One important note here: The GPL does not behave in the way described above. There is no requirement to distribute software that you build with or on top of GPL-licensed software to others. However, if you choose to distribute software that is a derivative work (defined in US copyright law as A ''derivative work'' is a work based upon one or more preexisting works) of GPL-licensed software, then the software can only be distributed under the GPL. So what if the client app doesn't require the MySql client libraries in order to access the MySQL database? My client application requires no dll's at all, because everything is compiled inside an .exe file. That's because I'm using a 3rd party set of components that bypasses the libmysql*.dll libraries altogether. My application doesn't link to MySQL's code, GPL or otherwise. Does this now make my application license free even if I distribute it for $$$? Or will the software police come banging on my door at 4 AM looking for me? This architecture might bypass the requirements of the GPL - I don't really know. The best course of action here is to consult a lawyer who is an expert in Free Software/Open Source software licensing who can advise you of the validity of your course of action for your given situation. We would probably assert that the software forms a derivative work with GPL-licensed MySQL because the software would likely not function without MySQL. However, this is a tough area to speculate on. As we are not lawyers (nor are we in the business of giving free legal advice to help people circumvent our own business model :), we always recommend that proprietary applications (aka applications that do not share their source code and the rights to modify it with others) should always use the proprietarily licensed version of MySQL. This recommendation ensures that our licensing terms are never violated and helps us generate revenue to fund development of the database. Usually, people who distribute proprietary applications are selling them. We feel that it is reasonable to charge users who wish to charge their users and who do not give their users the freedom to view, modify and share the source of the application. We also suggest that people consider putting their software under a Free Software/Open Source license (such as the GPL, the BSD license, the Apache license and so on). Then they can use MySQL for free. This model may not work for everyone, but there is still significant potential for revenue with the model by selling the application at a fee that the market finds reasonable, along with related services like hosting, support, consulting, etc. People may also want to consider using a dual-licensing model that allows them to share with others who choose to use Open Source/Free Software licenses, but gives them a revenue stream from people who prefer traditional proprietary licenses. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using mysql in commercial software
Greetings All, I walked through the mailing list thread earlier today. The big issues that I believe that people raised were: * Incorrect information on distribution as it applies to the GPL in our licensing documents * Lack of clarity from MySQL on what is and not acceptable use of GPL-licensed MySQL * Lack of concrete examples of suitable/unsuitable use of GPL-licensed MySQL I opened up a new ticket at http://zak.greant.com:/licensing/tktview?tn=40 to cover the last two of issues. The ticket is rather terse, but I think that we all understand the issues. The existing ticket http://zak.greant.com:/licensing/tktview?tn=32 seems to cover the first issue. Also, I have started discussing these issues with the other MySQLers and hope to have something useful to report soon. I understand that this is not optimal because it does not involve all of the people who have a stake in the licensing. Frankly licensing is a tough issue for us - it is the base of our revenue and it affects many people within and without the company. Additionally, it is a legal issue - something that makes many people, including us, very cautious. Please continue to provide feedback on this area using any channel that you feel comfortable using. I admit that I prefer knowing about feedback on MySQL, so a courtesy Cc to me at [EMAIL PROTECTED] and/or to our community list ([EMAIL PROTECTED]) and/or an open ticket in the licensing issue tracking system (http://licensing.zak.greant.com) are all greatly appreciated. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using mysql in commercial software
Hi Jeremy, Greetings All, First, thank you for taking the time to discuss this issue. It is important that people let us know when they upset with us. Next, it is clear that we need to look at the issues that were raised by this thread. When more of the right people from MySQL return from LinuxWorld, we (MySQL) can take action. Until then, there are a few things that I can recommend: * visit http://licensing.zak.greant.com/ - this is where I keep a partial list of issues relating to MySQL's licensing * of particular interest to this discussion is bug report http://zak.greant.com:/licensing/tktview?tn=32,6 * if this is not bug report is not complete enough, please consider adding an additional request * I won't be back to network access until late tonight, but I will work on scraping the issues from the thread tomorrow * the work on the listed bug report had stalled while we worked on extending the exception to our current GPL licensing * drop by the MySQL booth at LinuxWorld and discuss your feeling with the MySQL team who is present. In particular, you would want to talk to Brian Aker, Zack Urlocker and Marten Mickos. -- Cheers! Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Any MySQL + IBM Power CPU Hardware (pSeries, iSeries, JS20, Blade) Users?
Greetings All! MySQL AB is interested in talking to MySQL users who running MySQL on IBM Power CPU server hardware (pSeries, iSeries, JS20 Blade). If you (or someone you know) are willing to chat with us, please let me know at [EMAIL PROTECTED] Thank you for your help! Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Users Conference: New mailing list for those interested in the event
Greetings All! We have setting up a mailing list for people who are interested in the MySQL Users Conference (http://mysql.com/events/uc2004/) If you are attending, planning to attend or want to know more about the event, we urge you to join this list by visiting http://lists.mysql.com/list.php?list=users-conferencesub=1 or by sending mail to [EMAIL PROTECTED] -- Zak Greant MySQL AB Community Advocate MySQL User Conference Cat Herder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Community Contributor Discount for the 2004 MySQL User Conference
Greetings All, As promised a few weeks ago (but only delivered today), MySQL is offering a $100 discount on the MySQL 2004 User Conference conference fee for attendees who contribute to the Free and Open Source Software commons. The purpose of this discount is both to reward people for their work in the community and to encourage others to start contributing. To get the discount, you need to have made a significant contribution to the Free and Open Source Software (FOSS) community. Demonstrating this should be fairly simple. Some examples of how your might do this could be: - mail me links to some support entries from FOSS support lists that you contribute to - show me a software package that you have contributed to that is released under a FOSS license - show me links to CVS commit messages for FOSS-licensed software documentation - etc You don't need to be an expert or a project leader to get the discount. Just show a consistent activity and a strong commitment to helping other people in the community! If everything looks good, I will email you a code and instructions so that you can register online. If I have some questions, I will write. I know that this is not a very objective system, but it will have to do for this year's conference! :) Also, if you have already paid the conference fee, we can retroactively apply the discount if you follow the above steps. Please Note: If you have already received the early bird discount, I can't give you this discount. Still, drop me a line and I will buy you a beverage of your preference at the conference. :) Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference Computer Lab Sessions and Early Bird Sessions
Greetings All, If you are interested in attending the conference in person (or virtually), please read on. First, in addition to our regularly scheduled conference sessions, we are going to be having about a dozen training sessions. The sessions will let small groups of attendees (about 10 per session) get 30 to 90 minutes of hands-on training with MySQL staff and MySQL community leaders. We will be covering topics like query and server optimization, coaching on new (and old) feature use and providing step-by-step demos of some cool new software. Perhaps the most exciting session for the veteran hackers on this list will be a 90 minute workshop with some of our developers (including Monty) where they will walk you through the major architectural components (and the corresponding source) of the MySQL database and MyISAM storage engine. While MySQL is providing the speakers for the sessions, Apple is graciously providing the computers - students will be sharing a shiny new G5 during the training. We are currently looking at ways to let people participate virtually in some of these sessions and are going to be testing the use of VNC and other remote technologies. If you want to participate in the testing, please write me personally and let me know. These sessions will be included in the conference fees, but space is limited and attendees will have to register to participate. A fixed list of sessions and registration for them should be posted next week. The conference team will send out an informational message at that time. Speaking of conference fees, the $100 early bird discount ends on February 14th. To take advantage of the discount, visit https://order.mysql.com/?sub=pgpg_no=14 Also, as a reward for the people who help keep Free Software and Open Source going, I am happy to announce that we will be offering a discount to the conference fee to those who actively contribute to the software and community commons. I will post the guidelines for eligibility early next week. If you have any questions, feel free to drop me a line - though please note that I will be traveling for the next week and may take a day or three to respond. Finally, if the mention of the conference comes as a surprise to you, visit http://www.mysql.com/events/uc2004/ for an overview. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference 2004: Choosing the Internals/Advanced Sessions
Greetings All, My name is Zak Greant. I work for MySQL AB as their community advocate - I am also helping to organize the content for our upcoming MySQL User Conference (http://mysql.com/events/uc2004) that is happening in April. Our deadline for choosing the final list of sessions is a couple of days away. We have so much excellent content that has been proposed that we need some help from the community in choosing the content that is best for the event. Here are seven advanced/internals talks that we are considering. Please let me know which talks you would best like to see. Notes: * We will be posting addition information on the accepted sessions to http://mysql.com/events/uc2004/sessions.html within the next day. * Even if you are not going, your feedback is valuable to you as we will work to post papers from most of the accepted sessions. * We are open to suggestions for other content in the form of BoF sessions and lightning talks (see http://www.mysql.com/events/uc2004/speakers.html) The session titles are: * Connecting Data to MySQL, writing a simple Storage Engine * Hack Proofing MySQL * MySQL performance comparison on RedHat linux, Debian GNU/Linux and FreeBSD * Performance tuning for Innodb storage engine * Protecting Private Information with MySQL * Speed, Flexibility, Security: The MySQL solution to a large-store XML dilemma * The Badger Project: Improving MySQL Performance on Modern Computer Architectures Connecting Data to MySQL, writing a simple Storage Engine Noted community hacker Brian Aker demonstrates how to write your own custom storage engines for managing specialized types of data. Hack Proofing MySQL MySQL databases are a common point of attack because they typically hold the most valuable information for an organization. Because of this, locking down your MySQL databases is critical. This presentation will cover how a hacker approaches your database, the most common attacks, the most successful attacks, and how to prevent yourself from ending up as a victim. Secure your MySQL server involves properly configuring the database, educating your developers, and developing your applications to access the database securely. We will cover attacks such as SQL Injection, password brute-forcing, buffer overflow, and privilege escalation. Attendees will learn: 1) How attackers attack a MySQL server. 2) How to securely install and configure MySQL. 3) How to securely write applications for MySQL. MySQL performance comparison on RedHat linux, Debian GNU/Linux and FreeBSD When talking about databases, we normally do not think about the underlying environment on which the application is running, but this can represent a great advantage or drawback if we consider that each programmer, the application developer and the operating system developer, have to focus on his own work and depends on the work of the other.The two components have to be fine tuned to smoothly work together. When WillyStudios.com had to decide which one was the best platform to deploy its work on, we tested each environment thoroughly. In this talk we are going to present the results showed by our survey and discuss which ones are the best methods to have higher performances from the same database environment on different platforms. InnoDB Performance Tuning This session will demonstrate techniques for optimizing the performance of the InnoDB storage engine. The speaker will cover both MySQL server configuration as well as best practices for application development and OS tuning/hardware tuning. The advice provided will be supported by benchmark results. Protecting Private Information with MySQL Website managers must balance the need to provide customization with the responsibility to protect the private and sensitive information of customers. This talk will explore how some of the built-in encryption features in MySQL can create safe, strong and secure systems to guard against hackers and malicious insiders. It will begin with some simple examples and culminate with an extended example describing a website that offers all of the features of a highly-customized website like Amazon.com without keeping any personal information around. It will be the equivalent of having your cake and eating it too. Speed, Flexibility, Security: The MySQL solution to a large-store XML dilemma While MySQL databases have been used for years by the LANL Digital Library Development Team, it has been in the creation of our most ambitious project that we have truly recognized some of the unique strengths and features of MySQL. The project -- development of a comprehensive database of scientific journal articles and citation information -- involves converting bibliographic metadata from 8 distinct data suppliers into a common XML format, enhancing the data with links between each of the 50 million articles and their 507 million individual
MySQL User Conference 2004: Choosing the General Sessions
Greetings All, My name is Zak Greant. I work for MySQL AB as their community advocate - I am also helping to organize the content for our upcoming MySQL User Conference (http://mysql.com/events/uc2004) that is happening in April. Our deadline for choosing the final list of sessions is a couple of days away. We have so much excellent content that has been proposed that we need some help from the community in choosing the content that is best for the event. Here are five general talks that we are still pondering. Please let me know which talks you would best like to see. Notes: * We will be posting addition information on the accepted sessions to http://mysql.com/events/uc2004/sessions.html within the next day. * Even if you are not going, your feedback is valuable to you as we will work to post papers from most of the accepted sessions. * We are also examining ways to let people who cannot attend still experience a few of the hands-on technical sessions via technology like VNC, live audio streams and/or IRC * We are open to suggestions for other content in the form of BoF sessions and lightning talks (see http://www.mysql.com/events/uc2004/speakers.html) The session titles are: * Best Practices for MySQL Administration in an Enterprise Environment * Large Volume Data Transformation and Warehousing using MySQL * MySQL as an Embedded Database: An Implementation Story * Web Development with Bells and Whistles using MySQL * Show Me the Money: Getting Your MySQL Certification Best Practices for MySQL Administration in an Enterprise Environment Best practices to effectively manage MySQL servers in the non-web space. Best practices are bunches of norms that generally make systems safer and cheaper. We will briefly review system configuration guidelines and what best practices means. The core presentation will review practices for space and perforamnce management, object management and UDFs, security, replication, backup, recovery and disaster recovery. The talk should be useful for both new and veteran MySQL DBAs, and will focus on MySQL 4.1. Large Volume Data Transformation and Warehousing using MySQL In this session we describe a set of transformations and their corresponding layers for loading data into a data warehouse. Standard SQL is used in all steps and queries are performed on whole sets of data. The features include historisation of data, placeholders for orphaned records, type checking, consistency control, duplicate count, model transformation and optimizations. After extracting data from an operational system you are often left with relational, but not necessarily consistent data stored as text files with some kind of structure. However, for the purpose of doing analysis we need high data quality and performance, which is achieved through an efficient and consistent data model. The tables within it are our goal. In between the data is transformed and refined in several stages. In the process the data passes through different layers of transformation, where each layer is represented with its own namespace using MySQL databases. To begin with there is a temporary layer containing tables that have a one to one correspondence with the files. These are character based to ensure that no data is lost when reading the files into the database. Internal consistency and duplicate analysis is done here according to an XML definition of the model. The next layer is the raw layer, which is similar in model to the temporary layer with the exception of being persistent and having types. For data that should be historised only those records in the temporary layer that are new or constitute changes to data in raw are moved. Type, model and range errors are flagged here and another duplicate check is performed with respect to all data. Within raw we should have a complete history of all data contained in the files with some extra metadata. The model is the same as the one implied by the data in the files. Having come this far could sometimes be enough, but since this model could be denormalized we take the process one step further and provide a mechanism for converting the data into a new model. This is also useful for substituting compound natural keys with simple surrogate ones and thereby increases performance. In order to do so a key lookup layer is introduced, containing the natural keys from the raw layer together with auto incremented surrogate keys. This layer is further used to produce surrogate keys from foreign keys in orphaned records, which ensures consistency. The model in the key layer is the same as in our warehouse layer, which is loaded using a combination of data in the raw layer with the surrogate keys. The warehouse is in our case normalized according to 3NF, yielding efficient storage since data is not duplicated in the tables. However, when doing analysis we could utilize far better models when it comes
Polls on O'Reilly
O'Reilly has a favorite database poll right now - visit http://www.oreilly.com/ for details Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Licence question
Good Day All, Let me attempt to provide some clarity on this issues (though it is important to note that I am not a lawyer or a judge.) The fundaments of the GPL are easy to understand. The GPL operates within standard copyright law. Under copyright law[0], the copyright holder has a bundle of rights related to their work. These rights including the right to control the copying, modification and distribution of their work. The holder can keep these right or they can grant others some or all of the rights as well. If they grant others rights to their work, they usually do so under the terms of a license. The GPL is one such license. It gives you the right to copy, modify and distribute the work as long as you follow some conditions. The important conditions for this discussion are: * You must distribute (or at least make available) the source code for the software. * If you form a derivative work with GPL licensed software, then the resulting work should also be GPL licensed. [1] Derivative work is a term from US copyright law (though most copyright laws have some similar concept). A derivative work is a work that is based in whole or in part on another work. There are no fixed rules on determining when a derivative work is formed. In some cases, it is very clear. If I were to modify GCC by changing a few constant names, it would certainly be a derivative work. If I had a program that used a database abstraction layer to allow it to communicate with a broad class of databases, maybe I would not be forming a derivative work with any of the databases. If I used an abstraction layer to specifically avoid creating a derivative work, but my product was intended to only work with one database, then it would be a different situation again. The technical process used (linking methods, abstraction layers, communication layers, ...) cannot be the only determining factor of whether a derivative work is or is not formed. If it were, then it would allow software licenses (both free and non-free) to be easily circumvented. Instead the end intent of the action must be taken into account. A good analogy for this is the case of someone dying due to someone else's actions. Consider the following cases: I drop a heavy potted plant on David. (He has a great comics collection that I covet. ;) I ask Mark to drop a heavy potted plant out the window, but I don't tell him that David will likely be killed by this. Mark falls out of the window because the plant is really heavy. David shoots Marks because he thinks that he is going to drop a potted plant on him. Which of the above is murder? Who is responsible? It really depends on how much is known about each situation. If David shoots Mark, and Mark is the only person who knew that I asked him to drop the plant out the window, then I would seem to be innocent (unless I was recorded urging Mark to drop the pot or I confessed). The context that an event occurs in has a tremendous effect on how it is perceived. My view on this issue are quite simple: If you are willing to pass on the rights that we grant you under the GPL, then please use MySQL under the GPL. If you do not want to pass on these rights then you should purchase a commercial license. In many ways, MySQL behaves like a typical Free Software/Open Source developer. We write software that we place under an open license. We also sell services and software so that we can make money. It just so happens that the same software that we put under an open license is the same software that we sell. [0] Note that different countries have different copyright laws. The exact bundle of rights and how they are protected vary from country to country. [1] A relevant section of the GPL is section 2b: 2. You may modify your copy or copies of the Program or any portion of it, thus forming a work based on the Program, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions: ... b) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole at no charge to all third parties under the terms of this License. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference 2004 Call for Papers
MySQL AB is please to announce that the Call for Papers for the 2004 MySQL User Conference is now officially open. We encourage every MySQL user with something to say - from grey-bearded hackers and peach-fuzzed power users to corporate code wranglers and veteran DBAs - to drop by http://mysql.com/events/uc2004/speakers.html and write up your proposals for great sessions. We are looking for sessions that speak to your peers: practical, pragmatic and clueful presentations that focus on how you solved problems in a demanding or unique technical environment. Session that introduce a particular feature set or provide hands-on training to introduce newer developers to cutting edge functionality are also welcome (as is any cool or unique presentation). You can give sessions that range in length from 5 minute lighting talks up to 90 minute power tutorials. We also have set aside slots for 30 minute technical briefs and standard hour long sessions. Additionally we are looking for solid ideas from the community for Bird-of-a-Feather (BoF) sessions. These sessions give conference attendees a chance to meet and discuss topics of common interest with their peers. Visit http://mysql.com/events/uc2004/speakers.html to suggest ideas for the BoFs that you would like to participate in. The call for papers closes on January 14th. The conference will take place on April 14th to 16th in Orlando, Florida, USA. The call for BoFs and lightning talks closes on February 14th. For additional inspiration, check out last year's schedule: http://mysql.com/events/uc2003/schedule.html If you want to briefly discuss your ideas, fill out the appropriate form at http://mysql.com/events/uc2004/speakers.html and make a note in your comment. I will write you back in a day or so with some extra input. Good Luck! See you in Orlando! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not make PULL from mysql.bkbits.net
On Nov 12, 2003, at 17:52, Gelu Gogancea wrote: bk pull http://mysql.bkbits.net/mysql-5.0 Try bk clone http://mysql.bkbits.net/mysql-5.0 Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Digest Again, PLEASE SOMEONE HELP?
On Nov 12, 2003, at 20:37, Paul Fine wrote: Unless I am misinformed, subscription to the DIGEST format of this list should cause all messages to come in one daily e-mail? Can someone else who is subscribed this way please at least let me know that this is at least the case for them? While I do not use digest for this list, I use it for other MySQL lists. It behaves in the way you describe. I continue to get every single post as an individual e-mail. I have tried canceling and re-subscribing with the DIGEST option selected, to no avail. Perhaps unsub from the main list, then sub to the digest. I have also not received any response from admin. I have bcc'd the admin. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Userpasswords
On Nov 13, 2003, at 14:02, Alaios wrote: Hi there . How can i passwords so i can login into myqsl. With current configuration anyone is allowded to login. See the REVOKE command at http://mysql.com/GRANT Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unable to Retrieve HTML Form Values(test1.html) from a PHP Page(test1.php)
Dear Prashant, This list is for MySQL questions, rather than PHP questions. Please try the PHP general mailing list ([EMAIL PROTECTED]). Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Insert happens twice
On Tuesday, Oct 28, 2003, at 15:19 Africa/Accra, Erich C. Beyrent wrote: Hey folks, I am having a dreadful problem here, and I cannot get to the root of it. It appears that every time I do an INSERT, the insert happens twice. I have spent several days on Google, but with no luck. Some background - I am using PHP and Smarty on a site. Here is one of the tables in my database that is having the problem: ... $sql = insert into composers(ComposerFname, ComposerLname) values('', 'Bach'); which then gets executed. My debug statements indicate that this is only getting executed once. However, I end up with two new entries in my composers table. I know I can solve this by making the fields unique, but I'd have to do that for every table in the database, when what I'd really like to do is find out why the insert is happening twice. Any ideas? Test the query in the MySQL command line client to see if you experience the same behavior outside of PHP. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 and PHP/Perl Clients
On June 25, 2003 09:59, PAUL MENARD wrote: ... I've been considering upgrading my data , MySQL 3.23.42 to 4.013 or even going to 4.1. I've read on the MySQL upgrade documents that some client might be affected when upgrading to 4.1. It does specifically mention Perl which I use to supplement PHP. By I'm more concerned about PHP. Should I be concerned? Yes, it will not work at all. MySQL 4.1 uses a protocol that's not compatible with MySQL 3.23 and 4.0. Hi Paul, MySQL 4.1 does use a new enhanced protocol that supports cool things like compression and prepared queries. However, a 3.23.x/4.0 client can still connect to a MySQL 4.x version server. If you are upgrading from a non-4.1 version and do not update the mysql user table to the new format, then connecting will be no problem (However, the password hashes used in 4.1 are much harder to compromise.) If you are setting up a new 4.1 server, you can set --old-passwords when starting mysqld to force the server to use old passwords, or use the OLD_PASSWORD() function to set a users password to the old-style password, which would allow a 3.23/4.0 client to connect. Look for some extra info at http://www.mysql.com/doc/en/What-to-do-from-4.0.html You need to use the ext/mysqli extension for it to work, but there are two problems with this: 1) it is only available with PHP5 which is not released yet. PHP 5 will be released in a beta stage shortly. IIRC the mysqli extension has been or will be ported to PHP 4. 2) it cannot be legally used since the MySQL 4.1 client libraries have been re-licensed under the GPL (old versions of the client libraries used to be under the more friendly LGPL). We are currently working on an extension to allow MySQL to be linked and distributed with software that is licenced under a valid open source license (as defined by the Open Source Initiative - http://www.opensource.org/) This will allow PHP to use us without licensing issues. As for Perl, IIRC the DBI stuff is dual-licensed under Artistic/GPL - like the rest of Perl. DBI should have no problem with the licensing change. The details are still in flux - expect firm details in a few weeks or so. Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000
On April 4, 2003 05:40, [EMAIL PROTECTED] wrote: YAY! somebody is helping me!!!This is exactly what i needed. Why isn't it right at square one in a readme or in the manual? maybe i just missed it but, i swear i looked and looked! AWESOME ! thanks and cheers! Hello Kira, There are hundreds different languages, tools and abstraction toolkits that use MySQL. In the manual, we start with the simplest possible choice - using MySQL from the command line. I will suggest to the documentation team that we provide suggestions at the start of the article on how to get started with other combinations of technologies. For learning how to use MySQL with a given language (such as PHP) it is often best to look at the documentation for the language. With PHP, if you visit http://php.net/mysql, you will find a simple example of how to connect to using PHP, along with many additional details for each function. Additionally, many common topics, such as using Dreamweaver, MySQL and PHP have be covered in web-based articles. A search on Google.com for 'dreamweaver mysql php' returns results like: http://www.macromedia.com/devnet/mx/dreamweaver/php.html Cheers and happy coding! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Support for Dynix/ptx
On April 1, 2003 07:50, Klepetka, Tom wrote: Hi - I would like to access a mysql database server from a NUMA-Q Sequent platform running Dynix/ptx v4.5.2. Does any of mysql's connectivity products (Connector/ODBC, Connector/C++) run under this platform/OS? I am afraid that I don't know. Does GCC run on this platform? Also, is there a C (not C++) API available? The C API is the base API :) Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database size
On Thu, Mar 27, 2003 at 02:35:18PM -0600, Jeff Kilpatrick wrote: It's also interesting to note that it's possible to split innodb data between multiple files to have databases larger than the OS's max file size. The theoritical maximum table size for the various storage engines is: BDB : 32 TB InnoDB: 64 TB MyISAM: 8 x 10^6 TB With BDB and InnoDB, you can actually have a maximum table size of 256 TB - however, you have to increase the page size when MySQL is compiled. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL ending right after starting
On Tue, Mar 25, 2003 at 06:31:55PM -0500, [EMAIL PROTECTED] wrote: We recently upgraded to mysql 4.0 on Mandrake 9. When typing safe_mysqld mysql starts then immediately stops saying mysqld daemon ended. There are no other processes running. Tried installing 3.23 and the same thing. Reinstalled 3.22 and it stays started. What is not allowing mysql to keep running? Any help would be appreciated. What do your error logs say? Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with Query
On Mon, Mar 17, 2003 at 10:47:09PM -0800, Daren Cotter wrote: This seems to be doing the same thing as the previously mentioned query...simply listing all mailing IDs, along with the # of members it was sent to. I've included both queries with their results below. Hi Daren, Heh. The hazards of writing email a bit late in the evening. :) Sorry I can't offer more help. Cheers! --zak - 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 with Query
On Mon, Mar 17, 2003 at 09:52:44PM -0800, Daren Cotter wrote: Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number. I.e., if I do: SELECT count(*) FROM member_mailings WHERE member_id = 1 That returns the number of mailings for member 1, say it's 25. That would be one tally in the 25 field for # of mailings sent. It's tough to explain, so I'm thinking I won't be able to accomplish it in one query? Hello Daren, Assuming that your table looks something like this: +-+---+-+-+ | ... | member_id | mail_id | ... | +-+---+-+-+ | ... | 1 | 1 | ... | | ... | 2 | 1 | ... | | ... | 3 | 1 | ... | | ... | 1 | 2 | ... | | ... | 2 | 2 | ... | | ... | 3 | 3 | ... | +-+---+-+-+ Then this query should return the information that you desire: SELECT COUNT(member_id), COUNT(mail_id) FROM member_mailings GROUP BY mail_id; Cheers! -- Zak Greant MySQL AB Community Advocate - 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: But now new problems :-(
Why not use the binaries from mysql.com? We recommend them over making your own binaries. -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.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
Re: Table Create Defaults (Type=InnoDB)?
On Mon, Mar 03, 2003 at 09:36:37AM -0500, Warren W. Gay VE3WWG wrote: I would like to create a Table default (Type=InnoDB) for a particular database. Is there a way to do this, or is this being planned for in a future release? For most of my databases, I am only interested in transactions. Having to remember to specify that table type = InnoDB for each table create, is a nuisance. I am also trying to keep to SQL standard code. The table_type option controls what type of database is created by default. You can set this at various places: * When starting mysqld via the --default-table-type option * In a mysql options file via the table_type variable * As a server variable via a SET [GLOBAL] table_type call You cannot set this on a per-database basis, however you can set it on a session-wide basis. To keep closer to standard SQL, wrap the SET call in an executable comment, like so: /*! SET table_type=innodb; */ Most (all that I know of :) databases except MySQL will treat the comment like a normal multi-line comment. MySQL will strip the comment and execute the code. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com OSCON 2003 (http://conferences.oreillynet.com/os2003/) From July 7-11 in Portland, Oregon Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: Table Create Defaults (Type=InnoDB)?
On Mon, Mar 03, 2003 at 08:21:58AM -0700, Zak Greant wrote: ... To keep closer to standard SQL, wrap the SET call in an executable comment, like so: /*! SET table_type=innodb; */ Most (all that I know of :) databases except MySQL will treat the comment like a normal multi-line comment. MySQL will strip the comment and execute the code. One note: The above statement confuses the parser slightly. It believes that the above statement should continue. This will make the subsequent statement fail. I have submitted a bug report. For the short-term, get around the problem by insterting a second semi-colon. The parser will complain about an empty query, but the SET statement and the subsequent query will both succeed. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Display the option files read by the server % mysqld --help Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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: Restoring from a mysqldump file
On Sat, Mar 01, 2003 at 05:11:29PM -0500, Jeff Mao wrote: Greetings all, May be a dumb question,...if I have a text file generated from mysqldump, how do I reload that file into mysql? In the past I've always copied and pasted it into mysql, but that takes a lot of time,...especially as the databases grow! I do not have local access to the server, but I can connect to it remotely using the normal tools,... mysql -h host.name.tld -u user -p dump.file -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com EFF: Protecting Freedoms on the New Frontier (http://eff.org) Support Global Human Rights - Amnesty International (http://amnesty.org) - 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: RAND() isn't :)
On Fri, Feb 28, 2003 at 05:19:15PM +1100, Justin French wrote: Hi all, On my LAN server (FreeBSD, MySQL 3.32) the following query works fine, and seems to return 2 random rows from the table: SELECT * FROM disc ORDER BY RAND() LIMIT 2 However, when I upload the scripts to the live server (Linux, MySQL 3.32), the results are VERY un-random -- only very occasionally do the results differ between each query, usually returning the same two rows. The data in the two tables isn't identical, but both tables DO contain the same number of rows, with the same IDs. Where should I be looking for reasons why the RAND() isn't very random??? Consider upgrading - the problem should be fixed in the most recent versions of 3.23.x and 4.0.x Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Support Global Human Rights - Amnesty International (http://amnesty.org) - 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: convert to mysql function
On Wed, Feb 26, 2003 at 12:32:57AM -0800, DiAnNe iRiS aLeRta wrote: i have made a simulation for horizontal aggregation in C++ but had a hard time converting it to MySQL codes for me to create a function for MySQL? how can i convert my C++ code inorder for it to be accepted and run in MySQL? thanks Dianne, Look up UDF in the MySQL manual. Also, please do not send multiple copies of the same email in quick succession - it is considered rude. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Translucent Databases: An Excellent Guide to Protecting Sensitive Data! Visit http://www.wayner.org/books/td/ for more information - 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: SPAM
Dear Daniel, Thanks for taking an interest in spam fighting. I have passed this information on to our list manager. He will do what he can to deal with this problem. In the future, please keep several things in mind: - we do not tolerate name calling based on religeon, race, sexual preferences, nationality, etc. on the MySQL lists! - please mail the list manager before mailing the general list. The list manager will do what they can to solve the problem. - we cannot condone attacks against systems suspected of delivering or relaying spam. Yours Truly, Zak Greant MySQL AB Community Advocate On Thu, Feb 27, 2003 at 10:59:35AM +1100, Daniel Kasak wrote: SQL. Query. Every time I post to the MySQL lists ([EMAIL PROTECTED] and [EMAIL PROTECTED]) I get a sign-up verification message claiming to be coming from a yahoo groups list. I checked out the source and found it is the same faggot who is spamming with various get-rich-quick schemes: bash-2.05# smbclient -L 220.72.176.55 added interface ip=10.146.0.254 bcast=10.146.255.255 nmask=255.255.0.0 session request to 220.72.176.55 failed (Called name not present) session request to 220 failed (Called name not present) Password: Anonymous login successful Domain=[WORKGROUP] OS=[Windows 5.0] Server=[Windows 2000 LAN Manager] Sharename Type Comment - --- Error returning browse list: NT_STATUS_ACCESS_DENIED Server Comment ---- SUPERMAIL WorkgroupMaster ---- WORKGROUPSUPERMAIL bash-2.05# Unfortunately, smbdie doesn't work on this computer, otherwise I would add him to my reboot-every-5-minutes cron job. If anyone else can take him off the 'net, be my guest. Alternatively, how about banning him from receiving posts? He's adding EVERYONE who posts to his spam lists. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Start MySQL along with a update statement.
On Tue, Feb 25, 2003 at 01:30:52AM -0500, g gnanaraj wrote: I need to start MySQL using a script which does the following: 1. login to MySQL 2. use a specific database 3. run a update statement 4. exit I have been able to achieve 1 2 by doing the following but not the others. mysql -D test mysql -e UPDATE foo SET bar=1 WHERE baz=2; test For more information check the output of mysql -? Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Debian: Yep, that's GNU/Linux (http://debian.org) - 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 codes
On Mon, Feb 24, 2003 at 07:37:21PM -0800, DiAnNe iRiS aLeRta wrote: i am to make a feature for mysql which is horizontal aggregation for our thesis. is this existing already? if not, is vertical aggregation existing? can you show me the codes for it? i need it to have a basis for developing the horizontal aggregation. horizontal aggregation is collecting values in a ROW based on some grouping criterion and displaying it in horizontal manner. vertical aggregation is collecting values in a COLUMN based on some grouping criterion. thank you so much! Dear Dianne, MySQL supports vertical aggregation. Review http://www.mysql.com/doc/en/Group_by_functions.html As for finding the code that relates to these functions, the best place to start (IMHO :) is by grabbing a copy of cscope and then starting to dig into the code at sql/sql_yacc.yy cscope allows you to interactively browse though C source code (but can also handle C++ well enough) - if you don't have a copy, grab one from http://cscope.sourceforge.net/ Good Luck! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Translucent Databases: An Excellent Guide to Protecting Sensitive Data! Visit http://www.wayner.org/books/td/ for more information - 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 v SAB DB
On Tue, Feb 25, 2003 at 11:29:23AM +, Richard Morton wrote: Hi, My fledgling product is based around a MySQL database, my _first_ customer is asking me to use SAB DB. Obviously this means a bit of re-engineering work and extensive testing. I am looking for peoples experiences of SAP DB, so that I can build a case for continueing with MySQL, (other than that the product works fine with MySQL) Does anyone have such experience. Sorry - I can't offer any real advice here. All of my experience in this area is hearsay. There was a discussion on slashdot that discussed SAPDB - however, there was a pretty high noise-to-signal ratio for the discussion. Is the support as good as MySQL? Who knows? Perhaps ask the same question on the SAPDB community list? :) From what I can see, it is a fully featured DB engine. You can use our crash-me utility to see differences in the feature set implemented between MySQL and SAPDB. This will at least give you some indication. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com AdBusters: Creative Resistance to Consumerism (http://adbusters.org) - 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: Is there a way to time queries?
On Tue, Feb 25, 2003 at 04:36:23PM -0600, databarn wrote: Folk, Two or three years ago, I was using ASP to access SQL Server 7 and MS Access databases. There was a stopwatch dll made by CapRock Software that allowed me to time various elements of my ASP scripts, particularly the database queries. I found several SQL problems that way, and made my queries much faster as a result. Is there anything similar to that stopwatch dll that I could run in my PHP scripts to check the time on my MySQL queries? I'm seeing some slowdowns, but can't quite nail them down, and would like to determine if it is PHP or MySQL that I need to address. Hello, Check out EXPLAIN and the slow query log in the manual. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Display the option files read by the server % mysqld --help - 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: BUG Mysql 3.23.54
On Mon, Feb 24, 2003 at 10:19:01AM +0100, G. Hesen wrote: When using the client library with php: Have you also changed versions of PHP? Earler(earler mysql version) mysqllib: SELECT userfield.*,user.* FROM . [1] =123 [userid] = 123 Now with MySQL 3.23.54 mysqllib: SELECT userfield.*,user.* FROM . [1] =123 [userid] = Here you can see that mysql doesn't give the userid anymore if the userid's are the key to join 2 tables. I corrected this with: SELECT userfield.*,user.*,user.userid as userid FROM . [1] =123 [userid] = 123 Is this is a bug? Or a behaviour change? What does the query return if you run it from the MySQL command line client? Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Toronto, March 24-28, 2003 Visit http://mysql.com/training for more information - 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: redirect mysql output to file
On Mon, Feb 24, 2003 at 10:50:53AM -0700, Mike Doanh Tran wrote: Hi, How do i redirect a mysql output to a file from the command line? For example, I want to save DESCRIBE test_table test_table.file without doing a MYSQLDUMP. Use the mysql command line client from your command line: % mysql --execute \u mysql; DESCRIBE table; table.file -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Upgrading your servers to 4.0.8? Make sure to upgrade your clients to 4.0.8 as well! See http://mysql.com/doc/en/News-4.0.8.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: MySQL Grant issue
On Tue, Feb 25, 2003 at 06:12:26AM +0800, Jon Miller wrote: I had asked in the past the following: In MySQL I need to create a user that has limited privileges (I figure the GRANT command can handle this), just need to know how to make sure they can only view what they have access to, or does the GRANT command handle that also? The grant statement takes care of this as well. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stockholm, February 24-28, 2003 Visit http://mysql.com/training for more information - 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: Very poor Solaris benchmarks
On Thu, Feb 20, 2003 at 02:38:45PM -, Campbell, David wrote: MYSQL Ver 8.23 Distrib 3.23.54, sun-solaris2.8 [binary install] Sun E4500 Hi we have some seriously bad benchmarks for MYSQL performance on a new cluster - The problem seems to be IO, but the box is doing nothing: Can you identify any major differences in system and/or database tuning? Perhaps you are using default config settings on the new server, but tuned settings on the old? -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Dump the structure and/or content of remote databases % mysqldump --host=example.com database_name See http://www.mysql.com/doc/en/mysqldump.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: Very poor Solaris benchmarks
On Fri, Feb 21, 2003 at 01:41:40PM -, Campbell, David wrote: Can you identify any major differences in system and/or database tuning? Perhaps you are using default config settings on the new server, but tuned settings on the old? I have tuned MYSQL using my.cnf settings. Of the two benchmarks one comes from the tests we ran and the others are provided by AB to compare. Tuning MYSQL couldn't/shouldn't account from shocking IO performance should it? Probably not. I admit that I scanned your message very quickly (I am in the middle of a few critical tasks right now) - I just noted that you had received no answers and wanted to see if I could get more details and work up some interest in your question at the same time. :) Have you taken a look at the section of the crash-me source that handles Solaris - we may have tips in there. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: Impress your friends with nifty MySQL one-liners % mysql --execute \u mysql; SELECT DISTINCT user FROM user ORDER BY user; - 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: How do I use COUNT() and DISTINCT together?
Hi David, Use: SELECT COUNT(DISTINCT targetrange) FROM job; Cheers! On Thu, Feb 20, 2003 at 09:03:29PM -0800, Daevid Vincent wrote: Given this table, I want to count the number of distinct targetranges. CREATE TABLE job ( job_id int(10) unsigned NOT NULL auto_increment, customer_id int(10) unsigned NOT NULL default '0', scanner_id int(10) unsigned NOT NULL default '0', status_id int(10) unsigned NOT NULL default '0', changed timestamp(14) NOT NULL, targetrange char(255) default NULL, force_exit tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (job_id), KEY status_id (status_id) ) TYPE=InnoDB; I tried select distinct targetrange from job; and I do get 273 rows. But I would have to use PHP's mysql_num_rows() to get that. I don't need all the rows returned however, just the count(), so I think this method is wasteful and probably will get slower as the db fills up with millions of rows. mysql select count(1) from job; +--+ | count(1) | +--+ | 351 | +--+ Is more of what I want, but how do I combine that with DISTINCT to get something like: +--+ | count(1) | +--+ | 273 | +--+ And also, should I make targetrange an index too to help speed up the query or will it not matter? - 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 -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Washington DC, March 17-21, 2003 Visit http://mysql.com/training for more information - 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: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote: Perhaps the subject will get someone to actually read this and offer even one reply with a suggestion? I admit that the topic got my attention - perhaps not in the best way though. I can offer a few suggestions: Provide more details: - How big is the table you are querying? - What is the query that you are running? - Do you have logging enabled? If so, does it report any error messages/slow queries/etc. - Is this the first time that you have encountered the issue? - etc... Can you upgrade? There have been bug fixes and enhancements in the versions that have been released since x.54. While I am not sure that they would fix your issues, this is a fairly quick thing to test - of course, make sure that you have back ups (just in case)! Also, keep in mind that it is the weekend and that this is a volunteer list. I would guess that our resident FreeBSD guru (Jeremy Z.) is out working on his latest book. Assuming that you have not pissed him off, he may help you out. :) Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL Tip: InnoDB in 4.0.8 supports ON UPDATE foreign key constraints See http://www.mysql.com/doc/en/SEC449.html for more details - 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 Table locking
On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote: Hi all, Can I just check, does MySql v.3.23.52 do table locking or row locking? If it only does table locking, are there any versions of mysql that do row locking? Detailed in the fine manual: http://www.mysql.com/search/index.php?q=locking Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information - 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 Table locking
On Mon, Feb 17, 2003 at 11:22:27AM +0200, Rob wrote: Thanks It would appear that MySql does table locking. Then I would like to ask the following: Hi Rob, I think that you missed some important details. Taken from the manual: MySQL only supports table locking for ISAM/MyISAM and HEAP tables, page-level locking for BDB tables and row-level locking for InnoDB tables. See section 5.3.1 How MySQL Locks Tables ... Does anyone have any suggestions here?? - Ensure that the MyISAM tables are not fragmented. If a MyISAM table is not fragmented, then INSERT and SELECT queries can run concurrently without locking. - Switch to the InnoDB table type - it uses multi-versioning and fine grained locking to improve concurrency. - Use replication to divide the reads and write between two servers and reduce the lock contention. Cheers! -- Zak Greant [EMAIL PROTECTED] MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com MySQL User Conference and Expo April 10-12, 2003, San Jose, California Visit http://mysql.com/training for more information - 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 Feature
On Thu, Feb 13, 2003 at 09:57:06AM -0500, Luc Foisy wrote: I don't think it is possible at the moment, and pretty sure its not standard SQL but it would still be neat to have SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable So in this example, if the expression was true, include that column in the result set, otherwise don't Sure this can be handled outside MySQL and just change the query on condition, just thought it would be nice You can use a WHERE clause to get an effect like this. Something like: SELECT CASE expression WHEN 'value' THEN column ... ELSE 'default result' END FROM Table; Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Load the contents of a text file into a field mysql INSERT table (field) VALUES (LOAD_FILE(/path/to/file)); See http://mysql.com/doc/en/String_functions.html for more details Email signature rotated by Signify v1.10 http://www.debian.org/ - 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 Feature
On Thu, Feb 13, 2003 at 02:10:18PM -0500, Luc Foisy wrote: BUT SELECT Data, CASE WHEN 0 != 0 THEN 'Something' END FROM table will return two columns, Data and CASE WHEN 0 != 0 THEN 'Something' END. It would be better if I could do.. SELECT Data, CASE WHEN 0 != 0 THEN 'Something' AS 'A Column' END FROM table and the result set would only contain one column, Data I am sure people could find a use for it... I don't think this would work the way you like. I am pretty tired right now, but I can't think of another query that could return a variable length list of fields per row. :) -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Allow duplicate values in columns, but force rows to be unique mysql CREATE TABLE lock (t0 TINYINT NOT NULL, t1 TINYINT NOT NULL, UNIQUE combination (t0, t1)); EFF: Protecting Freedoms on the New Frontier (http://eff.org) - 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: Is there a SQL/diff program out there?
On Thu, Feb 06, 2003 at 05:28:03PM -0800, Daevid Vincent wrote: I searched google, but didn't find anything. SYNOPSIS: Wondering if anyone knows of, or has built, or is interested in building a program that will take two .sql schema dumps (one new and one old) and create the ALTER / CREATE TABLE syntax to make the old one look like the new one. It should work in such a way that it doesn't matter if the table's schema are in the same order or not. Hello Daevid, One of the people who submitted a paper to the MySQL User Conference has built a system like this - but AFAIK he has not put it on the web yet. I will write him to ask if he wants to share before the conference. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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: updating some records in a table
On Wed, Jan 15, 2003 at 02:07:42AM -0800, Admin-Stress wrote: Hi, I am new to mySQL, so I need some help. I have a table, which has record structure like this: - customer - name - register_date - expired Every day, I add some records, new customers. The field 'expired' is just a flag, either '1' or '0'. If register_date is 3 months ago then expired = 1. The format of register_date is unixtime, or Epoch. How can I update the entire database, for setting the expired field ? now = current_unixtime(); threemonths = 3 * 30 * 24 * 60 * 60; select * from table_name where register_date + threemonths now Hello Admin-Stress, You can use an UPDATE query to modify one or more fields based on where criteria. Something like this query should meet your needs: UPDATE table SET expired = 1 WHERE expired = 0 AND register_date NOW() - INTERVAL 3 MONTH; For more information, check the MySQL manual (http://mysql.com/doc/en) and review the sections on UPDATE queries and DATE functions. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stuttgart, May 19-23, 2003 Visit http://mysql.com/training for more information EFF: Protecting Freedoms on the New Frontier (http://eff.org) - 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: How to build Relay Replication system ?
On Mon, Feb 10, 2003 at 01:52:36PM +0100, Benjamin Pflugmann wrote: Is this bot somehow endorsed by the list admin / MySQL AB? Hello Benjamin, This bot is not endorsed by MySQL AB. While it was kind of Sherzod to try to improve the utility of the list, the bot makes the list more difficult to use. He has disabled the bot after complaints from list users. Anyhow, could you please stop CC'ing the replies to the list? There is enough mail already without getting a copy triggered by every new question. I am not pleased. Or in other words: There is no additional benefit for subscribers in getting all these automatically generated search results. I am sure that most subscribers know where to look if they want to search the manual. So please, if you must, keep the reply to the original author only. I believe that it would be best for the bot service to be opt-in. I personally dislike the idea of a private automated response system for an otherwise public list. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Toronto, March 24-28, 2003 Visit http://mysql.com/training for more information GreenPeace: Raising Environmental Awareness (http://greenpeace.org) - 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: Is it my English or does this sound bad?
On Wed, Feb 05, 2003 at 03:58:21PM +1300, Defryn, Guy wrote: I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-) Heh. There are still some gems like this in the manual.:) I have let our documentation team know about the awkward wording. Thanks! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Load the contents of a text file into a field mysql INSERT table (field) VALUES (LOAD_FILE(/path/to/file)); See http://mysql.com/doc/en/String_functions.html for more details Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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: Off Topic - PHP/Mysql Development
On Tue, Feb 04, 2003 at 12:32:27PM +0900, kk wrote: I have previously used a company in India and I am not averse to trying this again. You are not supposed to turn your face against all indian companies and just pass your personal comments in a userlist like this. Your experience may be bad with that company becoz you might have looked for some cheaper quality in the past I take the privilege to remind you that most of the CMM Level5 companies sit in India and not near you. If you really look for quality go to those big giants. If you abuse an entire country for your bitter experience then All the Britons will be abused for the reason, our country was looted for more than 150 years by your imperial past. Kayamboo, The phrase not adverse to trying this again means that he *would* work with an Indian company again. Please read carefully before abusing someone else - especially in a public forum. -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Allow duplicate values in columns, but force rows to be unique mysql CREATE TABLE lock (t0 TINYINT NOT NULL, t1 TINYINT NOT NULL, UNIQUE combination (t0, t1)); While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: optimize table failure
On Tue, Feb 04, 2003 at 01:27:13PM +0200, Okan CIMEN wrote: Hi all, First of all , the version of mysql is 3.23.52. I am using When I do a truncate table on a MyIsam table, the show table command shows thatt there are no records but the table size is about 100 MBs. Afterwards, I run an optimize table command and the table size decreases to 2KB's. Everything seems OK but the table_name.MYI and table_name.MYD file sizes are still about 100MB's. When I run all these on 3.23.49 everything works fine. Has anyonew experienced the same problem ? Hi Okan, Could you submit a bug report - others have reported the same problem, but we are still working on fixing them. A bug report will help us find the problem more quickly. For more information, see http://www.mysql.com/doc/en/Bug_reports.html Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql SELECT name, max(score) FROM high_score GROUP BY name; Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: how to change mysql root password
On Fri, Jan 31, 2003 at 03:45:44PM -0500, Jianping Zhu wrote: How to change mysql root password in redhat 7.3 ? http://www.mysql.com/doc/en/Resetting_permissions.html -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Washington DC, March 17-21, 2003 Visit http://mysql.com/training for more information While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: partitionong MyISAM tables??
On Fri, Jan 31, 2003 at 04:36:05AM -0700, Prasanth Krishna wrote: Is there any way to partition MyISAM tables in mysql? i have a huge table and want to partition it. Good Day Prasanth, The MERGE table handler allows multiple MyISAM tables with identical structure (but different data) to be presented as a single database. This is similar to range partitioning. Visit http://www.mysql.com/doc/en/MERGE.html for more information. Do InnoDB tables support partitioning? thanks. AFAIK InnoDB does not support partitioning. -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Nuernburg, June 02-06, 2003 Visit http://mysql.com/training for more information Debian: Yep, that's GNU/Linux (http://debian.org) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie Q: Booleans??
On Fri, Jan 31, 2003 at 10:16:05PM +1030, David Hefford wrote: Have used many databases but am just getting into MySQL and am totally rapt about it :) I am writing a front end in realBasic that needs to be able to run on various backends, MySQL being the main one. All of the others have a boolean type of column. What is the general practice to ?mimic? a BOOLEAN field in MySQL? PS: I do not need NULL or date for example, I just need true or false, yes or no etc... Hello David, Column types BIT/BOOL are available. (However, they are mappings to TINYINT(1). :) Perhaps check the list archives - this question has been asked in the past as well. IIRC, there are discussions on whether or not it should be implemented. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Use your favorite editor to edit queries within the mysql client mysql \e While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: User Accounts...
On Fri, Jan 31, 2003 at 10:55:18AM -0300, Alejandro C. Garrammone wrote: How can I create different user accounts for a table?. (I've just installed the MySQL, and the root just don't have a password yet..how can assign one? Hey Alex, Check out the user account management section of the manual: http://www.mysql.com/doc/en/User_Account_Management.html Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Toronto, March 24-28, 2003 Visit http://mysql.com/training for more information My punctuality is well known. When the revolution takes place, I'll be late and I'll be shot as a traitor. --Traitor by the SugarCubes - 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 : Dropping foreing key without losing data
On Fri, Jan 31, 2003 at 08:46:53AM +0100, Webmaster LLBfrance wrote: Hello Zak, Thanks for your response. I try the way you told me, but it seems there is another problem : The old foreign keys always exist. In consequence, there are double references. How can i resolve that problem ? Ah... e... let me do some testing. In the past, simply running alter table would drop the foreign keys. Now that things are different, I will have to see what works (or ask Heikki about it) Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Show the configuration options set in the server % mysqld --print-defaults Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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: Question about Table_Options
On Fri, Jan 31, 2003 at 10:39:13AM +, Jonathan Bedford wrote: Hi When creating a table can you use multiple Table_Options? Heh. Why not just try it? :) The O'Reilly Managing Using MySQL show on page 288 a table been created with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB; No comma is needed. But the MySQL manual says or:- table_options: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } orAUTO_INCREMENT = # . Hrm. It does not look like we explicitly state that you can use multiple options anywhere on the CREATE TABLE page in the manual. I will ask our documentation team to fix it. Thanks! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stuttgart, May 19-23, 2003 Visit http://mysql.com/training for more information Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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: # of connected user
On Fri, Jan 31, 2003 at 01:49:24PM +0200, Mustafa Yelmer wrote: How i list connected users(active) to mysql server? it is important to know connected users for me? Mysql runs in server-client system, and each host of clients are different (i assume) Good Day Mustafa! You can get a list of the various connections and connection states using SHOW FULL PROCESSLIST. See http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html in the manual. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Upgrading your servers to 4.0.8? Make sure to upgrade your clients to 4.0.8 as well! See http://mysql.com/doc/en/News-4.0.8.html Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: Autoincrement : how does it work / how to reset it
On Fri, Jan 31, 2003 at 06:48:45AM -0800, Robert Mena wrote: Hi, I have been using autoincrement fields for some time but was wondering how does it work in some special situations. Ex. suppose I have an autoincrement field called num and the last one has value of 10. I delete the last on and insert a new one. Which value will it have ? 10 or 11 Hi Robert, Why not test them on your own? :) Anyhow... 11 I read that if I issue a query delete * from table and delete from table I have diferent results (in regards to the auto increment field). Is this correct ? For MyISAM tables, if you run DELETE FROM table, the AUTO_INCREMENT field will be reset to default. There is an exception: if you set AUTO_INCREMENT in a secondary column in a multi-value primary key, then deleting the highest value in the secondary column will allow that value to be reused in the auto-increment sequence. i.e. CREATE TABLE user_log ( id SMALLINT UNSIGNED NOT NULL, event MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (user_name, event) ); mysql INSERT user_log (id) VALUES (1),(1),(1); Query OK, 3 rows affected (0.00 sec) mysql SELECT * FROM user_log; ++---+ | id | event | ++---+ | 1 | 1 | | 1 | 2 | | 1 | 3 | ++---+ 3 rows in set (0.00 sec) mysql DELETE FROM user_log WHERE id=1 AND event=3; Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM user_log; ++---+ | id | event | ++---+ | 1 | 1 | | 1 | 2 | ++---+ 2 rows in set (0.00 sec) mysql INSERT user_log (id) VALUES (1); Query OK, 1 row affected (0.00 sec) mysql SELECT * FROM user_log; ++---+ | id | event | ++---+ | 1 | 1 | | 1 | 2 | | 1 | 3 | ++---+ 3 rows in set (0.00 sec) Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Hamburg, March 24-28, 2003 Visit http://mysql.com/training for more information While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: line breaks
On Fri, Jan 31, 2003 at 06:22:50PM +0200, Tarik Kutluca wrote: Hi, From a web form I am collecting information to a table. On the form there is a textarea element storing to a text field on the mysql table. Since the textarea can hold the enter key, it's stored in to the field also, but when i try to call that cell and display it on the web page, i see that line breaks are ignored. But the sentences must be displayed as they are entered. - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, - do you have a shorter way to do this? When HTML agents display text, they are supposed to fold all whitespace characters (newlines, tabs, spaces) into a single space character unless the text is contained in a pre/pre block. The characters that make up a new line sequence vary depending on the operating system of the client. Unix-like OSs use ASCII character code 10, Windows uses 13 followed by 10 and Macs (but likely not OS X+) use 13. If you are using PHP, just call nl2br() on the text before you display the text. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Show the configuration options set in the server % mysqld --print-defaults My punctuality is well known. When the revolution takes place, I'll be late and I'll be shot as a traitor. --Traitor by the SugarCubes - 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: Dropping foreing key without losing data
On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote: Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Hello JeanClaude, Unfortunately, foreign keys cannot currently be conveniently dropped. :( The InnoDB developer plans to implement this in the near future. The only option currently is to recreate the table structure, move the data into the new table, drop the old table and then rename the table. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: San Francisco, February 03-07, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - 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 Truncated returns
On Thu, Jan 30, 2003 at 11:40:06AM -0500, Anna Noel Leavitt wrote: Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set at 30 so it is not a length issue). I tried changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Hello Anna, It sounds like the data is getting truncated before it reaches MySQL or after it is selected and displayed. Try echoing out the query that you are sending to MySQL using PHP. Does the query look well-formed and complete? If not, then it is likely a problem in the PHP code. If the query seems fine, then try selecting the data directly using the MySQL command line client? i.e. mysql -uuser -p -eSELECT col FROM table WHERE col like 'Tampa'; Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information GreenPeace: Raising Environmental Awareness (http://greenpeace.org) - 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: How can I start my mysql server with max_connections option
On Thu, Jan 30, 2003 at 10:46:27PM +0530, [EMAIL PROTECTED] wrote: Hi Group, I want to start my mysql with max_connections option. Now I am getting To many connction error. So I want to allow 200 concurrent connections... I tried with safe_mysqld max_connections=200 But it is not coming up... How can I set max_connections as 200. Do I need to specify that in my.cnf Good Day! You are very close. :) Use safe_mysqld -O max_connections=200 Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Brisbane, February 24-28, 2003 Visit http://mysql.com/training for more information Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: examples of user defined functions
On Wed, Jan 29, 2003 at 09:22:50AM -0500, Bill Lovett wrote: I was reading about user defined functions, and although they sound interesting, I can't find many examples of their use. If anyone is using them, what are you using them for? Are they a way to manipulate data going into a record, or a way to run pre-defined queries? Brian Aker has some examples online @ http://software.tangent.org/ Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql SELECT name, max(score) FROM high_score GROUP BY name; Email signature rotated by Signify v1.10 http://www.debian.org/ - 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: copying a row
On Thu, Jan 30, 2003 at 04:13:17PM +0100, W. Enserink wrote: Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? Dear Wilbert, INSERT ... SELECT almost allows you to do this, however you cannot select from the same table that you are inserting into. You will need to do something like this: CREATE TEMPORARY TABLE temp SELECT field_1, field_2, field_3 FROM table WHERE field_1 100; INSERT table (field_1, field_2, field_3) SELECT (field_1, field_2, field_3) FROM temp; DROP TABLE temp; Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Hamburg, March 24-28, 2003 Visit http://mysql.com/training for more information Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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 dump for remote db
On Tue, Jan 28, 2003 at 10:19:19AM -0700, Mark Stringham wrote: Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. If you have access to a host that runs cron, run mysqldump with the -h option. i.e. mysqldump -hmysql.example.com -usomeuser -p database name Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stockholm, February 24-28, 2003 Visit http://mysql.com/training for more information Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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 and SQL
On Fri, Jan 17, 2003 at 04:29:36PM -0500, Poon, Kelvin (Infomart) wrote: Thanks a lot that's very clear...but you help me clear up some more? The reason I asked is because I got this new project that requires me to make a webpage with PHP that collects information from the dbs of ths new server we brought...SQL 2000 server. Like it is a SQL server so I thought I would need to know how to use PHP with SQL. That's when I got mixed up with mySQL and SQL. I started reading things that uses PHP and connects to mySQL...so like ...for my case I can't use mySQL right? because my server is not a mySQL server right? THen what do I need basically?...coz a SQL 2000 server uses a SQL Query Analyer to do the SQL statments right? DO you know what I want to do? Hey Kelvin, As this is a MySQL mailing list, not a lot of questions about MS SQL server get asked or answered. :) However, it sounds like you are in a bit of a rough spot - here is some information to get you started. PHP can connect to many different databases - MS SQL Server included. Go to http://php.net/mssql for more information on using PHP with SQL server. If you do have more questions, there is PHP database mailing list to answer your questions (see http://www.php.net/mailing-lists.php). I would recommend that you write to the database mailing list. Another good resource for you is PHP Programming for Windows by Andrew Stopford (published by New Riders) Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Allow duplicate values in columns, but force rows to be unique mysql CREATE TABLE lock (t0 TINYINT NOT NULL, t1 TINYINT NOT NULL, UNIQUE combination (t0, t1)); My punctuality is well known. When the revolution takes place, I'll be late and I'll be shot as a traitor. --Traitor by the SugarCubes - 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 dump not working
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\binmysqldump ? Hi Mark, To rephrase: If you run the command mysqldump -u uipcontent -p test on the command line, what happens? Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Houston, February 17-21, 2003 Visit http://mysql.com/training for more information Open Source Initiative (http://www.opensource.org) - 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 dump not working
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: sql, query I'm trying to utilize the mysqldump utility to backup my db on a WIN2k advanced server. I'm running a BAT file with the following syntax c:\apache\mysql\binmysqldump -u uipcontent -p test c:\testdump.sql the file testdump.sql gets created in the appropriate place but the file itself has nothing in it. I'm obviously missing something. Do you see any output when you run mysqldump without redirecting stdout? -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information Support Global Human Rights - Amnesty International (http://amnesty.org) - 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: Avg_row_length
On Thu, Jan 16, 2003 at 06:47:03PM +0100, Stefan Hinz wrote: Keith, thanks once again! Well, anyone here from the MySQL developer team? Or any other guru who can explain why 10 = 11? Hi Stefan, Here is my guess. ;) CHAR columns are fixed width. A CHAR column with a width of 10 will always require 10 bytes - regardless of what is put into it. If the column also allows NULL values, then the length of all columns becomes 10 bytes + 1 byte for the NULL. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Nuernburg, June 02-06, 2003 Visit http://mysql.com/training for more information Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: Authenticating users
On Thu, Jan 16, 2003 at 01:13:54PM -0300, Cesar Aracena wrote: Hi all, I have this admin site where the administrators can add new ones of their kind (admin level) and now I'm trying to make a query so no usernames are duplicated in MySQL. The query goes like this: $query1 = SELECT * FROM r2k_admin WHERE adminuser = $user; Hello Cesar, A general tip for this kind of situation is: Try displaying the query you are running and then try to run the displayed SQL in the MySQL command line client. i.e. echo $query1, \n; However, for this specific problem, you need to quote $user in your query. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Nuernburg, June 02-06, 2003 Visit http://mysql.com/training for more information AdBusters: Creative Resistance to Consumerism (http://adbusters.org) - 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: Uninstall MySQL?
On Wed, Jan 15, 2003 at 07:18:46AM -0700, Tyler wrote: Can someone please guide me in uninstalling all the failed installs of MySQL I've got? I've installed like 2 binaries, and 1 source.. none work :( Dear Tyler, You will need to be more specific. What operating system did you do the installs on, where did you try to install, etc. Generally, (under Unix-like OSs) it is just a matter of removing the installations directories /usr/local/mysql- and fixing your startup scripts (if you modified them). -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Allow duplicate values in columns, but force rows to be unique mysql CREATE TABLE lock (t0 TINYINT NOT NULL, t1 TINYINT NOT NULL, UNIQUE combination (t0, t1)); While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: Confirmation of SELECT...IN syntax
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote: you are correct - subselects are NOT allowed until version 4 Subselects will be available in version 4.1 -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Paris, March 17-21, 2003 Visit http://mysql.com/training for more information GNU/Free Software Foundation (http://www.gnu.org) - 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: indexing a blob
On Tue, Jan 14, 2003 at 10:10:02AM +0200, Octavian Rasnita wrote: Can I index just a smaller number of characters from a field even though the field has more? Will this make MySQL to index that field faster? Good Day Octavian, You can index part of a column with the syntax INDEX index_name (col_name(length)) Doing this requires less space for storing the index and should make index generation/manipulation faster. Please see http://www.mysql.com/doc/en/Indexes.html Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Impress your friends with nifty MySQL one-liners % mysql --execute \u mysql; SELECT DISTINCT user FROM user ORDER BY user; Public Service Announcement: Open Source Initiative (http://www.opensource.org) - 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: Foreign keys
On Tue, Jan 14, 2003 at 12:20:06PM +0200, Octavian Rasnita wrote: I've read the following text in a book: ANSI SQL supports a special kind of key called a foreign key. Foreign keys help protect database integrity by enabling the database to manage things such as the deletion of rows with dependent relationships in other tables. Though MySQL supports the ANSI syntax for foreign keys, it does not actually use them to perform integrity checking in the database. This is a situation in which the introduction of a feature would cause a slowdown in performance with little real benefit. Applications themselves should generally worry about foreign key integrity. What does this mean? This means that the book is out of date. :) Does MySQL allow using foreign keys or not? The InnoDB table type has some support for foreign keys. Read more at http://www.mysql.com/doc/en/SEC449.html Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Display the option files read by the server % mysqld --help Email signature rotated by Signify v1.10 http://www.debian.org/ - 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: details needed
Hello, I want to know whether the mysql depot (mysql-3.23.54a) works on HP-UX PA_RISC2.0 or it works only on PA_RISC1.0. If it doesn't work on PA_RISC2.0, where can I find a mysql depot that works on PA_RISC2.0? Hello, One of our developers recommends that you use the MySQL binaries for HP-UX, rather than the binaries from the HP-UX depot. If you visit http://www.mysql.com/downloads/index.html you can choose to download MySQL 3.x or 4.x. Once you have chosen a version to download, you can select binaries built for HP-UX 11.11 / RISC 2.0 Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL User Conference and Expo April 10-12, 2003, San Jose, California Visit http://mysql.com/training for more information Support Global Human Rights - Amnesty International (http://amnesty.org) - 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: Upgrading to version 4.
On Mon, Jan 13, 2003 at 03:45:59PM -0300, Maximo Migliari wrote: In the MySQL manual, under http://www.mysql.com/doc/en/Upgrading-from-3.23.html it says: --- The old C API functions mysql_drop_db, mysql_create_db, and mysql_connect are not supported anymore, unless you compile MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might be wrong, but I would like to just double check. The PHP MySQL API will still work for you. Additionally, there is a new API that is currently in development that is intended to support the new features of MySQL like SSL connections, prepared statements, etc. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql SELECT name, max(score) FROM high_score GROUP BY name; Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: Blobs
On Fri, Jan 10, 2003 at 04:36:07PM -0600, Terry Cheryl Haimann wrote: Is there an easy way to see If and how much data I have written into a blob? You can find the length of a blob in bytes using the LENGTH function: SELECT LENGTH(column) FROM table; You can also use BIT_LENGTH to find the length in bits. Cheers! :sql: -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: New York, January 13-17, 2003 Visit http://mysql.com/training for more information While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: Question
On Fri, Jan 10, 2003 at 11:50:28PM -0500, David T-G wrote: George -- ...and then Gman said... % % How can I delete a database in MySQL so I recreate it? echo 'drop database dbname' | mysql -uuser -ppassword where dbname is the name of your database, user is your mysql user name, and pass is the password for that user. More in the manual :-) I bet that he wants to be able to recover it after the delete! :) George, to truly recreate a database after delete, you will need to have a backup copy of the database. You can create the backup with the mysqldump utility, with replication or by copying the data files. See http://mysql.com/doc/en/Backup.html for more details. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Connect to a remote MySQL server using the mysql client % mysql --host=example.com --user=admin -p While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: relations between tables
On Fri, Jan 10, 2003 at 04:54:14PM +0200, Octavian Rasnita wrote: Hi all, Is MySQL able (like MS Access) to define permanent relations between tables? For example, I want to define a master - child relation between 2 tables so when deleting some entries from the master table to automaticly delete the entries from the details table without specifying this in the query. Dear Teddy, The InnoDB table type supports this type of functionality - see http://www.mysql.com/doc/en/SEC449.html for more details Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Upgrading your servers to 4.0.8? Make sure to upgrade your clients to 4.0.8 as well! See http://mysql.com/doc/en/News-4.0.8.html While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: Dumping remote DB
On Fri, Jan 10, 2003 at 01:53:55PM -0300, Cesar Aracena wrote: Hi all, I use MyCC 0.8.6 to work around remote data bases, and I need to dump the structures of all of them (also their contents). Can it be done? What SQL query should I use? Hello Cesar, Use the mysqldump utility. % mysqldump --host mysql.example.com For more information, see: http://www.mysql.com/doc/en/mysqldump.html Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL User Conference and Expo April 10-12, 2003, San Jose, California Visit http://mysql.com/training for more information Public Service Announcement: Open Source Initiative (http://www.opensource.org) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Off-Topic Posts
Dear Readers, Over the last week there have been a series of messages posted to this list that were off-topic, inflammatory and often offensive. Our list manager contacted the offending parties and requested that they stop their abuse of the mailing list. When this failed to stop the postings, the administrator unsubscribed the offending user from all MySQL mailing lists and revoked their posting privileges. It is unfortunate that these actions were required. The MySQL mailing lists are a shared resource for the global MySQL community. While we are fortunate to have members from many or all of the wired countries in the world, it means that it is almost inevitable that there will occasionally be fundamental differences of belief between list members. We ask people to avoid these conflicts and instead focus on the co-operative and community aspects of the list. To help maintain the MySQL lists as a friendly, helpful and useful resource, we must request that people *do not respond to off-topic posts*. If you do feel compelled to respond, please do so off of the mailing list. If you find a post to be offensive, please notify our list administrators at [EMAIL PROTECTED] - we will deal with the situation as best we can. If you wish to discuss this situation further, please mail me *off-list* at [EMAIL PROTECTED] Yours Truly, Zak Greant MySQL Community Advocate - 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: Year data type
On Thu, Jan 09, 2003 at 10:48:18AM -0800, [EMAIL PROTECTED] wrote: It seems odd to me that the data type Year, should only allow the limited range of 1901-2155. i understand that this is so that it will store in 1 byte, but whats the point? i wanted to use a year field for historical data, such as the year famous people were born, such as abe lincoln - 1809, but surprise surprise 1809 is unacceptable. so i guess i dont see the point of the year datatype. i would be interented in any insight as to why the year type is like this. Hello Sean, I don't speak for Monty here, but I would guess that you have hit the nail on the head. The years 1901-2155 are useful for a large segment of user data. Being able to store year information for account expiry dates, etc. in a single byte can be a considerable space savings when looking at a large database. This range of values could be represented by a TINYINT - however, this would require extra logic to conver the TINYINT to a year value. If you want to store years outside the range of YEAR, use the SMALLINT data type - it allows you to easily represent the years 32768 BC to 32767 AD. -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Connect to a remote MySQL server using the mysql client % mysql --host=example.com --user=admin -p Public Service Announcement: Open Source Initiative (http://www.opensource.org) - 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 - select syntax if else
On Wed, Jan 08, 2003 at 03:27:51PM +0200, Svens Klave wrote: Can anybody help me with select query how to do this: I have table foo1 with two fields image check | image | check | | 6782 | 0 | | 2732 | 1 | | 6734 | 1 | so I want to make query select * from foo1 where [so is it possible to make some if check=1 then image is image but if check=0 then into image goes other content for example noimage] I mean I need to check if there is 0 or 1 and so if check is 1 then show original number from image field but if there is 0 then it changes original content to noimage so then is possible to optimise my database otherwise I need to do this with web development scripts to check if I have image name like in image field so its sucks so maybe somebody can help me with that ok Good Day Svens, You can permanently change the database using the following query: UPDATE foo1 SET image='noimage' WHERE check=0; Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Washington DC, March 17-21, 2003 Visit http://mysql.com/training for more information Public Service Announcement: Sincere Choice (http://sincerechoice.org) - 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: converting text to hypertext
On Wed, Jan 08, 2003 at 08:34:25AM -0800, Rick Tucker wrote: I just imported a .csv file and one of the columns of data was websites addresses. Those addresses aren't being recognized as links when I output an html table from my queries. I'm scratching me head on how to make the conversion. I figured there would by a hypertext datatype of some sort, but I can't find any information regarding this issue. If someone could point me in the right direction, I would appreciate it. Good Day Rick! There is no hypertext/hyperlink data type and I do not know of any plans for one. A simple bit of shell scripting like: mysql -e SELECT something FROM somewhere -H |\ sed -e 's/http:\/\/[^ ]\+/a href=\/a/' should replace all of the valid http URLs in your HTML tables with anchors. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: London, January 13-17, 2003 Visit http://mysql.com/training for more information While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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: Row value uniqueness?
On Wed, Jan 08, 2003 at 10:27:30AM -0800, Steven Nakhla wrote: Aside from designating a row as a primary key, is their any SQL syntax to force that entries within a row are unique (such as a string value)? Thanks! Hello Steve, You can create a UNIQUE key for a column that will ensure that all values entered into the column are unique. i.e. CREATE TABLE foo ( ..., ..., UNIQUE (...) ) If you truly want to ensure that a row is unique, then you can create a UNIQUE key that contains all of the columns in a table. This will allow you to enter duplicate values within the columns, but the combination of values (in this case, an entire row) must be unique. i.e. CREATE TABLE combolock ( tumbler_1 INT NOT NULL, tumbler_2 INT NOT NULL, tumbler_3 INT NOT NULL, UNIQUE tumblers (tumbler_1, tumbler_2, tumbler_3) ) mysql INSERT INTO combolock VALUES (1,1,1); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO combolock VALUES (1,1,1); ERROR 1062: Duplicate entry '1-1-1' for key 1 mysql INSERT INTO combolock VALUES (1,1,2); Query OK, 1 row affected (0.00 sec) Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stockholm, February 24-28, 2003 Visit http://mysql.com/training for more information While we are postponing, life speeds by.--Lucius Annaeus Seneca - 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 history
On Tue, Jan 07, 2003 at 11:09:15AM +0530, [EMAIL PROTECTED] wrote: Is there anyone on this list who can point me to a link that talks about MySQL history - how it began, original creators and vision, evolution over time to 4.x, etc? Hello Vikram, Linux Journal has an article from '99 that lists the early history. The article is at http://www.linuxjournal.com/article.php?sid=3609 I believe that David Axmark has a more up-to-date information. I will query him to see what I can turn up. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Connect to a remote MySQL server using the mysql client % mysql --host=example.com --user=admin -p Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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: Problems with alias names in WHERE clause
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 10, 2002 23:25, Zak Greant wrote: On September 10, 2002 22:32, Paul DuBois wrote: ... You can't refer to aliases in WHERE clauses. Aliases refer to columns that have been selected, WHERE clauses determine which columns should be selected. In essence, WHERE refers to input columns, which occurs earlier than the aliases (which refer to output columns). Hi Nicholas, You may be able to get the effect that you desire using user variables. (see http://www.mysql.com/doc/en/Variables.html for details) The following query using user variables *might* work for you :) SELECT i.id image_id, @photo_id := ifnull(i.photographer,6)photo_id, @owner_id := ifnull(i.owner,6)owner_id, concat(cp1.fname,' ',cp1.lname) photo_id, concat(cp2.fname,' ',cp2.lname) owner_name, FROM image i, common.persons cp1, common.persons cp2 WHERE i.id='8200' AND @photo_id=cp1.id AND @owner_id=cp2.id; Before anyone goes off and tries this, let me assure that I am completely wrong here. :) As Paul kindly pointed out off-list, the variables in this query will only be set when conditions in the WHERE clause are met. Now, given that the WHERE clause is attempting to use variables that can only be set when it is successful... :) Embarrassedly Yours, - -- Zak Greant [EMAIL PROTECTED] MySQL Community Advocate Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr Gosh, Batman! The nobility of the almost-human porpoise. --Robin -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9gV1tb6QONwsK8bIRAuj9AJ9fqYsa/ff7FTXeoYlsdZsXgg6FugCeIjpb oc/oXLSvD/PnUpY9y0L8eKE= =7n14 -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: Problems with alias names in WHERE clause
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 10, 2002 22:32, Paul DuBois wrote: ... You can't refer to aliases in WHERE clauses. Aliases refer to columns that have been selected, WHERE clauses determine which columns should be selected. In essence, WHERE refers to input columns, which occurs earlier than the aliases (which refer to output columns). Hi Nicholas, You may be able to get the effect that you desire using user variables. (see http://www.mysql.com/doc/en/Variables.html for details) The following query using user variables *might* work for you :) SELECT i.id image_id, @photo_id := ifnull(i.photographer,6)photo_id, @owner_id := ifnull(i.owner,6)owner_id, concat(cp1.fname,' ',cp1.lname) photo_id, concat(cp2.fname,' ',cp2.lname) owner_name, FROM image i, common.persons cp1, common.persons cp2 WHERE i.id='8200' AND @photo_id=cp1.id AND @owner_id=cp2.id; Cheers! - -- Zak Greant [EMAIL PROTECTED] MySQL Community Advocate Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr Gosh, Batman! The nobility of the almost-human porpoise. --Robin -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9ftPQb6QONwsK8bIRAiFKAJ9xRnNM+Nn0JiFj8AV0GEch0YKVDQCdE8uv kRA6OKVYj8AU9WrPnq/BuI8= =HI5o -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