collation problem
SQL Hi, all! I have a problem after migration from 4.0.20 to 4.1.2 I have a table `analit`. this is the result of show create table: CREATE TABLE `analit` ( `d` date NOT NULL default '-00-00', `service` binary(16) NOT NULL default '', `price` char(50) NOT NULL default '', `type` char(50) NOT NULL default '', `val` double NOT NULL default '0', `city` char(16) NOT NULL default '', `VIP` int(11) NOT NULL default '0', `currency` char(8) NOT NULL default 'unit', `label` int(11) NOT NULL default '0', `status` int(11) NOT NULL default '0', PRIMARY KEY (`d`,`service`,`price`,`type`,`city`,`VIP`), KEY `city` (`city`), KEY `d` (`d`), KEY `label` (`label`) ) ENGINE=MyISAM DEFAULT CHARSET=koi8r The request return me a error: mysql select * from analit where price rlike '_R'; ERROR 1267 (HY000): Illegal mix of collations (koi8r_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp' I can't find this in docs. I try to set LC_COLLATE in environtment variables like setenv LC_COLLATE ru_RU.KOI8-R But there isn't any result. What should I do? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question
At 22:54 -0700 6/4/04, jerome greene wrote: Where do you run the verify programs from? Are they ran from the command prompt? Do I copy the keys? Thanks What is the context of these questions? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Get fields in one field, separated by comma's
Hi, I have a question about MySQL queries. First I will explain the situation, then I will provide an example. Situation: I have the tables 'offer', 'contact' and 'offer_contact'. Table 'offer' contains data about offers, table 'contact' about contacts. Table 'offer_contact' tells which contacts are associated with which offers (since offers can have multiple contacts associated with it and vice versa). Now I want to run a query so I get a row for each offer and in the result there's a field 'offer_contacts' which contains all the names of the contacts associated with the offer on that row separated by comma's. Example: Table 'offer' (offer_id - offer_title): 1 - Test 2 - Also test Table 'contact' (contact_id - contact_name): 1 - John 2 - Anna Table 'offer_contact' (offer_id - contact_id): 1 - 1 1 - 2 2 - 1 Wanted result of query (offer_id - offer_name - offer_contacts): 1 - Test - John, Anna 2 - Also test - John Is this possible? Your help would be great! -- Klaas Geldof -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
User ID Password
Hello: I am posting this message on freeRADIUS, vpopmail mysql lists. This may get few people upset but please read I am trying to install (on RH9), qmail, vpopmail, mysql, Courier-IMAP, squirrelmail, etc., with backend data on MySQL. On another computer I have installed RH9 freeRADIUS server. vpopmail is used to add UID PW and the data is stored in vpopmail DB in MySQL. Now freeRADIUS also uses UID PW to authenticate and has its own data structure. I like to know if there is a way so that user data is stored in one table in MySQL so vpopmail and freeRADIUS can access the same information?? Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Increase in size of 4.1.2 binary
Hello, The windows binary of 4.1.1 was around 20 MB. With 4.1.2 it has increased to 34 MB. Thats a big jump ? Karam __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Err 2002 socks suck noway to start
Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : [EMAIL PROTECTED] [~]# service mysql start [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# ls -ls /tmp total 48 8 drwxrwxrwt3 root root 8192 Jun 5 11:55 ./ 4 drwxr-xr-x 20 root root 4096 Jun 5 11:01 ../ 4 drwxrwxrwx2 bin bin 4096 Jun 5 11:02 .iroha_unix/ 0 srwxrwxrwx1 mysqlmysql 0 Jun 5 11:55 mysql.sock= ... [EMAIL PROTECTED] [/tmp]# rpm -qa | grep MySQL MySQL-server-4.0.18-0 perl-DBD-MySQL-2.1021-3 MySQL-client-4.0.18-0 MySQL-embedded-4.0.18-0 MySQL-devel-4.0.18-0 MySQL-shared-4.0.18-0 Thanks. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
At 19:21 +0200 6/5/04, pourave wrote: Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : mysql is a client program. The server is named mysqld. [EMAIL PROTECTED] [~]# service mysql start [EMAIL PROTECTED] [~]# mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) [EMAIL PROTECTED] [~]# ls -ls /tmp total 48 8 drwxrwxrwt3 root root 8192 Jun 5 11:55 ./ 4 drwxr-xr-x 20 root root 4096 Jun 5 11:01 ../ 4 drwxrwxrwx2 bin bin 4096 Jun 5 11:02 .iroha_unix/ 0 srwxrwxrwx1 mysqlmysql 0 Jun 5 11:55 mysql.sock= ... [EMAIL PROTECTED] [/tmp]# rpm -qa | grep MySQL MySQL-server-4.0.18-0 perl-DBD-MySQL-2.1021-3 MySQL-client-4.0.18-0 MySQL-embedded-4.0.18-0 MySQL-devel-4.0.18-0 MySQL-shared-4.0.18-0 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User ID Password
I think that I'd look at postfix and dbmail. Postfix and dbmail both allow userdata to be stored in MySQL databases. dbmail will also put the message store in a mysql database. Very nice, very fast. RH9 has hit eol. Gentoo rocks. Curtis -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com On Sat, 5 Jun 2004, Kirti S. Bajwa wrote: Hello: I am posting this message on freeRADIUS, vpopmail mysql lists. This may get few people upset but please read I am trying to install (on RH9), qmail, vpopmail, mysql, Courier-IMAP, squirrelmail, etc., with backend data on MySQL. On another computer I have installed RH9 freeRADIUS server. vpopmail is used to add UID PW and the data is stored in vpopmail DB in MySQL. Now freeRADIUS also uses UID PW to authenticate and has its own data structure. I like to know if there is a way so that user data is stored in one table in MySQL so vpopmail and freeRADIUS can access the same information?? Thanks in advance. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
At 19:21 +0200 6/5/04, pourave wrote: Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : mysql is a client program. The server is named mysqld. I know under redhat a script call service is used to start mysql service : #service mysql start same as # /etc/rc.d/init.d/mysql start Nothing : [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6212 0.0 0.1 3776 568 pts/0S12:59 0:00 grep mysql Mysql used to start automaticaly [EMAIL PROTECTED] [/var/log]# /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid /dev/null 21 [1] 6301 [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6335 0.0 0.1 3776 568 pts/0S13:02 0:00 grep mysql [1]+ Done /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid /dev/null 21 and been stopped :( --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
At 20:05 +0200 6/5/04, pourave wrote: At 19:21 +0200 6/5/04, pourave wrote: Hi, I am on a redhat, i read a lot of doc on the problem I hav but noway to advance, mysql won't start and won't tell anything : mysql is a client program. The server is named mysqld. I know under redhat a script call service is used to start mysql service : #service mysql start same as # /etc/rc.d/init.d/mysql start Okay. What does the MySQL error log say. Anything? Nothing : [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6212 0.0 0.1 3776 568 pts/0S12:59 0:00 grep mysql Mysql used to start automaticaly [EMAIL PROTECTED] [/var/log]# /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid /dev/null 21 [1] 6301 [EMAIL PROTECTED] [/var/log]# ps auxw | grep mysql root 6335 0.0 0.1 3776 568 pts/0S13:02 0:00 grep mysql [1]+ Done /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/leya .pid /dev/null 21 and been stopped :( --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.2 myisamchk chokes on a fulltext
On 04.06.2004 21:09 (+0200), Mark Maggelet wrote: Hi. I'm having this problem on 4.1.2, when I run myisamchk -o on my table I get a bunch of these lines: [...] Would you please not reply to a mail to create a new thread? This message will be displayed somewhere deep inside another thread and no-one would ever find it. -- Yves Goergen [EMAIL PROTECTED] BlackBoard Internet Newsboard System -- blackboard.unclassified.de Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Speed differences between joins and subqueries?
On 04.06.2004 20:46 (+0200), Sasha Pachev wrote: Subquery optimizer is still is a very early stage in 4.1. Much more often than not, a carefully crafted join, union, or a sequence of queries using a temporary table will be faster. In fact, I wonder if it is even possible to write a machine subquery optimizer that will outperform a good human optimizer that re-writes them into something better digestible. Kind of like no super-smart JIT will ever beat a good C programmer on execution speed, although it might help with the development time. Could there be a program that I can present my query and it gives me some alternatives with a benchmark of them? This may help me to create optimized queries and may inspire me to optimize them even further into a direction I didn't think of yet... -- Yves Goergen [EMAIL PROTECTED] BlackBoard Internet Newsboard System -- blackboard.unclassified.de Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Err 2002 socks suck noway to start
Okay. What does the MySQL error log say. Anything? Do you know where can I find it ? Dates are old 031222 ! ... [EMAIL PROTECTED] [/var/log]# tail mysqld.log /usr/sbin/mysqld: ready for connections. Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 031222 12:57:02 /usr/sbin/mysqld: Normal shutdown 031222 12:57:02 InnoDB: Starting shutdown... 031222 12:57:04 InnoDB: Shutdown completed 031222 12:57:04 /usr/sbin/mysqld: Shutdown Complete 031222 12:57:04 mysqld ended [EMAIL PROTECTED] [/var/log]# head mysqld.log 031202 22:05:39 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 031202 22:05:39 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 031202 22:05:39 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 031202 22:05:40 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB [EMAIL PROTECTED] [/var/log]# Thanks. David D --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question
I think he's talking about download MySQL, and verifying the binary using MD5. There is a link right above the downloads for verification of the binary. http://dev.mysql.com/doc/mysql/en/Verifying_Package_Integrity.html The contents of the page @ that URL suggest using GNU Privacy Guard. David Paul DuBois wrote: At 22:54 -0700 6/4/04, jerome greene wrote: Where do you run the verify programs from? Are they ran from the command prompt? Do I copy the keys? Thanks What is the context of these questions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Advice on Database Schema Design
I am converting a form that was originally designed to be Email Submitted into a Submit-to-PHP-Page Form (which will then insert the data into a MySQL Database). I expect no problems in actually scanning the submission to extract the data but I have some questions on the design of the Tables that I will need to define to store the data. I have done some research and have come up with a tentative design that I want to post here for critiquing. Here is what I have come up with. Each form will get assigned a sequence number (SubmitterID) that will identify the form submission in all the tables (thus linking them). There are a number of TextAreas where the user is requested to enter free form replies to questions. I am thinking that these should go into a separate table as Text fields of the correct size with SubmitterID as the Primary Key. That keeps the data away from the main table and thus only accessed when needed/requested as well as not bloating the size of the main table or slowing its retrieval/processing. There are a number of blocks of CheckBoxes on the form. While I could, in theory, use a SET column type to store them, I get the impression that a better way is to create a Many-to-One table for each block with the total contents of each row being the CheckBoxID and SubmitterID (in that order) as the Primary Key. A Index for SubmitterID would also be defined. This way I can do a WHERE on either Column and get Index Usage as opposed to needing to do a row-by-row lookup. I have the impression that doing a WHERE over a SET Column (especially when I'm looking for more than one value) is not a good or efficient idea. The CheckBoxID would map to a 3rd table to get the actual CheckBoxName. There are also two Select Tables (one for US States and one for Countries). While the States are passing the USPS 2-Letter State Codes, the Countries are passing the full Country Name as their OPTION VALUE=. I want to make a State Table and a Country Table using respectively the 2-Letter Code and a sequential reference number (which I will revise the Country OPTION tags to use as their VALUE) as the Primary Key with the State or Country Name as the other column. To create the reference key and populate the OPTION pages with it I plan to take the current HTML for these tags and read them into a Text Editor where I will then alter them into MySQL Insert Commands to populate the Table. Then using a one-shot QuickDirty PHP page, I will read the table and recreate the Option Statements which would the be CutPasted into the original HTML code replacing the old versions of the tags. The states go though the same Turn into INSERT Commands but there is no need for post processing or HTML Tag replacement. Of course all the Table Pointers would be defined as Foreign Keys to insure Referential Integrity. Am I making any mistakes in my design or am I on the correct track. I welcome any critique of my design or advice on how to improve it. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Get fields in one field, separated by comma's
Klaas Geldof [EMAIL PROTECTED] wrote: I have a question about MySQL queries. First I will explain the situation, then I will provide an example. Situation: I have the tables 'offer', 'contact' and 'offer_contact'. Table 'offer' contains data about offers, table 'contact' about contacts. Table 'offer_contact' tells which contacts are associated with which offers (since offers can have multiple contacts associated with it and vice versa). Now I want to run a query so I get a row for each offer and in the result there's a field 'offer_contacts' which contains all the names of the contacts associated with the offer on that row separated by comma's. Example: Table 'offer' (offer_id - offer_title): 1 - Test 2 - Also test Table 'contact' (contact_id - contact_name): 1 - John 2 - Anna Table 'offer_contact' (offer_id - contact_id): 1 - 1 1 - 2 2 - 1 Wanted result of query (offer_id - offer_name - offer_contacts): 1 - Test - John, Anna 2 - Also test - John Is this possible? GROUP_CONCAT() function may help. This function is available from version 4.1: http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FreeBSD 5.x
Hi, Does anybody have experience with FreeBSD 5.x Mysql ? FreeBSD 4.x and mysql seems to be awful combination due to threading , but I have no tried FreeBSD 5.x with mysql under heavy load Thanks, Peter Zyumbilev Project Manager Mansion Productions Inc. AIM: peterZmansion YMS: peterZmansion MSN: [EMAIL PROTECTED] Skype: peterZmansion ICQ: 108984925 support: http://support.hostmansion.com (24/7) email: [EMAIL PROTECTED] web: www.mansionproductions.com MPA2 - Mansion Production Automation Program MPA3 - Next Generation Automation Program CSS - Content Sale System MTS - Mansion Ticket System Hostmansion.com - Highest Quality Web Hosting The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company.
Subquery help...
This is my first email to the list, so be nice ;-) I'm having some difficulty with a subquery that I'm trying to do, and was wondering if anyone here can shed some light on the issue... This query returns a result as expected: SELECT id FROM client_list WHERE name=Some Company (the id returned here is 3) This query also returns a result as expected: SELECT id FROM work WHERE client_id='3' ORDER BY id DESC; Does anyone know why this one doesn't return any results? SELECT id FROM work WHERE client_id='(SELECT id FROM client_list WHERE name=Some Company)' ORDER BY id DESC; Thanks for any help :) -Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subquery help...
On Sat, 5 Jun 2004 19:48:44 -0600 Daniel Isenhower [EMAIL PROTECTED] wrote: This is my first email to the list, so be nice ;-) Welcome, this is a very helpful list... I'm having some difficulty with a subquery that I'm trying to do, and was wondering if anyone here can shed some light on the issue... First off, I assume you are using a version of mysql able to handle sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries) This query returns a result as expected: SELECT id FROM client_list WHERE name=Some Company (the id returned here is 3) This query also returns a result as expected: SELECT id FROM work WHERE client_id='3' ORDER BY id DESC; Does anyone know why this one doesn't return any results? SELECT id FROM work WHERE client_id='(SELECT id FROM client_list WHERE name=Some Company)' ORDER BY id DESC; Don't use quotes, it's looking for a client_id that is literally the stuff inside your quotes. I'm guessing that'll never be the case. :) Try: SELECT id FROM work WHERE client_id = (SELECT id FROM client_list WHERE name=Some Company) ORDER BY id DESC; FWIW, this is an easy query with a JOIN: SELECT id FROM work w INNER JOIN client_list cl ON cl.id = w.client_id WHERE cl.name = 'Some Company'; Just in case you are using mysql 4.0 or earlier... Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: IS NULL works, but IN (NULL) doesn't
If you need it to work, I'm afraid you're out of luck. Think about what a IN (x,y,z) means. It's basically the same as a = x or a = y or a = z. So wifi_list IN (NULL) is like wifi_list = NULL, which is never true. Thanks for the reply Paul, and I get that NULL is a special case value, but if wifi_list IS NULL works, then why doesn't wifi_list = NULL? Logically they seem to be the same, is IS only used for NULL values or something? Or in other words, it would make sense to me that I should be able to say wifi_list IS 3 instead of an = sign. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 7:56 PM At 18:32 -0700 6/3/04, Daevid Vincent wrote: How come this one works: SELECT wifi_list,IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen = CURRENT_DATE AND wifi_list IS NULL; This one works too SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen = CURRENT_DATE HAVING wifi_list_new IN (0,1,2); But this one doesn't... I *need* this to work: SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen = CURRENT_DATE AND wifi_list IN (NULL); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subquery help...
First off, I assume you are using a version of mysql able to handle sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries) Ugh... I feel dumb :) I'm using 4.0 FWIW, this is an easy query with a JOIN: SELECT id FROM work w INNER JOIN client_list cl ON cl.id = w.client_id WHERE cl.name = 'Some Company'; Just in case you are using mysql 4.0 or earlier... Thanks very much! This is what I need :) Also, while I'm at it, any book recommendations for getting to know MySQL better? Thanks again :-) -Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: IS NULL works, but IN (NULL) doesn't
At 18:50 -0700 6/5/04, Daevid Vincent wrote: If you need it to work, I'm afraid you're out of luck. Think about what a IN (x,y,z) means. It's basically the same as a = x or a = y or a = z. So wifi_list IN (NULL) is like wifi_list = NULL, which is never true. Thanks for the reply Paul, and I get that NULL is a special case value, but if wifi_list IS NULL works, then why doesn't wifi_list = NULL? Because that is not now NULL comparisons work. The expression any_value = NULL is *never* true. There is a special MySQL-Specific = operator that is like = but evaluates to true for any_value = NULL when any_value is NULL. But that's not going to make any_value IN (NULL) work, which is what you appear to want. Logically they seem to be the same, is IS only used for NULL values or something? Or in other words, it would make sense to me that I should be able to say wifi_list IS 3 instead of an = sign. Yes, IS is only for IS NULL comparisons. You might want to take a look at this section: http://dev.mysql.com/doc/mysql/en/Problems_with_NULL.html -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 7:56 PM At 18:32 -0700 6/3/04, Daevid Vincent wrote: How come this one works: SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen = CURRENT_DATE AND wifi_list IS NULL; This one works too SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen = CURRENT_DATE HAVING wifi_list_new IN (0,1,2); But this one doesn't... I *need* this to work: SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen = CURRENT_DATE AND wifi_list IN (NULL); -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL daemon fails after setting root password
anyone know why the mysql daemon fails to start after I set the root
password according to this:
http://dev.mysql.com/doc/mysql/en/Default_privileges.html
I use the command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');
This is on SuSE 9.0 with mysql version 4.0.15
thanks
marshall
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not Getting DB Connection
Hi,
I am using the following code but not getting a
connection. :( Can someone tell me what I am doing
incorrectly?
Thanks, Scott
package database_test;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
// Notice, do not import com.mysql.jdbc.*
// or you will have problems!
/**
* pTitle: Phone # regex:
^([(]?\d{3}[-)]\d{3}-\d{4})*$ /p
* pDescription: /p
* pCopyright: Copyright (c) 2004/p
* pCompany: /p
* @author unascribed
* @version 1.0
*/
public class DBConnector
{
//Class State
private String dbuser,dbpasswd,dburl;
public DBConnector()
{
dbuser=sspiegler;
dbpasswd=cuatro;
dburl=
jdbc:mysql://localhost:3306/menagerie?user=+dbuser+password=+dbpasswd;
}
public DBConnector(String aDburl,String
aDbuser,String aDbpasswd)
{
this.dbuser=aDbuser;
this.dbpasswd=aDbpasswd;
this.dburl=aDburl;
}
public Connection getConnection () throws
SQLException
{
ResultSet rs=null;
Connection conn=null;
try
{
conn = DriverManager.getConnection(dburl);
Statement state = conn.createStatement();
rs = state.executeQuery(SELECT * FROM
pets);
if (rs != null)
{
// here you would do something with
the ResultSet
}
}
finally
{
if (rs != null)
{
rs.close();
}
}
return conn;
}
/**
* *** for testing purposes only ***
*/
public static void main(String[] args)
{
Connection conn = null;
DBConnector dbc = new DBConnector();
try
{
conn = dbc.getConnection();
}
catch(SQLException sqle)
{
System.out.println(SQLException: +
sqle.getMessage());
System.out.println(SQLState: +
sqle.getSQLState());
System.out.println(VendorError: +
sqle.getErrorCode());
}
}
}
=
We don't see things as they are, we see things as we are.
--Anais Nin
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question
Sorry guys if I was not clear. I have copied mysql-4.0.20a-win.zip to my computer. On the downloads page it is suggested that I verify the integrity of the packages that I downloaded. I am trying to fine out how to do this. I first have to unzip the file first. Do I copy the code from MD5 Checksum page? I guess I put the code into the same directory where I unzip the file. To run the md5sum package_name do I run it from the command prompt? Or do I have it all wrong? Thanks Guys. Oh, I am running on a windows xp home edition machine. If that matters. David Griffiths [EMAIL PROTECTED] wrote: I think he's talking about download MySQL, and verifying the binary using MD5. There is a link right above the downloads for verification of the binary. http://dev.mysql.com/doc/mysql/en/Verifying_Package_Integrity.html The contents of the page @ that URL suggest using GNU Privacy Guard. David Paul DuBois wrote: At 22:54 -0700 6/4/04, jerome greene wrote: Where do you run the verify programs from? Are they ran from the command prompt? Do I copy the keys? Thanks What is the context of these questions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger
PHP RPM + 3 binary install of Mysql-4.0.20
I have redhat9. I removed the RPM install of MySQL, and instead installed 3 copies of MySQL-4.0.20 BINARY distributions into my /usr/local/ directory, under the helpful instructions of Thierno Cisse. However, it seems like now, the PHP RPM installation cannot find the mysql extension. When I try to load up phpMyAdmin-2.5.6(after changing the port and socket values to reflect the mysql directory), I get cannot load MySQL extension, please check PHP Configuration. Documentation After prodding around, my guess is that because when I uninstalled the MySQL RPM, the MySQL extension was also removed and the PHP RPM installation can no longer locate the MySQL directory. My question is... how do I resolve this; in the case of 1 PHP installation and multiple copies of MySQL Binary distribution installations, make PHP access the correct MySQL installation?? Thanks in advance, -Minuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
