New to MySQL
Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to answer myself after a day on the web. 1. What is InnoDB? 2. Are their direct API's for Apache and MySQL and how reliable are they? Any other references would be useful and welcome! Thanks Jeremy - 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: Installation problem: mysql.sock missing (??)
Do a locate mysql.sock it's there. Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock M;) On Sat, 2002-08-24 at 21:34, Roger Young wrote: I'm trying to install the binary mysql-3.23.52 under Linux (Slackware 8.2 distribution, kernel 2.4.18). I have followed the installation steps suggested in the INSTALL-BINARY file. However the daemon will not start, or rather it startd and immediately exits, and there is this message in the error log 020825 11:03:14 mysqld started 020825 11:03:14 Can't start server : Bind on unix socket: No such file or directory 020825 11:03:14 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 020825 11:03:14 Aborting In fact neither the socket nor the socket directory /var/run/mysql have been created. I created the directory but still got the same error. How do I properly install mysql? Thanks for your help, Roger Young - 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: Does FIND_IN_SET() require SET column type?
Hi. On Sat 2002-08-24 at 13:29:02 -0600, [EMAIL PROTECTED] wrote: When I say: SELECT * FROM product WHERE FIND_IN_SET(1, cat_id); Does cat_id have to be of SET value. No. It just has to be a comma-seperated list of values (where values also may be none or one, i.e. no commas there). You can easily test for yourself by trying SELECT FIND_IN_SET( 1, -5,0,1,4,5, ) that it not even requires a column. The thing is, I cannot make it set column-type, since I have no idea what values it will be holding, but at the same time it will be comma seperated list of integers. So I'll have to make it either VARCHAR or TEXT. The advantage of SET columns is that they are handled as binary internally, i.e. it uses less space and searches are faster. If that does not matter in your case, you will do fine with VARCHAR (or TEXT). Regards, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SecurityFocus HOME Mailing List: BugTraq; Possibly Feature Request
Hello. (This is more an additional answer to the original mail than to the one I replied to). On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote: On Sat, 2002-08-24 at 18:38, Van wrote: Just thought I'd pass it along, since I haven't seen Monty and crew address it. I think that it is a non-issue and that this already has been convered in the BugTraq thread. [...] This BDA individual appears to have a point on a configuration option that allows an exclude to prevent localhost from getting denied due to the eleven bad connection (ex. Bad Handshake) problem. I don't agree that he has a valid point. More specifically, It's not a bug, it's a feature. Seconded. Since I'm not familiar with the error-handling code that deals with this, I'd offer a suggestion that rather than just ignoring excessive bad connections from localhost an admin notification (via e-mail or console message, perhaps) be sent when localhost is exhibiting this behavior so someone can intervene before it becomes a problem and DoS-es itself. This is the task of an monitoring system, not of MySQL. It is standard procedure to have a monitoring system on a production system (at least, if outages cause some form of damages). I have mon running and should an important IP get blocked (for whatever reason), I will get a mail two minutes later. The advantage of this method is that you get notified for any reason the access does not work, not only blocked IPs. Additionally, a monitoring system if flexible, in when, how often, how and whom to notify. You do not want to build all this into MySQL, do you? (And without, the feature could trigger thausands of mails in an DDoS attack). As I said, this is the task of a monitoring system. If you can code something like this (that can be turned off by default or by config, because I _want_ the behavior you want to remove) that is portable (i.e. works on Windows), then feel free. As should be clear from above, I am rather against it, even if it could be done easily. If at all, I would suggest to implement a trigger system, into which some other program can hook in, if it wants to know about special events. But then, the problem can be handled by existing means, so why bother? Regards, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to MySQL
Hello. On Sun 2002-08-25 at 02:36:35 -0700, [EMAIL PROTECTED] wrote: Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to answer myself after a day on the web. 1. What is InnoDB? InnoDB is a table type for MySQL. ISAM (obsolete), MyISAM and BDB are other table types currently implemented. A table type determines (some of) the attributes of a table, i.e. how it is physically stored, which features it offers and so on. E.g. Transactions are only supported with InnoDB and BDB, but neither with ISAM or MyISAM. That said, as long you are not sure what you need, don't care. Simply go with MyISAM tables which are the default, until you learn that your needs differ: It is a one-liner to change the table type (ALTER TABLE) at any time, so there is no reason to decide early. 2. Are their direct API's for Apache and MySQL and how reliable are they? I am not sure, if I understand you correctly. If you mean if there is some build-in server-side (Apache) language, which you can use to query the database and create dynamic pages, the answer is No, because that goes against the design concept of Apache. It is an web-server, not a do-it-all. That said, Apache offers the facility to plug in Modules for tasks, and there are some modules readily available for this: The best-known is probably PHP, and I suggest to go with it, if you do not know better. There are also modules for e.g. Perl, Python and so on. If you meant something different, please elaborate. Regards, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to MySQL
Subject: Re: New to MySQL From: Benjamin Pflugmann [EMAIL PROTECTED] === Hello. On Sun 2002-08-25 at 02:36:35 -0700, [EMAIL PROTECTED] wrote: Recently I have been approached to do a web based reservations database for hotels. I am thinking highly of using MySQL on Linux(?) with Apache. I have used Informix SE on SCO Unix for years (due to the previous platform) and would like to ask you all a few questions I have not been able to answer myself after a day on the web. 1. What is InnoDB? InnoDB is a table type for MySQL. ISAM (obsolete), MyISAM and BDB are other table types currently implemented. A table type determines (some of) the attributes of a table, i.e. how it is physically stored, which features it offers and so on. E.g. Transactions are only supported with InnoDB and BDB, but neither with ISAM or MyISAM. That said, as long you are not sure what you need, don't care. Simply go with MyISAM tables which are the default, until you learn that your needs differ: It is a one-liner to change the table type (ALTER TABLE) at any time, so there is no reason to decide early. 2. Are their direct API's for Apache and MySQL and how reliable are they? I am not sure, if I understand you correctly. If you mean if there is some build-in server-side (Apache) language, which you can use to query the database and create dynamic pages, the answer is No, because that goes against the design concept of Apache. It is an web-server, not a do-it-all. That said, Apache offers the facility to plug in Modules for tasks, and there are some modules readily available for this: The best-known is probably PHP, and I suggest to go with it, if you do not know better. There are also modules for e.g. Perl, Python and so on. If you meant something different, please elaborate. Regards, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: spanish books about mysql?
Are there any mysql books in Latin? Me sequelae datorum ordinatrum, scribo Paulus ExSilvaticus - when you write the rest yourself you may find the following useful/entertaining Vocabula computatralia Vocabula computatralia. A. abort 1. vt interrumpere 2. subst. interruptus,us m. address 1. (memory location) subst. locus (memoriae ... Description: Vocabulario anglico-latino Draconis editio secunda, anno MCMXCIX. Category: World Lingua Latina Computatra www.obta.uw.edu.pl/~draco/docs/voccomp.html - 21k - Cached - Similar pages Regards, =dn At 11:01 +0200 8/24/02, Markus Jais wrote: hello I searched amazon.com for spanish books about mysql or postgresql but I couldn't find anything. and there is no amazon.es. does anybody know if there is a online shop where I can search for spanish books about mysql??? I don't know of a shop, but I know of at least one MySQL book that is available in Spanish: http://www.kitebird.com/mysql-book/translations.php thanks in advance markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation problem: mysql.sock missing (??)
Thanks for your reply. Do a locate mysql.sock it's there. For some reason on my machine the mysql install procedure does not create the socket. The locate utility (after updatedb) does not find mysql.sock and the socket directory /var/run/mysql is not established. I must be omitting some vital step but what is it? The mysql package is untarred in /usr/local The scripts/mysql_install_db is run. But the socket is missing... Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock Didn't have much luck with this either: Sorry, but search returned no results. I did go through the August messages but couldn't find anything relevant. What part of the install procedure sets up the socket? Would it be better to compile from the source rather than from the binary package? Thanks for any further help or comment. Roger Young Do a locate mysql.sock it's there. Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock M;) On Sat, 2002-08-24 at 21:34, Roger Young wrote: I'm trying to install the binary mysql-3.23.52 under Linux (Slackware 8.2 distribution, kernel 2.4.18). I have followed the installation steps suggested in the INSTALL-BINARY file. However the daemon will not start, or rather it startd and immediately exits, and there is this message in the error log 020825 11:03:14 mysqld started 020825 11:03:14 Can't start server : Bind on unix socket: No such file or directory 020825 11:03:14 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 020825 11:03:14 Aborting In fact neither the socket nor the socket directory /var/run/mysql have been created. I created the directory but still got the same error. How do I properly install mysql? Thanks for your help, Roger Young - 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: SecurityFocus HOME Mailing List: BugTraq; Possibly Feature Request
Benjamin Pflugmann wrote: On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote: On Sat, 2002-08-24 at 18:38, Van wrote: Just thought I'd pass it along, since I haven't seen Monty and crew address it. I think that it is a non-issue and that this already has been convered in the BugTraq thread. But, not covered in a post from a MySQL AB representive. The BugTraq thread usually doesn't end unless / until such an event occurs... Since I'm not familiar with the error-handling code that deals with this, I'd offer a suggestion that rather than just ignoring excessive bad connections from localhost an admin notification (via e-mail or console message, perhaps) be sent when localhost is exhibiting this behavior so someone can intervene before it becomes a problem and DoS-es itself. This is the task of an monitoring system, not of MySQL. It is standard procedure to have a monitoring system on a production system (at least, if outages cause some form of damages). I have mon running and should an important IP get blocked (for whatever reason), I will get a mail two minutes later. The advantage of this method is that you get notified for any reason the access does not work, not only blocked IPs. Additionally, a monitoring system if flexible, in when, how often, how and whom to notify. You do not want to build all this into MySQL, do you? (And without, the feature could trigger thausands of mails in an DDoS attack). As I said, this is the task of a monitoring system. Perhaps in your world monitoring systems lie in constant function all over the place, and I assure you they do in my own without the nuisance of thousands of e-mails in my inbox (ever), but the vast majority of other peoples' systems lie exposed on the Internet at large, absolutely unsupervised. My clients' systems, and probably your client systems probably have no entries in wtmp except your own. And, since MySQL is a viable deployment solution on Windows, my guess is you don't even have those entries in their systems' logging facilities since Windoze logging is not a priority in the OSes design. I don't use TCP/IP for connections in most of my MySQL-based applications and never from localhost to localhost, but I've been doing this stuff for quite a few years. Not everyone has the luxury of experience (the real kind; not XP), and best I can judge not many people actually do stuff in *n*x either, even at this point in time, nor on this list. So, what that gives you is many non-*n*x users using non-*n*x machines to connect to their MySQL servers to do stuff (sometimes ODBC stuff), and those servers mostly run some kind of *n*x (pro'ly Linux). This all falls into the realm of people running complex queries over TCP/IP. This is the kind of thing you'd probably encounter tons of bad connection type stuff if there were connectivity issues, like those you'd find on a DSL connection behind a Linux firewall running NAT, or masquerading, which is something most, (if not all) newbie Linuxers do... If your queries run on localhost via the local web-server and you've educated your users to run queries using UNIX sockets, the likelihood you'll ever get a bad connection from localhost to your server is about zero (0). If I get such an error, I'd want my inbox to fill up and I'll definitely notice. If someone who doesn't know the first thing about the bad connection problem starts getting messages about them, perhaps an education will commence. No one uses a monitoring system out there, except for you apparently, and thanks for doing it; and, clearly myself as I've admitted to it. Some people out there (and, they probably have good reasons for it) isolate their web machines from their MySQL machines, and this would mandate a TCP/IP connection, which is fine, but I'm sure that's a more rare configuration than most people are deploying. If you can code something like this (that can be turned off by default or by config, because I _want_ the behavior you want to remove) that is portable (i.e. works on Windows), then feel free. As should be clear from above, I am rather against it, even if it could be done easily. If at all, I would suggest to implement a trigger system, into which some other program can hook in, if it wants to know about special events. But then, the problem can be handled by existing means, so why bother? Windoze can have services disabled by default, but many times we encounter problems due to people running them without their knowledge or need. People have to take responsibility for their systems, even if it means a couple inconvenient e-Mails. Otherwise, the Gov't will take over what is currently our responsibility. I'm certain I'd be against that. Regards, Benjamin. I'm glad you monitor your systems and apparently take pride in those responsiblities. Please allow for the possiblity that you are the exception rather than the rule and
RE: SQL JOIN Challenge - Help Please
This is deceptively simple, and I very much appreciate your suggestion - but it doesn't work. Your suggestion still returns records that I should not see. Once again, there is a one to many relationship between an order_id in the order_id in the transaction response table. Please see my original email. Thank you Paul sql query -Original Message- From: Brian Moon [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 25, 2002 12:11 AM To: Paul Maine; MySQL MySQL Subject: Re: SQL JOIN Challenge - Help Please If I read right, this is a pretty basic join so I am assuming that you have never done a join in your life. select distinct order.order_id from order inner join transaction_log on order.order_id=transaction_log.order_id and transaction_log.event_log_id 3 Brian. - Original Message - From: Paul Maine [EMAIL PROTECTED] To: MySQL MySQL [EMAIL PROTECTED] Sent: Saturday, August 24, 2002 7:31 PM Subject: SQL JOIN Challenge - Help Please | I have an order table and a transaction log table. The order table has an | order_id and a number of other columns that are not germain to my question. | The transaction log has an order_ID and an event_log_id column. The order id | from the order table will have a one to many relationship to the order_id | data in the transaction log table. The event_log_id is an integer that | assumes a value of 1 if the credit card is authorized, a value of 2 if the | credit card is denied or some other type of error, and a value of 3 if the | credit card is delay captured. | | I need to create a query that would return all of the order.order_ids that | are authorized but have not been delayed captured. How can I accomplish this | task? | | Thank You | Paul | sql query | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | To request this thread, e-mail [EMAIL PROTECTED] | To unsubscribe, e-mail [EMAIL PROTECTED] | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | | - 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: Installation problem: mysql.sock missing (??)
Hi, MySQL install do not create socket.This socket it's created when MySQL daemon it's started. My suggestion : 1.check if you have already mysqld processes. 2. - Change the owner of directory which is created for mysql.sock from root to mysql ...or - Change in /etc/my.cnf(in [mysqld] section) the name of directory where you wish to mysqld create the socket.You must be sure that directory is *mysql* owner. 3.Start mysqld under init.d directory (/etc/rc.d/init.d...from what i remember.I don't have Slackware installed in this moment) Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Roger Young [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 25, 2002 1:44 PM Subject: Re: Installation problem: mysql.sock missing (??) Thanks for your reply. Do a locate mysql.sock it's there. For some reason on my machine the mysql install procedure does not create the socket. The locate utility (after updatedb) does not find mysql.sock and the socket directory /var/run/mysql is not established. I must be omitting some vital step but what is it? The mysql package is untarred in /usr/local The scripts/mysql_install_db is run. But the socket is missing... Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock Didn't have much luck with this either: Sorry, but search returned no results. I did go through the August messages but couldn't find anything relevant. What part of the install procedure sets up the socket? Would it be better to compile from the source rather than from the binary package? Thanks for any further help or comment. Roger Young Do a locate mysql.sock it's there. Do a search on the newsgroup at http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b On mysql.sock M;) On Sat, 2002-08-24 at 21:34, Roger Young wrote: I'm trying to install the binary mysql-3.23.52 under Linux (Slackware 8.2 distribution, kernel 2.4.18). I have followed the installation steps suggested in the INSTALL-BINARY file. However the daemon will not start, or rather it startd and immediately exits, and there is this message in the error log 020825 11:03:14 mysqld started 020825 11:03:14 Can't start server : Bind on unix socket: No such file or directory 020825 11:03:14 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 020825 11:03:14 Aborting In fact neither the socket nor the socket directory /var/run/mysql have been created. I created the directory but still got the same error. How do I properly install mysql? Thanks for your help, Roger Young - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL JOIN Challenge - Help Please
Paul, Based on your original post, I'd have to agree with Brian. That query should work. In fact, something as simple as this should work too: select order.order_id from order ,transaction_log where order.order_id = transaction_log.order_id and transaction_log.event_log_id 3 group by order.order_id Perhaps you could share your table designs and some sample records? Shashank Sql, query ORIGINAL REQUEST | | I have an order table and a transaction log table. The | order table has | | an order_id and a number of other columns that are not | germain to my | question. | | The transaction log has an order_ID and an event_log_id | column. The | | order | id | | from the order table will have a one to many | relationship to the | | order_id data in the transaction log table. The | event_log_id is an | | integer that assumes a value of 1 if the credit card is | authorized, a | | value of 2 if the credit card is denied or some other | type of error, | | and a value of 3 if the credit card is delay captured. | | | | I need to create a query that would return all of the | order.order_ids | | that are authorized but have not been delayed captured. | How can I | | accomplish | this | | task? | | - 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
full text search problems
Hi there, I am trying to write a php script to perform a full text search on a mysql db. I do a match against... and it digs out some results out of the db. There are 2 problems: 1. How can I restrict the results to e.g. 100 characters, but to make sure the keyword is within this 100 characters? 2. Is it possible with php to underline the keyword inside the search results. This might be more tricky. Thank you for any help on that, Andy query - Before posting, please check: http://www.mysql.com/manual.php (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
New to mySQL
Hi all (details of database at then end of this message) I hope someone can give me some advice. I am trying to create a database and access via PHP for a friend of mine that has a caravan park. What I want him to be able to do is to add bookings for the caravans via a PHP page and for clients to be able to search to see if a caravan is available for rent. I have created 2 tables and have put data into it via command prompt and also retrieved the data from it and carried out a join linking the 2 tables together. Which all seems to work well. The one thing I cannot get into my head is how can you tell the database that all the days between the start and end dates are booked. Also when people search for a caravan on a specific date and say they want it for 7 day the database/PHP checks to see if the entire period is totally free for them and does not colide with another booking. I am not sure whether I should be in list list of the PHP list so sorry if I have got it wrong. Any advice or places to visit would be greatly appreciated. Thanks for all your help Ray Details of what i have done already: mysql use matrix Database changed mysqlCREATE TABLE bookings ( - booking_id SMALLINT (6) NOT NULL AUTO_INCREMENT, - booking_start DATE NOT NULL DEFAULT '-00-00', - booking_end DATE NOT NULL DEFAULT '-00-00', - villa_id SMALLINT (6) NOT NULL DEFAULT '0', - PRIMARY KEY (booking_id) - ); mysqlINSERT INTO bookings VALUES (1, '2002-04-01', '2002-04-15', 3); mysqlINSERT INTO bookings VALUES (2, '2002-03-23', '2002-04-04', 1); mysqlCREATE TABLE villas ( - villa_id SMALLINT (6) NOT NULL AUTO_INCREMENT, - vill_name VARCHAR (25) NOT NULL DEFAULT '', - PRIMARY KEY (villa_id) - ); mysqlINSERT INTO villas VALUES (1, 'Gandy'); mysqlINSERT INTO villas VALUES (2, 'Hathaway'); mysqlINSERT INTO villas VALUES (3, 'Healy'); mysqlINSERT INTO villas VALUES (4, 'Mcleod'); mysql SELECT * FROM bookings; ++---+-+-+ | booking_id | booking_start | booking_end | villa_id | ++---+-+-+ | 1 | 2002-04-01 | 2002-04-15 |3 | | 2 | 2002-03-23 | 2002-04-04 |1 | ++---+-+-+ 2 rows in set (0.17 sec) mysql SELECT * FROM villas; +--++ | villa_id | villa_name | +--++ |1| Gandy| |2| Hathaway | |3| Healy | |4| Mcleod | +--++ 4 rows in set (0.00 sec) mysql SELECT villa_name, booking_start, booking_end FROM bookings LEFT JOIN villas ON bookings.villa_id = villas.villa_id; ++---++ | villa_name | booking_start | booking_end | ++---++ | Healy | 2002-04-01 | 2002-04-15 | | Gandy | 2002-03-23 | 2002-04-04 | ++---++ 2 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL JOIN Challenge - Help Please
Ok, I did not make the correlation between what rows you wanted and what the
data was. You are not getting this in one query. It would require a
sub-select. However, simple, but possibly slow queries will get it.
select * from transaction_log where event_log_id=3
get those back and
select order_id from transaction_log where order_id not in ({id list})
The list could be pretty big I guess.
Brian.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To: Brian Moon [EMAIL PROTECTED]; MySQL MySQL [EMAIL PROTECTED]
Sent: Sunday, August 25, 2002 7:02 AM
Subject: RE: SQL JOIN Challenge - Help Please
| This is deceptively simple, and I very much appreciate your suggestion -
but
| it doesn't work. Your suggestion still returns records that I should not
| see. Once again, there is a one to many relationship between an order_id
in
| the order_id in the transaction response table. Please see my original
| email.
|
| Thank you
| Paul
| sql query
| -Original Message-
| From: Brian Moon [mailto:[EMAIL PROTECTED]]
| Sent: Sunday, August 25, 2002 12:11 AM
| To: Paul Maine; MySQL MySQL
| Subject: Re: SQL JOIN Challenge - Help Please
|
|
| If I read right, this is a pretty basic join so I am assuming that you
have
| never done a join in your life.
|
| select
| distinct order.order_id
| from
| order
| inner join
| transaction_log on
| order.order_id=transaction_log.order_id and
| transaction_log.event_log_id 3
|
| Brian.
|
|
| - Original Message -
| From: Paul Maine [EMAIL PROTECTED]
| To: MySQL MySQL [EMAIL PROTECTED]
| Sent: Saturday, August 24, 2002 7:31 PM
| Subject: SQL JOIN Challenge - Help Please
|
|
| | I have an order table and a transaction log table. The order table has
an
| | order_id and a number of other columns that are not germain to my
| question.
| | The transaction log has an order_ID and an event_log_id column. The
order
| id
| | from the order table will have a one to many relationship to the
order_id
| | data in the transaction log table. The event_log_id is an integer that
| | assumes a value of 1 if the credit card is authorized, a value of 2 if
the
| | credit card is denied or some other type of error, and a value of 3 if
the
| | credit card is delay captured.
| |
| | I need to create a query that would return all of the order.order_ids
that
| | are authorized but have not been delayed captured. How can I accomplish
| this
| | task?
| |
| | Thank You
| | Paul
| | sql query
| |
| |
| | -
| | Before posting, please check:
| |http://www.mysql.com/manual.php (the manual)
| |http://lists.mysql.com/ (the list archive)
| |
| | To request this thread, e-mail [EMAIL PROTECTED]
| | To unsubscribe, e-mail
| [EMAIL PROTECTED]
| | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
| |
| |
|
|
| -
| 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
Difference between MySQL 4 and MySQL Max 4
Hi, Could anyone tell me what are the differences between MySQL 4 and MySQL Max 4, now that MySQL 4 has InnoDB built in as standard? I couldn't find the answer in the manual or the download section. I'd like to download MySQL and definitely want InnoDB, but I don't know whether i should go with MySQL 4 or MySQL Max 4. hence my question. Thanks a lot. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL JOIN Challenge - Help Please
Actually, you should be able to get the data in one query: in general,
any time you are doing a restriction on some value being in a set of
values (such as order_id not in some list built from a subselect) you
can rewrite the query using LEFT OUTER JOIN's. In this case, the
solution would be something like:
SELECT *
FROM orders o
INNER JOIN transaction_log t
ON o.order_id = t.order_id
AND t.event_log_id = 1
LEFT OUTER JOIN transaction_log t2
ON t.order_id = t2.order_id
AND t2.event_log_id = 3
WHERE t2.order_id IS NULL;
The way this works is to join across the transaction_log table twice:
first, to retrieve all rows that reference the given order and have an
event log id of 1, and second to retrieve all rows that reference the
given order id and have an event log id of 2. We then restrict to get
only those rows that do not have valid values in the second join's
results (namely, those transactions that have an event id of 1, from the
initial (inner) join, but do not have a corresponding event id of 3,
from the second (outer) join).
On Sun, 2002-08-25 at 09:43, Brian Moon wrote:
Ok, I did not make the correlation between what rows you wanted and what the
data was. You are not getting this in one query. It would require a
sub-select. However, simple, but possibly slow queries will get it.
select * from transaction_log where event_log_id=3
get those back and
select order_id from transaction_log where order_id not in ({id list})
The list could be pretty big I guess.
Brian.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To: Brian Moon [EMAIL PROTECTED]; MySQL MySQL [EMAIL PROTECTED]
Sent: Sunday, August 25, 2002 7:02 AM
Subject: RE: SQL JOIN Challenge - Help Please
| This is deceptively simple, and I very much appreciate your suggestion -
but
| it doesn't work. Your suggestion still returns records that I should not
| see. Once again, there is a one to many relationship between an order_id
in
| the order_id in the transaction response table. Please see my original
| email.
|
| Thank you
| Paul
| sql query
| -Original Message-
| From: Brian Moon [mailto:[EMAIL PROTECTED]]
| Sent: Sunday, August 25, 2002 12:11 AM
| To: Paul Maine; MySQL MySQL
| Subject: Re: SQL JOIN Challenge - Help Please
|
|
| If I read right, this is a pretty basic join so I am assuming that you
have
| never done a join in your life.
|
| select
| distinct order.order_id
| from
| order
| inner join
| transaction_log on
| order.order_id=transaction_log.order_id and
| transaction_log.event_log_id 3
|
| Brian.
|
|
| - Original Message -
| From: Paul Maine [EMAIL PROTECTED]
| To: MySQL MySQL [EMAIL PROTECTED]
| Sent: Saturday, August 24, 2002 7:31 PM
| Subject: SQL JOIN Challenge - Help Please
|
|
| | I have an order table and a transaction log table. The order table has
an
| | order_id and a number of other columns that are not germain to my
| question.
| | The transaction log has an order_ID and an event_log_id column. The
order
| id
| | from the order table will have a one to many relationship to the
order_id
| | data in the transaction log table. The event_log_id is an integer that
| | assumes a value of 1 if the credit card is authorized, a value of 2 if
the
| | credit card is denied or some other type of error, and a value of 3 if
the
| | credit card is delay captured.
| |
| | I need to create a query that would return all of the order.order_ids
that
| | are authorized but have not been delayed captured. How can I accomplish
| this
| | task?
| |
| | Thank You
| | Paul
| | sql query
| |
| |
| | -
| | Before posting, please check:
| |http://www.mysql.com/manual.php (the manual)
| |http://lists.mysql.com/ (the list archive)
| |
| | To request this thread, e-mail [EMAIL PROTECTED]
| | To unsubscribe, e-mail
| [EMAIL PROTECTED]
| | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
| |
| |
|
|
| -
| 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: Difference between MySQL 4 and MySQL Max 4
On Sun, Aug 25, 2002 at 01:11:16PM -0400, Andy Leung wrote: Hi, Could anyone tell me what are the differences between MySQL 4 and MySQL Max 4, now that MySQL 4 has InnoDB built in as standard? I couldn't find the answer in the manual or the download section. I'd like to download MySQL and definitely want InnoDB, but I don't know whether i should go with MySQL 4 or MySQL Max 4. hence my question. 4.0-max contains BDB tables, MyISAM RAID support, and a few other odditites. You probably don't need it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 19 days, processed 391,026,547 queries (232/sec. avg) - 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
SQL Syntax
This may be a truly dumb question, but could someone please tell me why this sql query/ statement does not work: update CompanyContacts set ByEmailAddress = '[EMAIL PROTECTED]' where Description like '%marve%' If I say: select * from CompanyContacts where Description like '%marve%' I get the correct response. Thanks in anticipation. -David - 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: Installation problem: mysql.sock missing (??)
MySQL install do not create socket.This socket it's created when MySQL daemon it's started. My suggestion : 1.check if you have already mysqld processes. 2. - Change the owner of directory which is created for mysql.sock from root to mysql ...or - Change in /etc/my.cnf(in [mysqld] section) the name of directory where you wish to mysqld create the socket.You must be sure that directory is *mysql* owner. 3.Start mysqld under init.d directory (/etc/rc.d/init.d...from what i remember.I don't have Slackware installed in this moment) Thanks, I understand now. Almost certainly this will solve my problem. I think some additional explanation could be included in the INSTALL_BINARY help file for the benefit of mysql newbies like myself...:-) Roger Young - 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
Allowing a whole class C to access mysql server?
Hi, I am trying to have a whole class C access the mysql server on the network. The class C needs to access many different database names. So adding an entry for each Ip address wouldn't work. Does anyone know how I can go about this? Thanks, Adam - 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_com.h header name space pollution
Hi, some time ago I submitted the bug report below (see http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116815:200208:nnjofboiddhkghnpfljl for the full report). There was no feedback and I now have a better understanding of the problem: The bug means that you cannot compile a KDE3 program with embedded MySQL support. KDE cannot do anything about this, as its API is frozen. The MySQL API shouldn't be frozen (as 4.0 is still alpha), and on the other hand, the error is trivial to fix for MySQL (just rename NET). So please, apply a fix so that KDE programs can use embedded MySQL. Regards Daniel Description: NET is defined on line 135 in myslq_com.h. When I include mysql.h (for embedded mysql) I cannot compile a program which also includes netwm_def.h, which defines a completely different NET. Fix: Please rename NET to something like MySQL_NET -- http://www.danielnaber.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL JOIN Challenge - Help Please
Thank you very much! This was the precise solution I was looking for.
Brian - I'm sure your method would also work. Thank you both sooo much.
-Original Message-
From: Chris Tucker [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 25, 2002 2:18 PM
To: Brian Moon
Cc: Paul Maine; MySQL MySQL
Subject: Re: SQL JOIN Challenge - Help Please
Actually, you should be able to get the data in one query: in general,
any time you are doing a restriction on some value being in a set of
values (such as order_id not in some list built from a subselect) you
can rewrite the query using LEFT OUTER JOIN's. In this case, the
solution would be something like:
SELECT *
FROM orders o
INNER JOIN transaction_log t
ON o.order_id = t.order_id
AND t.event_log_id = 1
LEFT OUTER JOIN transaction_log t2
ON t.order_id = t2.order_id
AND t2.event_log_id = 3
WHERE t2.order_id IS NULL;
The way this works is to join across the transaction_log table twice:
first, to retrieve all rows that reference the given order and have an
event log id of 1, and second to retrieve all rows that reference the
given order id and have an event log id of 2. We then restrict to get
only those rows that do not have valid values in the second join's
results (namely, those transactions that have an event id of 1, from the
initial (inner) join, but do not have a corresponding event id of 3,
from the second (outer) join).
On Sun, 2002-08-25 at 09:43, Brian Moon wrote:
Ok, I did not make the correlation between what rows you wanted and what
the
data was. You are not getting this in one query. It would require a
sub-select. However, simple, but possibly slow queries will get it.
select * from transaction_log where event_log_id=3
get those back and
select order_id from transaction_log where order_id not in ({id list})
The list could be pretty big I guess.
Brian.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To: Brian Moon [EMAIL PROTECTED]; MySQL MySQL [EMAIL PROTECTED]
Sent: Sunday, August 25, 2002 7:02 AM
Subject: RE: SQL JOIN Challenge - Help Please
| This is deceptively simple, and I very much appreciate your suggestion -
but
| it doesn't work. Your suggestion still returns records that I should
not
| see. Once again, there is a one to many relationship between an order_id
in
| the order_id in the transaction response table. Please see my original
| email.
|
| Thank you
| Paul
| sql query
| -Original Message-
| From: Brian Moon [mailto:[EMAIL PROTECTED]]
| Sent: Sunday, August 25, 2002 12:11 AM
| To: Paul Maine; MySQL MySQL
| Subject: Re: SQL JOIN Challenge - Help Please
|
|
| If I read right, this is a pretty basic join so I am assuming that you
have
| never done a join in your life.
|
| select
| distinct order.order_id
| from
| order
| inner join
| transaction_log on
| order.order_id=transaction_log.order_id and
| transaction_log.event_log_id 3
|
| Brian.
|
|
| - Original Message -
| From: Paul Maine [EMAIL PROTECTED]
| To: MySQL MySQL [EMAIL PROTECTED]
| Sent: Saturday, August 24, 2002 7:31 PM
| Subject: SQL JOIN Challenge - Help Please
|
|
| | I have an order table and a transaction log table. The order table has
an
| | order_id and a number of other columns that are not germain to my
| question.
| | The transaction log has an order_ID and an event_log_id column. The
order
| id
| | from the order table will have a one to many relationship to the
order_id
| | data in the transaction log table. The event_log_id is an integer that
| | assumes a value of 1 if the credit card is authorized, a value of 2 if
the
| | credit card is denied or some other type of error, and a value of 3 if
the
| | credit card is delay captured.
| |
| | I need to create a query that would return all of the order.order_ids
that
| | are authorized but have not been delayed captured. How can I
accomplish
| this
| | task?
| |
| | Thank You
| | Paul
| | sql query
| |
| |
| | -
| | Before posting, please check:
| |http://www.mysql.com/manual.php (the manual)
| |http://lists.mysql.com/ (the list archive)
| |
| | To request this thread, e-mail [EMAIL PROTECTED]
| | To unsubscribe, e-mail
| [EMAIL PROTECTED]
| | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
| |
| |
|
|
| -
| 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,
Re: Allowing a whole class C to access mysql server?
GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0' should do the trick: you just specify the IP you want to allow and the netmask to apply to it after the /. You could also use: GRANT SELECT ON db.* TO user@'192.168.1.%' as documented in the manual (http://www.mysql.com/doc/en/GRANT.html). Documentation on the netmask method can be found at http://www.mysql.com/doc/en/Connection_access.html -Chris On Sun, 2002-08-25 at 14:25, Adam Ryan wrote: Hi, I am trying to have a whole class C access the mysql server on the network. The class C needs to access many different database names. So adding an entry for each Ip address wouldn't work. Does anyone know how I can go about this? Thanks, Adam - 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
Won't compile on Mac OS X 10.2
Dear Sir, MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0 which comes pre-installed with gcc 3.1 I don't want to uninstall it as it would probably bring down other major functions of the new system. Regards, Mitch Leung -- __ __ __ __ _ _ Mitch Leung ( \/ )( )(_ _)( _)| |_| | mailto:[EMAIL PROTECTED] )( )( )( ((_ | _ | http://www.mitchleung.com/ (_/\/\_)(__) (__) (__)|_| |_| +852 9361-6984 - 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
Learning Data Types
Hi, I am learning about MySQL and how to use the CREATE TABLE command, and I was wondering where I could learn more about MySQL datatypes (cause they seem to be a big part of this command). Will _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Continuing LOAD LOCAL INFILE issues..
Ok, Have had continuing issues with trying to actually get LOAD LOCAL INFILE commands working. Even after a MySQL recompile it doesn't appear to be working. Basically, no matter what I specify with LOCAL LOCAL INFILE mysql refuses to let my user (setup via Plesk) do a thing. Anyone have any suggestions? I get the feeling this is more of a MySQL Dev team screw up more than anything (at least judging by the comments posted on the LOAD LOCAL INFILE section of the doc pages). Cheers, Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog - 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: Won't compile on Mac OS X 10.2
I got MySQL 4.0.2-alpha compiled on Mac OS X 10.2 (final version - Jaguar6C115). I am having problems with getting any client to connect to it, so perhaps I am doing something else wrong, which is possible since I am new to MySQL First I tried: ./configure --with-named-curses-libs=/usr/lib/libncurses.dylib This did not work. Then I manually executed the one compile that was failing, adding the libncurses.dylib to the list of libraries to use, as such: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -traditional-cpp -DHAVE_DARWIN_THREADS -D_P1003_1B_ VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -o mysql mysql.o readline.o sql_string.o completion_hash.o ../ readline/libreadline.a ../libmysql/.libs/libmysqlclient.a /usr/lib/libncurses.dylib -lz -lm -lz -lm Then I did a make again and everything went along to the end. For some reason my client sub-directory did not get re-named to bin and, as I said, I cannot connect. Keep getting: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ... so I may have messed something up. Maybe someone else, with more experience with installing, can pick the ball up and move it along... thanx - ray On Sunday, August 25, 2002, at 05:39 PM, Mitch Leung wrote: Dear Sir, MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0 which comes pre-installed with gcc 3.1 I don't want to uninstall it as it would probably bring down other major functions of the new system. Regards, Mitch Leung - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Syntax
David [ mysql,query ] update CompanyContacts set ByEmailAddress = '[EMAIL PROTECTED]' where Description like '%marve%' Can you show us the output of: describe CompanyContacts ...and also what is the exact error message? Are you connected as a user who is allowed to update the CompanyContacts table? I often have select only users and forget that I can't update/delete etc on the database tables :-) DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - 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
More info: Strange memory leak problem (C API)
I've compiled debugging into the library .. now I figured the library was getting loaded/unloaded, but it didn't really come to mind until I ran it with debugging. My atomic tests (A standalone program that init's and closes) does NOT do this.. So, I'm wondering if the leak is somehow being incurred by constantly mmaping and un-mmaping the library even though the master process (the one calling getpwnam over and over) never exits - libmysqlclient is being dynamically loaded and unloaded over and over again. --- MYSQL_DEBUG found. libmysql started with the following: d:t:L:n:N:S:F --- 1: libmysql.c: 1664:1: mysql_close 2: libmysql.c: 1700:1: mysql_close --- MYSQL_DEBUG found. libmysql started with the following: d:t:L:n:N:S:F --- 1: libmysql.c: 1664:1: mysql_close 2: libmysql.c: 1700:1: mysql_close --- MYSQL_DEBUG found. libmysql started with the following: d:t:L:n:N:S:F --- 1: libmysql.c: 1664:1: mysql_close 2: libmysql.c: 1700:1: mysql_close etc ... Thoughts? - 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: 30th December 1899
Can anyone help me please. Need more information, I think. I am a UK lawyer and I have a client accused of concealing theft of cash by sending invoices to this date (so the accounts software wouldn't report the sale and discrepancy between stock and receipts would not be noticed). Technical details -- using what system? Where and under what conditions do the dates appear, and what software/systems would have processed them? There are strong reasons for thinking he would not be able to do this. Such as? Can someone explain what can cause this date to appear without a user inputting it I, myself, don't recognize it as the result of a common error. If the battery for the calendar/clock in the systems I am familiar with suddenly failed, the dates you would get would be in the 1970s, 1904, maybe 1900. That does not mean that some custom function someone wrote would not use that particular date as a default date for some reason. One thought, deliberately setting the system clock back leaves a lot of footprints, and it would usually take an administrator's account, a fair amount of knowledge of the system, and and a few minutes with a search tool to erase them all. But there are lots of other ways to get bad dates into records. -- Joel Rees [EMAIL PROTECTED] sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help to Join 5 tables
Hi guys I would like to have a SQL query to couple five tables to accomplish my need. This is a search page and the user will be searching using the don_id Presently I am using a simple equi join which works fine if all the five tables contain data for user_id But if any of the tables have no value for that particular don_id, it is obvious that nothing is being displayed. I think that a left join will be better but can't get one to display results from all the five tables And the don_id is not unique in the claim table. So claim table can have same don_id any number of times, I would like to display all the claim details for that particular don_id with values from other tables also. Here are the tables 1.CREATE TABLE don(don_id char(20) primary key , buy_date date not null) ; 2.CREATE TABLE enduser( user_id char(20) primary key, user_name varchar(50) not null, user_addr_str varchar(150), don_id char(20) unique not null, pro_pd char(20) unique not null, maker varchar(150), cpu varchar(150)) ; 3.CREATE TABLE usersale(user_sale_id varchar(20) primary key, user_id varchar(20) not null, don_id varchar(20) unique not null, pro_pd varchar(16) unique not null) ; 4.CREATE TABLE ssale(shit_sale_id varchar(20) primary key, s_id varchar(20) not null, don_id varchar(20) unique not null , pro_pd varchar(16) unique not null); 5.CREATE TABLE claim(claim_id int auto_increment primary key, user_id varchar(20) not null, don_id varchar(20) not null, pro_pd varchar(20) not null, claim_date date not null, claim_det text not null) ; Note: Also I may include more tables in the future.I am writing the sql query during the runtime by getting field values from the user input through check boxes and so I would prefer to have a single query to do this. Hope that some of you can help me and thanks in advance Kayamboo suresh - 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: Won't compile on Mac OS X 10.2
For some reason my client sub-directory did not get re-named to bin and, as I said, I cannot connect. Keep getting: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) The one time I got MySQL running under Mac OS X (10.1), I had to mkdir the socket directory and chown/chmod by hand. I think I also built the bin structure by hand, as well, don't remember why. You might try that, just to see. -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Digest Mode
Hello, Just joined this SQL mailing list a few days ago, and I want to change my membership to digest mode. Anybody could help me ? Thanks Benny - 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: More info: Strange memory leak problem (C API)
If I link the library with '-z nodelete' the leak goes away. The library doesn't get loaded and unloaded over and over again... From the Solaris 'ld' man page -z nodelete Marks the object as non-deletable at runtime. The run- time processing of an object that contains this flag mimics that which occurs if the object is added to a process using dlopen(3DL) with the RTLD_NODELETE mode. and from dlopen: RTLD_NODELETE The specified object will not be deleted from the address space as part of a dlclose(). While this cures my problem, it seems it's an inappropriate bandaid.. I don't see wide use of this option upon a cursory 'net search ... And I don't know if this is a mysql problem or a solaris problem ... would dlopen()ing a library that's compiled with -lmysqlclient, allocating memory using a routine (mysql_init) from that included library, and then unloading the library cause a memory leak if the included (mysqlclient) library doesn't free certain other memory that's only initialized once mysql_init is called? IE does mysql_init do a one-time memory alloc that's never freed (but under normal circumstances doesn't cause a leak because the alloc'ed area is normally assumed to be around for the duration of the program)? So subsequent loads of the librarys cause this one-time memory alloc to be called over and over? This might need to go to some core MySQL folks unless someone here's familiar with the client library internals ... :-) Thanks! -=| Ben - 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: Won't compile on Mac OS X 10.2
On 8/25/02 11:36 PM, Joel Rees [EMAIL PROTECTED] wrote: For some reason my client sub-directory did not get re-named to bin and, as I said, I cannot connect. Keep getting: % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) You might want to take a look at: http://www.entropy.ch/software/macosx/mysql/ Some very helpful information there. BTW, I have MySQL running on 10.2 as we speak. -Calvin - 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
