Re: Confusing SELECT statement
you can use select addresses.id from addresses LEFT JOIN mlist ON addresses.id=mlist.addr_id AND mlist.mlist_id=$mlist_id WHERE mlist.mlist_id IS NULL On Thu 27. September 2001 08:09, Adam Gintis wrote: I have the following table mlist: +--+-+ | mlist_id | addr_id | +--+-+ |1 | 1 | |2 | 2 | |2 | 3 | |1 | 3 | +--+-+ This is the join table of my address book and my mailing lists. So person 1 is in list 1, person 2 is in list 2, and person 3 is in both lists. What I want to do is get a list of everyone that is NOT in a certain list. In other words, if I'm editing list 1, I need a list of all the people in the address book that aren't in list 1 (person 2). If I'm editing list 2, I want person 1. I never want to see person 3, because he is already in both lists. I'm currently trying to do this with a statement like SELECT * FROM mlist GROUP BY addr_id HAVING mlist_id != 'list I'm currently editing'. The problem is that group by addr_id keeps the first row's value for mlist_id. So when I'm editing list 2, it works. But when I'm editing list 1, person 3 still shows up. If the last two rows were the other way around in the table, it would work for list 1 and not for list 2. So the question is, is there a command I can use to look through the aggregate set of mlist_id's, or is there another way to write this query? Thanks! --- Adam Gintis Vanderbilt University - Before posting, please check: http://www.mysql.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
binding to more than one ip address.
Greetings, I have been trying to get mysqld to run under 2 ip addresses (localhost and an external ip address). Using the bind-address option twice doesnt seem to work, nor does lisiting 2 ip addresses in the option. I hope mysqld has this functionality to be able to run under certain ip addresses without binding to EVERY ip address, and not just ONE ip address. I hope someone can help. DJ - Before posting, please check: http://www.mysql.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
array
Hi, How could I retrieve data from MySQL and put it to data array? here is example Table Sale Field1 -- Date Field2 -- Sale Amount --- DateSale Amount 1/1/20011000 1/2/20012000 1/3/20013000 $data_array=array ( array('1/1/2001',1000), array('1/2/2001',2000), array('1/3/2001',3000) ) Which command I need to use in PHP? SF - Before posting, please check: http://www.mysql.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
SV: Newsgroup ???
I am not sure, but it seems like the newsgroup mailing.database.myodbc is the same as this mailinglist? (Sorry if I create confusion, I am not quite sure I understand what you ask for.) Ann - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Christopher Raymond [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 7:31 AM Subject: Re: Newsgroup ??? On Tue, Sep 25, 2001 at 03:02:30PM -0500, Christopher Raymond wrote: MySQL Gurus: Is there a newsgroup server for this discussion list? I don't think so. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 21 days, processed 395,493,570 queries (217/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 - Before posting, please check: http://www.mysql.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
myisamchk: error: 22
Hi ! I got a power failure on my database machine and now I cant start it since I got a error 22 when I start it. How do I fix this? And what does error 22 mean? I looked at http://www.mysql.com/doc/R/e/Repair.html but nothing there seems to fix it. //eric - Before posting, please check: http://www.mysql.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: binding to more than one ip address.
I have been trying to get mysqld to run under 2 ip addresses (localhost and an external ip address). Using the bind-address option twice doesnt seem to work, nor does lisiting 2 ip addresses in the option. I hope mysqld has this functionality to be able to run under certain ip addresses without binding to EVERY ip address, and not just ONE ip address. Make sure you don't have skip-locking and run 2 mysqlds, 1 for each IP. - Before posting, please check: http://www.mysql.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
what due to the 127 table handle error?
My pc is linux os, install mysql , one table have a field longtext, and when it become 26M, when insert recode, it report get 127 error table handle. I do not know what can let mysql occured this error, and how to protect it. when it occur error, I have to stop the mysql, repaire it manually. - Before posting, please check: http://www.mysql.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: array
Hi, How could I retrieve data from MySQL and put it to data array? here is example Table Sale Field1 -- Date Field2 -- Sale Amount --- Date Sale Amount 1/1/2001 1000 1/2/2001 2000 1/3/2001 3000 $data_array=array ( array('1/1/2001',1000), array('1/2/2001',2000), array('1/3/2001',3000) ) Which command I need to use in PHP? SF have a look here: http://www.php.net/manual/en/ref.mysql.php mysql_fetch_row() mysql_fetch_assoc() mysql_fetch_array() jason - Before posting, please check: http://www.mysql.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
error 144
Hi! allways when i want to open an special table i get error 144 and in phpmyadmin it's said that the table is in use anybody there who can help me thanx Alexander Jäger - Before posting, please check: http://www.mysql.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: join mysql mail list
¤Þ¨¥ [EMAIL PROTECTED]: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: my email address : [EMAIL PROTECTED] ¥i¥HµoAV«HªºGiGiGaGa AV«H½c¡A°¨¤W¾Ö¦³½Ð¨ì http://mail.gigigaga.com ¥i¥HµoAV«HªºGiGiGaGa AV«H½c¡A°¨¤W¾Ö¦³½Ð¨ì http://mail.gigigaga.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
undefined symbol: mysql_num_fields
Hello Friends, I am using a different technology named zolar. It has its parser file, which should be kept in the cgi-bin directory in linux. so, whenever we call any file written using this technoloy we will call as: http://hostname/cgi-bin/zolar/file-name I am using mysql 3.22.32 with it. To specify the database there is one configuration file in which we have to give the information of the host on which the database is, username, password and database name. Now when I am writing INSERT, UPDATE or DELETE query in the file written using this technology(zolar) i get the correct result. But when I am writing SELECT query and execute the file I get no result and get the following error message in Apache's error_log file: error in loading shared libraries: undefined symbol: mysql_num_fields I dont know why this error is coming. My libmysqlclient.so.* are in /usr/lib and mysql.sock is in /var/lib/mysql. Can anybody guide me in this? It is very urgent. Please reply as soon as possible. If u have any query please ask me. Thanks. gaurang. Do You Yahoo!? Send a newsletter, share photos files, conduct polls, organize chat events. Visit http://in.groups.yahoo.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: binding to more than one ip address.
I only want to run 1 copy of mysql.. just bind 2 two different ip addresses.. one localhost.. and one of my external addresses.. i want to only have one copy running thou. DJ - Original Message - From: Chris Bolt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 6:09 PM Subject: RE: binding to more than one ip address. I have been trying to get mysqld to run under 2 ip addresses (localhost and an external ip address). Using the bind-address option twice doesnt seem to work, nor does lisiting 2 ip addresses in the option. I hope mysqld has this functionality to be able to run under certain ip addresses without binding to EVERY ip address, and not just ONE ip address. Make sure you don't have skip-locking and run 2 mysqlds, 1 for each IP. - Before posting, please check: http://www.mysql.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
replication implementation.
Hi anybody, am a newbie to mysql and i want to install master/slave mysql server for replication. can anybody please desc from the scratch (user rights) of configuring 2 mysql servers in master/slave fashion for replicatiom. thanx in advance. bye kamesh __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.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: replication implementation.
can anybody please desc from the scratch (user rights) of configuring 2 mysql servers in master/slave fashion for replicatiom. http://www.mysql.com/doc/R/e/Replication.html Not that difficult to find... -- Luis Calero Muñoz $email{luis} = '[EMAIL PROTECTED]' $who{luis} = 'sysadm at ociojoven dot 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: replication implementation.
I just installed my first Master/Slave setup Tuesday ... followed the instructions in the Manual (http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Ad ministration.html#Replication). It was a snap! Gerald Jensen - Original Message - From: Kamesh P S [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 6:30 AM Subject: replication implementation. Hi anybody, am a newbie to mysql and i want to install master/slave mysql server for replication. can anybody please desc from the scratch (user rights) of configuring 2 mysql servers in master/slave fashion for replicatiom. thanx in advance. bye kamesh __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.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: replication implementation.
I just installed my first Master/Slave setup Tuesday ... followed the instructions in the Manual (http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Ad ministration.html#Replication). It was a snap! Gerald Jensen How's it going for you - is it in production use yet, and under reasonable load? I'm having problems with my master(s) not logging all queries to the binary log, and as a result, the slaves don't get the changes, since they read the binary log to know what to do. I've posted here about it a couple of times and not had a single reply, not even a 'please submit a bug report because no, that's not a known issue' or a 'no, mine's working perfectly in production, you're doing something wrong' jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql can't connect to local mysql server
My linux is Hed Hat and I have a problem with my database: when I tried to connect with mysql, this message appear: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111). Please, someone help me. Thanks. Cristiana. ___ Yahoo! GeoCities Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis! http://br.geocities.yahoo.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: Mysql can't connect to local mysql server
My linux is Hed Hat and I have a problem with my database: when I tried to connect with mysql, this message appear: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111). Please, someone help me. Thanks. Cristiana. This could be because mysql is not running, or the client is (? or libraries client uses are) looking in the wrong place for the socket file. There's a few ways you can fix this, which one is up to you. Here's some info on it. http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.html#Prob lems_with_mysql.sock jason - Before posting, please check: http://www.mysql.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
what is MySQL' memory footprint
Hi! Rock == Rock VZ [EMAIL PROTECTED] writes: Rock Hi, Rock How much memory does mysql executable take in the ram? Rock What is its code memory foot print? It depends on how you compile MySQL and how you set up the buffers. MySQL can run with as little memory as 64K + code size The code size is 700K - 2M, depending on which options you include into the MySQL server. It's possible to make the server take even less memory with reasonable little work by removing not used features. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Possible bug?
Heikki, Here's the details from the .err log: New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 010926 14:37:09 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 11 535599548 010926 14:37:09 InnoDB: Started /usr/sbin/mysqld-max: ready for connections InnoDB: Assertion failure in thread 5126 in file ibuf0ibuf.c line 2339 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail I'm assuming that this happens to be occurring b/c of a Innodb file corruption, b/c when I comment the innodb config out of the my.cnf the mysqld starts up ok(albeit w/o all my data). Thanks, Chris On Thu, 27 Sep 2001, Heikki Tuuri wrote: Chris, what is the exact error message? How do you know that it comes from ibuf0ibuf.c, line 2339? Have you compiled yourself? Regards, Heikki Innobase Oy Getting an error message in the log saying...fp=(nil), etc, etc, possible bug from ibuf0ibuf.c, line 2339 What're the possible reasons I could be getting this bug?Oh, forgot... MySQL-max 3.23.42innodbRed Hat 6.2(2.2.14-6.1.1.smp) Intel 866Mhz, 512MB Ram, 20+ GB SCSI HDD Thanks, Chris - Before posting, please check: http://www.mysql.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
InnoDB datafile usage!
Hi, Is there any way to check whether I should add new datafile before my database runs out of free space in the existing ones? - Before posting, please check: http://www.mysql.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
Strings between HTML, PHP and MySQL
I'm sending variables in an HTML request such as http://localhost/connexion.php?ID1=value1ID2=value2 When the variable ID2 is numeric, everything is OK and the query made by PHP (such as SELECT my_table WHERE ident1 = $id1, ident2=$id2;) works very well. The column ident2 in mySQL is defined as a VARCHAR(30). When I give in HTML an alphanumerical value to ID2, (ie ABC) I get an error from MySQL. It seems that PHP only accepts to receive numeric variables, and that he creates various errors (in MySQL) as soon as a variable is not numeric : my PHP scripts work fine as long as the value are numeric and seem not to accept alphanumeric values Do I have to indicate to PHP that a variable is alphanumeric (and not numeric) ? Thanks for your 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: Strings between HTML, PHP and MySQL
Try SELECT my_table WHERE ident1 = $id1, ident2='$id2'; Note the single quotes around $id2 Clive Mon PC wrote: I'm sending variables in an HTML request such as http://localhost/connexion.php?ID1=value1ID2=value2 When the variable ID2 is numeric, everything is OK and the query made by PHP (such as SELECT my_table WHERE ident1 = $id1, ident2=$id2;) works very well. The column ident2 in mySQL is defined as a VARCHAR(30). When I give in HTML an alphanumerical value to ID2, (ie ABC) I get an error from MySQL. It seems that PHP only accepts to receive numeric variables, and that he creates various errors (in MySQL) as soon as a variable is not numeric : my PHP scripts work fine as long as the value are numeric and seem not to accept alphanumeric values Do I have to indicate to PHP that a variable is alphanumeric (and not numeric) ? Thanks for your 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 - Before posting, please check: http://www.mysql.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
scheduling, priorities etc
Hi all: I have read somewhere that mysql allows inserts into a table without holes to go concurrently with the reads from that table. starting at v 3.23.7. I'm running 3.23.41-nt and have tried to accomplish that, but couldn't. My reads seem to only start after the inserts are completed. Is there a special parameter I need to set up to enable this feature? I'm also having the same problem with low_priority/high_priority features. I have done some testing and couldn't force an update to run after the select no matter what. Any ideas what I may be doing wrong? thanks __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.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