FW: CSETI Announcement - Urgent Disclosure Project Update
Please read and forward. -Original Message- From: James [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 21:39 To: Young, Stuart; Raf; Nicky Gosney; Nick; [EMAIL PROTECTED]; John Boddy; Iain; Green, Karen; Darren S; Andy; [EMAIL PROTECTED] Subject: FW: CSETI Announcement - Urgent Disclosure Project Update -Original Message- From: Tony Craddock [mailto:[EMAIL PROTECTED]] Sent: 14 February 2001 05:35 To: [EMAIL PROTECTED] Subject: CSETI Announcement - Urgent Disclosure Project Update Please Post and Distribute As Desired Since August of 2000, the CSETI Disclosure Project has recorded the testimony of over 100 military, government and related witnesses to UFO events and projects from around the world. The testimony of these courageous witnesses creates a permanent archive with the most profound implications as it constitutes dozens of first-hand, often top-secret witnesses to UFO events, internal UFO -related government projects and covert government activities related to UFOs, Extraterrestrial Intelligence and exotic energy and propulsion system projects. These 100 witnesses constitute the tip of a larger pool of over 400 prospective witnesses, many of whom would prefer coming forward first in formal Congressional hearings --which we hope will follow the upcoming planned disclosure event. This testimony is on broadcast quality digital videotape and audio tape. Printed transcriptions of the testimony are currently being created. We are requesting that any further military, government, government- contractor or related witnesses to UFO events and projects contact CSETI Director Dr. Steven Greer immediately for inclusion in the briefing materials and the upcoming disclosure event. Such witnesses may contact Dr. Greer via the CSETI website at www.cseti.org http://www.cseti.org/ or at 540 456 8302 (government witnesses only should use this number, please). Additionally, any other substantial, supporting evidence, such as government documents, high quality UFO photographs and videotaped images, hard evidence etc. should similarly be referred to the project for inclusion in the final briefing materials and disclosure Press Conference. The date for the Disclosure Press Conference and related activities in Washington DC has been set and will occur in the Spring of this year (2001). Prior to the Disclosure Press Conference we will be conducting private briefings for key leaders in society, government and related institutions (for example, members of the US Congress, White House staff, scientific and religious leaders etc). If you have good access to such leaders and can assist with arranging a briefing please contact Dr. Greer as soon as possible. This body of testimony is being edited and the over 100 hours of testimony will be condensed into a 2 hour briefing video. Additionally, a written briefing document consisting of witness testimony transcripts, government documents and important case material and policy papers is being prepared for use in the briefings and in the Disclosure Press Conference in Washington. The Disclosure Press Conference will present many of the government witnesses in person, and the other evidence and briefing materials will be available to the media at that time. People with excellent national and international media contacts who can assist pro bono with media coordination are invited to contact Dr. Greer also. Unfortunately, a documentary containing this witness testimony will not be available as there are insufficient funds to complete such a project. We would like to thank all of the supporters and contributors to this historic effort and especially the witnesses who have come together to let the world know the truth about this very important matter. Anyone who would like to help support this effort is invited to make a tax-deductible contribution to : The Disclosure Project, PO Box 265, Crozet Va 22932. Further updates will be issued as the date for the event approaches. Again, we would like to thank our many supporters for their assistance in and dedication to disclosing the truth. The Disclosure Project CSETI 11 February 2001
Order of the update log
Are entries in the update log recorded in the *exact* order that the SQL 'hits the database'? I am using mysql version 3.22.22. I would normally assume the log was accurate but someone just told me that with mySQL log entries can be out of order by a few seconds because different mySQL processes write to the one log file. Thus they have to wait for the other to complete. Is this true? Also, are log entries written in the order that the SQL requests come in, or in the order that the requests are completed? Regards, Sonam -- Electronic Commerce Corporate Express Australia Ltd. Phone: +61-2-9335-0725 Fax: +61-2-9335-0753 - 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
Win2K and MyODBC?
Hi, When I ran the application that uses myodbc as the interface to the mysql server (linux) on a Win98 platform, it works fine. But when I transferred the application to a Win2K pc and run it, I cannot even get through a connect. I have already granted access for the Win2K pc to access the mysql server with the correct username and password. I tested it using the mysql gui and it connects fine. Are there any known problems when using myODBC with Win2K? Or are there any write ups on what needs to be done to get myodbc to work in Win2K environment? Thanks, Li Sze
MySQL Client Application Suggestions
Hello all, I'm planning to develop a MySQL client application for Windows. This application should be able to connect, make queries, search, insert, view and create and print reports. My intention is to make the source code free to download for anyone interested. Help, advice, suggestions and comments are all welcome. Please email me direct at: [EMAIL PROTECTED] or simply reply to this list. Thank you in advance. -- Carlo Macis - 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
Select Problem
Linux , Apache, MySQL I have a problem in my MySQL database, this is the senario: I made an update statement on my table by wrong, then I restor my backup copy by copying the backup files on the exist ones without stopping the MySQL. Now I have problems in searching data: for example when I made select statement using = , no results, but when I use %something% I can get the result, this thing not happend with all records, just some of them. any help will be appreciated. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help please: getting the total from the results of SUM
hi rus, It seems my first question was not very clear. I wanted to use a function that I don't know if it exists or if there is some way to do this. Its name is TOTAL and what it does is add all values ignoring the GROUP BY clause, unlike SUM that is affected by GROUP BY. So from a bigger table than what I had below: Event_Num, Name, Amount 1 Name1 15 2 Name2 15 3 Name3 30 4 Name1 45 5 Name2 20 6 Name3 35 I can get the following output: Name, Amount, Total, Percent Name1 60 16037.5 Name2 35 16021.875 Name3 65 16040.625 So if the function TOTAL exists, I can do this: SELECT Name, sum(Amount) as Amount, TOTAL(Amount) as Total, 100 * Amount/Total as Percent from table1 where ... GROUP BY Name; and TOTAL would give me the TOTAL of all Amounts so I can use it to calculate for percent. I want can do this calculation in one line. :) Currently I use two SELECT statements, the first to get the total, then use that value to calculate for the percent. jerome From: "Rus" [EMAIL PROTECTED] To: "jerome auza" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Help please: getting the total from the results of SUM Date: Thu, 15 Feb 2001 00:47:49 +0300 Did you try select count(*), sum(amount) from table1; you also can use ... count(if(field=value,1,NULL)) ... - Original Message - From: jerome auza [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 2:49 AM Subject: Help please: getting the total from the results of SUM Hi, Is it possible to get the total from the results of SUM in the same SQL statement? I want to have this output: NameAmount Percent Name1 15 25 Name2 15 25 Name3 30 50 My database only have the first two columns and the Percent column is calculated as 100 * Amount/TOTAL where TOTAL is equal to the SUM of the Amounts. Note that TOTAL would change if I have a different WHERE clause. Any help would be appreciated. jerome _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
unsecsribe
unsecsribe - 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
Can't connect in Windows 2000
I have installed Mysql on my Windows 2000 machine and everything seems to be working fine. However, when I try to telnet using the ip address on port 23 it won't connect. Sometimes it says something like 'NTLM authentication required'. I have IIS 5 installed. Does anyone know what I can do to connect? Many thanks James - 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: Select Problem
Try rebuilding the indexes. -Original Message- From: Alaiddin Tayeh [SMTP:[EMAIL PROTECTED]] Sent: 15 February 2001 10:34 To: [EMAIL PROTECTED] Subject: Select Problem Linux , Apache, MySQL I have a problem in my MySQL database, this is the senario: I made an update statement on my table by wrong, then I restor my backup copy by copying the backup files on the exist ones without stopping the MySQL. Now I have problems in searching data: for example when I made select statement using = , no results, but when I use %something% I can get the result, this thing not happend with all records, just some of them. any help will be appreciated. thanks - 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
Seg fault after install with 3.32.23 on 2.2 Debian SMP.
I've looked for info on this, but the only thing I could find that was close was BSD and thread libs. Build .32, install it, and the daemon segfaults when I try to set up the initial load. Can some one point my to the right starting place. TNX -- Paul Repacholi 1 Crescent Rd., +61 (08) 9257-1001 Kalamunda. West Australia 6076 Raw, Cooked or Well-done, it's all half baked. - 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
conversion of sql data to mysql
hi I am willing to convert the data from sql to mysql but i don't what quary should i pass to do the same, can you help me out. thanking you in anticipation manish __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.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
from SQLServer7 to MySQL
Does anyone know of any good resources on converting an SQLServer7 database to MySQL? In particular, what's the best method of copying the data (about 150MB over 10 000 kilometres), and do any changes need to be made to datatypes? thx for any info or pointers to resources Dan - 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 takes so much resources
Hi there, I have 2 different websites using a single mysql server. Today the websites respons very slow and when I check the mysql proces i got the following info: PID %CPU %MEMVSZ RSS TT STAT STARTED TIME COMMAND 24339 51.6 0.7 6876 3704 p2- R10:56AM2:00.79 mysqld So I suspect that my websites is slow because of the mysql server takes so much of the CPU resources (51.6%). So how to solve this problem? I tried restarting mysql then it again reach up until 50-60% of CPU. Thanks Teddy
RE: Can't connect in Windows 2000
Hi James, Yes this IS mysql related as MySQL does not support a Telnet connection to it :) You can either use the mysql.exe utility in the mysql\bin directory to use your mysql server or try one of the many MySQL GUI clients available in the Contrib section of www.mysql.com ,for ex. http://www.scibit.com/Mascon which will get you started fast. Regards -Original Message- From: James T Fielding [mailto:[EMAIL PROTECTED]] Sent: 15 February 2001 13:56 To: [EMAIL PROTECTED] Subject: Can't connect in Windows 2000 Importance: High I have installed Mysql on my Windows 2000 machine and everything seems to be working fine. However, when I try to telnet using the ip address on port 23 it won't connect. Sometimes it says something like 'NTLM authentication required'. I have IIS 5 installed. Does anyone know what I can do to connect? Many thanks James - 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
Importing data to Excell
I have a table in my database, witch have a column thas is float(12,3), when i try to make a filter width that column i get an error message that says "Column PRPRVEND1 can't be used in criteria". Can someone tell me how to solve this problem? - 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 takes so much resources
On Thu, Feb 15, 2001 at 11:41:48AM +0800, Teddy A Jasin wrote: Hi there, I have 2 different websites using a single mysql server. Today the websites respons very slow and when I check the mysql proces i got the following info: PID %CPU %MEMVSZ RSS TT STAT STARTED TIME COMMAND 24339 51.6 0.7 6876 3704 p2- R10:56AM2:00.79 mysqld So I suspect that my websites is slow because of the mysql server takes so much of the CPU resources (51.6%). So how to solve this problem? I tried restarting mysql then it again reach up until 50-60% of CPU. Try to connect to your server with the mysql client and type: show processlist; This will show you what query it is working on. Maybe you need to start the mysql client with the -A option to prevent it from reading table info (which might wait for the query that mysqld is working on). When the cause is still not clear to you, then post the output of the 'show processlist' to the mailing list. Maybe we can help then. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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: auto_increment problem with mysql 3.23.32
William R. Mussatto writes: On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: can an auto_increment column also have the attribute "unsigned" safely? Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 Yes it can. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Linking problems.
Dave Juntgen wrote: I am unable to link libmysqlclient staticlly. I have tryed everything I could have thought, please look at the linking below, I tried to look for the file my_compress.o and my file system and I was unable to find it. gcc -g -Wall -O6 -static -o webchart.cgi -L../../mieutils/linux/lib ../../mieutils/linux/olddbmysql.o logininfo.o uuencode.o header s.o search.o storage.o dbbuffer.o webchart.o interface.o login.o typeutils.o topmenu.o sidemenu.o help.o popup.o barcode.o scheduler .o schedulerdb.o docdelete.o docprops.o doclocks.o wcdemo.o wctran.o tiffviewer.o wcnotes.o omniscope.o summary.o esign.o matchdocs. o echartdb.o chart.o newdoc.o docqueue.o upload.o reports.o docmover.o orders.o patmerge.o admin.o settings.o colors.o userwatch.o a ctivitylog.o translate.o tabmanager.o controldb.o directory.o printqueuedb.o printqueue.o tasklist.o -lmie \ -Lgd -lgd -lcrypt -lz -lmysqlclient /usr/bin/../lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x99): undefined reference to `uncompress' /usr/bin/../lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x128): undefined reference to `compress' collect2: ld returned 1 exit status Thank you all... Put the -lz after the -lmysqlclient, and make sure you have zlib.a, not zlib.so. - 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
Compiling MySQL for other character sets
Hi all, Would like to ask a few questions on how to go about compiling support for a multibyte character set into MySQL. When I compile by default without specifying any character sets, it's supposed to compile in ALL character sets. Yet, when I try to run a mysql daemon that was compiled in this manner, the option "--with-character-set=gb2312" will result in an error that says they can't find the specified character set. Why is this? When I compile using the "./configure --with-charset=gb2312" does it mean that ONLY the gb2312 character set will be used? what do I do to specify that mysql is compiled with a few character sets? When I run mysqld with the "--with-character-set=gb2312", what kind of behaviour can i expect when i sort normal Latin ascii text then? I'm running 2 websites that searches a mysql engine when running a search, one English website and one Chinese GB website. When mysql is running the default ISO-8859-1 character set, the Chinese website wouldn't work correctly. When running the gb2312 character set, the Chinese website works, but I'm worried about the English one then, hence my question. If possible, I'd like to avoid having to run 2 instances of the mysql daemon, and consequentually 2 instances of the Apache daemon as well. Thanks for any answers Wong - 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: SELECT help
Sir, haven't you posted this before? It looks familiar. You can't apply an aggregate function to an entire table if the SELECT statement has a GROUP BY clause. The aggregate function will return totals for the groups, not for the entire table. Bob Hall Can someone help me combine this statement ... SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON d.domain_id=b.domain_id WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C' GROUP BY domain_name with this statement ... SELECT sum(ammount_due) FROM billing_info WHERE domain_id = $domain_id AND status = 0 The code is for billing software to manage the accounts of my server clients. In the first statement I am selecting information about each domain from the table domain_info that are billable for this billing cycle. Also in the first statement I am checking to see if any invoice_ids exist for the domain in the table billing_info. If there are no ids, the code knows to add a setup fee to the charge. If there are ids, then they domain has already been charges in the past and been billed for the one-time setup fee. The second statment gets the entire ammount owed from the table billing_info. Anytime a domain incurs a charge (positive) or pays an invoice (neagtive), a line is added with this in the ammount_due collumn. I can't seem to get an error free result ... can anyone offer suggestions on some working codes that gets both of these statments into one? Thanks! Nick - 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 Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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: Can anyone do this ?
Sir, 99% of the time, if someone can't create a TEMPORARY table, it means that they're using an earlier version of MySQL that doesn't support temp tables. The best thing to do is to update to the most recent version. If you can't update (e.g. if MySQL is being maintained by a web hosting service), then you will have to create a persistant table, and then delete it before ending your session. If you're going to be using the table frequently, you can leave it in your database and just empty it before or after each use. Bob Hall Hi Bob/ All, I cannot get the creation of the TEMPORARY Table to work: The select statement works fine: mysql SELECT table1_id, Count(date) as c FROM Table2, Table1 - WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" - AND Table2.table1_id=Table1.id - GROUP BY Table1.id HAVING c=3; +---+---+ | table1_id | c | +---+---+ | 1 | 3 | +---+---+ 1 row in set (0.02 sec) mysql CREATE TEMPORARY TABLE counts - SELECT table1_id, Count(date) as c FROM Table2, Table1 - WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" - AND Table2.table1_id=Table1.id - GROUP BY Table1.id HAVING c=3; If I manually create this counts table and work with that I do get the desired output: mysql CREATE TABLE count (table1_id VARCHAR(10), c VARCHAR(10)); Query OK, 0 rows affected (0.06 sec) mysql insert into count VALUES (1,3); Query OK, 1 row affected (0.01 sec) mysql select * from count; +---+--+ | table1_id | c| +---+--+ | 1 | 3| +---+--+ 1 row in set (0.00 sec) mysql SELECT Table1.*, Table2.* - FROM Table1, Table2, count - WHERE Table1.id=Table2.table1_id AND Table1.id = count.table1_id - AND Table2.date BETWEEN "2001-02-04" AND "2001-02-06"; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 2 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ 3 rows in set (0.02 sec) Do you have any idea where I'm going wrong ? Kind Regards, -- Frank Sir, create a variable day_count with the count of days in the user-supplied range. Then set up the following temp table. CREATE TEMPORARY TABLE counts SELECT table1_id, Count(DISTINCT date_field) as cnt WHERE data_field BETWEEN min AND max GROUP BY id HAVING cnt = day_count; Now you have a table with the IDs of items that occur at least once each day in the user-supplied range. You don't need the DISTINCT if each item can only have one record per day. Now some inner joins should get the results you want. SELECT table1.*, table2.* FROM table1, table2, counts WHERE table1.id = table2.table1_id AND table1.id = counts.table1_id AND date_field BETWEEN min AND max; I haven't actually run this, which means that there's probably a mistake or three. Bob Hall __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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 2003: Can't connect to MySQL server on 'localhost' (10061) on Windows2000
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) - 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: Can anyone do this ?
Hi: the way I handle this situation is: "create temporary table if not exists tblName (somefld I need, etc.) select iptable.* (or field names) from myTable where bluemoon = yes" Works every time for me. You need to know that temporary tables are only available to the creating user during the session in which it is created (you can't find it with freemascon or any other tool that I am aware of) after the session is completed the temporary table is poofware. hope this helps. Jack :-)= - Original Message - From: "Web Depressed" [EMAIL PROTECTED] To: "Bob Hall" [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 4:46 PM Subject: Re: Can anyone do this ? Hi Bob/ All, I cannot get the creation of the TEMPORARY Table to work: The select statement works fine: mysql SELECT table1_id, Count(date) as c FROM Table2, Table1 - WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" - AND Table2.table1_id=Table1.id - GROUP BY Table1.id HAVING c=3; +---+---+ | table1_id | c | +---+---+ | 1 | 3 | +---+---+ 1 row in set (0.02 sec) mysql CREATE TEMPORARY TABLE counts - SELECT table1_id, Count(date) as c FROM Table2, Table1 - WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" - AND Table2.table1_id=Table1.id - GROUP BY Table1.id HAVING c=3; If I manually create this counts table and work with that I do get the desired output: mysql CREATE TABLE count (table1_id VARCHAR(10), c VARCHAR(10)); Query OK, 0 rows affected (0.06 sec) mysql insert into count VALUES (1,3); Query OK, 1 row affected (0.01 sec) mysql select * from count; +---+--+ | table1_id | c| +---+--+ | 1 | 3| +---+--+ 1 row in set (0.00 sec) mysql SELECT Table1.*, Table2.* - FROM Table1, Table2, count - WHERE Table1.id=Table2.table1_id AND Table1.id = count.table1_id - AND Table2.date BETWEEN "2001-02-04" AND "2001-02-06"; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 2 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ 3 rows in set (0.02 sec) Do you have any idea where I'm going wrong ? Kind Regards, -- Frank Sir, create a variable day_count with the count of days in the user-supplied range. Then set up the following temp table. CREATE TEMPORARY TABLE counts SELECT table1_id, Count(DISTINCT date_field) as cnt WHERE data_field BETWEEN min AND max GROUP BY id HAVING cnt = day_count; Now you have a table with the IDs of items that occur at least once each day in the user-supplied range. You don't need the DISTINCT if each item can only have one record per day. Now some inner joins should get the results you want. SELECT table1.*, table2.* FROM table1, table2, counts WHERE table1.id = table2.table1_id AND table1.id = counts.table1_id AND date_field BETWEEN min AND max; I haven't actually run this, which means that there's probably a mistake or three. Bob Hall __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.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: MySQL set up plan
Teddy A Jasin wrote: Hi All, Currently I have four websites using one MySQL server. The MySQL and the four websites each is placed on different server. However this MySQL server, I dont know why after running for a few days can stop responding that I have to restart the MySQL server. This caused my four websites also down. Now, how do I create the MySQL server such that I have 2 MySQL server running on the same server that if the main MySQL server is down, the other will be up and running. Of course that the other server must have the same databases. For your info, currently we have over 100MB of databases on the server running on Linux Redhat 6.2. A typical visit at one time on the website will be 2000 over (one hour). Thanks Teddy RedHat 6.2 will erase your mysql.sock file if you put it in /tmp. The culprit is /etc/cron.daily/tmpwatch. It cleans /tmp and /var/tmp. Either disable this command, or have mysql put the socket somewhere else. I put mine in /usr/local/tmp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how can i get a table array of a database
yindu wrote: hello,sir; i do know i can use "show tables" to get the table names list.but i need get a table name array to use in my application.like the array i get by "select" function . how can i do it?thank you! yin du "show tables" returns a table, just like a "select". What is wrong with "show tables"? - 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
CREATE TABLE
Hello, does anybody know why the following statement does not work when it contains "IF NOT EXISTS" CREATE TABLE IF NOT EXISTS tab_name. This is given in the manual but it does not work in this case. Any hint is appreciated. Ali - 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: Win2K and MyODBC?
At 18:13 15/02/2001 +0800, Li Sze wrote: Hi, I had connected a Win2k machine against a Linux Server using MyODBC but I don't remember if it was before or after the use of the encryption feature of Samba on the Linux Server. How you know Win2k machine only uses the encryption authentication. So I guess that SQLConnect uses the Windows way to try the connection. The last year I did a mail with instructions about the use of the encryption feature on Linux servers and Win2k machine. Regards, Miguel Hi, When I ran the application that uses myodbc as the interface to the mysql server (linux) on a Win98 platform, it works fine. But when I transferred the application to a Win2K pc and run it, I cannot even get through a connect. I have already granted access for the Win2K pc to access the mysql server with the correct username and password. I tested it using the mysql gui and it connects fine. Are there any known problems when using myODBC with Win2K? Or are there any write ups on what needs to be done to get myodbc to work in Win2K environment? Thanks, Li Sze __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table timestamps? More specific control of SHOW TABLE STATUS command
Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. The closest that I have seen thus far is: SHOW TABLE STATUS The Update_time field is most likely what I am after. However I was hoping to do something more like select Update_time from table(x) status Giving me one value back - the Update_time for table "x" of current database. Perhaps this is a candidate for function extension? Jay You might be able to use this, depending on your needs: from http://www.mysql.com/doc/D/A/DATETIME.html [snip] Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) You explicitly set the TIMESTAMP column to NULL. [/snip] .. Atle On Wed, 14 Feb 2001, Jay Lawrence wrote: Hey all, Is there a way to quickly obtain the last time a table was updated/touched? In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few searches on mailing lists has not uncovered this matter - but I could have missed it. TIA, Jay - 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 - how to refresh the slave thread when the connection is lost ?
Hi ! I have two servers in a co-master relationship between an ISDN router. When I shutdown the router (so the connection is down), the slave thread doesn't react. On the show processlist, I have reading master update even if the connection is lost. Why ? It's a problem because on the other server, the thread is killed and doesn't restart. How can I "refresh" the thread in order to have "reconnecting after a failed read" instead of "reading master update". thanks Jimmy Visitez mon site web: http://www.llimzsoft.com/ __ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif - 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
ORDER BY on a column of type FLOAT
Hi, I'm trying to do a select in a table an want to get the result ordered by a column 8col2) of type FLOAT. select col1,col2 from table where col1='vvv' ORDER BY col2; It does not work. Is this supposed to work and if so how should I do it. /Pelle - 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
Duplication Question
I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB is not too large 8 tables, about max 200 records in any table. What is the best way to do this? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics Surveillance Systems PH: (856) 722-3182 PAG: (888) 886-4956 - 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: Excel-MySQL
I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel to MySQL? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics Surveillance Systems PH: (856) 722-3182 PAG: (888) 886-4956 - 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
Can't find ./mysql/host.frm when starting mysqld
Hi; I have mysql-server-3.23.22.6 and mysql-3.23.22.6, pakages installed on my PC during Linux RedHat 7.0 installation. The probleme occurs when starting mysqld program : The command : mysql_install_db is OK but the command : safe_mysqld starts the server mysqld witch stops immediatly after. When I look at the file : /var/lib/mysql/my_local_host.err I find the lines : 010212 13:26:29 mysqld started 010212 13:26:30 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010212 13:26:30 mysqld ended The file host.frm is in : /var/lib/mysql/mysql/ I tried to copy all the files from /var/lib/mysql/mysql/ to /var/lib/mysql/ but the problem still remain. Can you help me please. Thank you. [EMAIL PROTECTED]
concurrency in mysqld library ?
Hi, We would be very interested in the possibility to link our application to mysqld library. We wanted to know if some concurrency will be managed to provide data integrity if two instances of my application are working at the same time... If not, is there a possibility to do it or do I just have to use Client/Server solution ? Does someone have an approximative date for 4.0 release. It seems that in the TODO list, it appears as a quick version... Thanks Patrick __ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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: CREATE TABLE
In article 000d01c0975e$08f57d40$[EMAIL PROTECTED], "Ali" [EMAIL PROTECTED] writes: Hello, does anybody know why the following statement does not work when it contains "IF NOT EXISTS" CREATE TABLE IF NOT EXISTS tab_name. This is given in the manual but it does not work in this case. Any hint is appreciated. IF NOT EXISTS was added in version 3.23.0. Maybe your MySQL is older than that. - 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: Restart MySQL after rebooting Linux
I believe so. I was trying that and was missing something because I could not get it to work. Dave Hodgkinson wrote: kentj [EMAIL PROTECTED] writes: I have been reading the mysql book by Dubois and trying to figure out how to implement his restart methods on a SUSE Linux 7.0 Box. Has anyone done this and can give me information how to do it? You mean like putting stuff in /etc/rc.d/init.d? -- Dave Hodgkinson,http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - 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: Duplication Question
mysqladmin create newdatabasename mysqldump olddatabasename | mysql newdatabasename Of course you'll need the usual username/password parameters as well. On Thu, 15 Feb 2001, Joe Ferrara wrote: I want to make an exact duplicate (differenet name) of my entire DB for test purposes. My DB is not too large 8 tables, about max 200 records in any table. What is the best way to do this? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics Surveillance Systems PH: (856) 722-3182 PAG: (888) 886-4956 - 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
Server configuration denies access to the data source
Within the last few days we've started having serious problems with our database. We have no problems connecting to it using "mysql" and "mysqladmin". For instance, this command lets us into the database just fine: mysql -ucustomer -p customer_database The database seems to be working correctly. However, many of our customers are having troubles getting their Java servlets and/or JSP pages to connect properly. Note that these customers have existing applications that have been working correctly for some time. They have not made any changes, nor have we. Now, all of a sudden, they are getting these errors in their error logs: Cannot load connection class 'java.sql.SQLException: Server configuration denies access to data source'. This is happening to multiple customers at the same time. The only way we can fix the problem is to shut down the mysql database server and restart it. Any idea what might be happening? We are running on RedHat 6.2 with mysql 3.22.32 from RPM. Thanks for the help! Tauren - 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
Restart server when it hangs?
Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not using persistent connections, should I be. is there a way to have mysql restart when it hangs? These are the errors I am getting: 010212 4:24:29 /usr/local/libexec/mysqld: Out of memory (Needed 16384 bytes) 010212 04:25:53 mysqld restarted /usr/local/libexec/mysqld: ready for connections 010208 3:42:57 Aborted connection 9634 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error reading communication packets) 010208 3:43:57 Aborted connection 9505 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error writing communication packets) 010208 03:54:55 mysqld restarted Alan - 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: Excel-MySQL
Save to a CSV (comma-delimited file) from Excel, and take a look at the "load data infile..." command within the mysql documentation. regards, P On Thu, 15 Feb 2001, Joe Ferrara wrote: I am not a Perl Guru. How would I set up this environment? Or is there another way to go from excel to MySQL? -- Joseph Ferrara Member of the Engineering Staff LOCKHEED MARTIN Naval Electronics Surveillance Systems PH: (856) 722-3182 PAG: (888) 886-4956 - 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
Accessing mysql tables from apache
Hello, We created a database in mysql and would like to know if there is any way to access them through a Web browser using Apache? Thanks for your help Mark - 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 executes on command-line but not in PERL
Hi, everyone, I've recently run into a strange phenomenon. I try to tun the statement "update accounts set loggedin=10 where username='user'" -- works fine from the command line. But I used it in a PERL DBI situation and it does NOTHING -- no error, nothing. I know the PERL code is fine, because I've tried substituting the $sql variable (containing the statement) with other statements just for test purposes, like for example changing some other fields -- and it works fine. In fact, I tried a combination statement, "update accounts set users=10, loggedin=10 where username='user'" and the users field updates but the loggedin field does not. Both are int(11) columns. And the very same statement works PERFECTLY from the command line. Does anyone have ANY idea? I've been busting my brains and trying all kinds of things -- with NO success. Thank you in advance, Laszlo Szijarto
user variables length
How many Bytes can I save in a user variable? Because I have the following strategy: I want to save all PrimaryKeys in a user variable SELECT @a:=' '; SELECT @a := CONCAT(@a, ', ', TPrimKey) FROM table WHERE condition; so it is very important to know how many bytes can be stored. regards Philipp Hasenfratz
Re: Table timestamps? More specific control of SHOW TABLE STATUScommand
On Thu, 15 Feb 2001, Jay Lawrence wrote: Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. A temporary workaround could be select max(timestamp) from sometable. Jan - 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
Percent?
I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay - 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-Client.rpm doesn`t install at all
Dear Sir, I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for MySql-devel-2.32.32 it also doesn`t install. And also tell em how to Uninstalled .rpm. Pls reply me asap. Regards, Linus.
Re: taxes
This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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 _ Get your FREE download of MSN Explorer at http://explorer.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
Embedded MySQL: Opinion Please
Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [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
Urgent Call for Participation
NuSphere has been asked to chair the MySQL track for the upcoming O'Reilly Open Source Conference (July 23-27 in San Diego, CA) and the deadline is virtually here -- decisions must be made by next Tuesday, Feb. 20. This is very short notice but we need your input by end of day tomorrow, Feb. 16. The original call for participation issued by O'Reilly closed on February 1 and some of you may well have submitted presentation and/or tutorial ideas through that avenue. If so, please resubmit those suggestions to me for review. If you hadn't yet submitted a proposal, we urge you to do so now. The information we need is the same as that outlined at O'Reilly's site at: http://conferences.oreilly.com/oscon2001/call.html but instead of sending the submission to them, you'll need to send it directly to me at [EMAIL PROTECTED] And remember, we're solicting specifically for MySQL-related talks and tutorials. Please note - travel and expenses are *not* being covered. Individual presenters are responsible for their own expenses. There is, however, a small stipend for the half-day tutorial. If you have any questions, please feel free to contact me at the number below, or via email. We recognize that this is a very tight timeframe but we're confident that there's plenty of great material out there in the MySQL developer community and that we can indeed present a great lineup. Thanks in advance for your prompt response. Judy -- ___ Judy Mintz Sr. Product Marketing Manager NuSphere Corporation Direct dial: 781-280-4768 - 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
Index not used for order by when more than 1 field selected, nowhere clause
Hi, I'm having a hard time figuring why mySQL does not use the index when sorting a table without any where clause when I include more than 1 field in the select part. To resume the case, I created a temp table with 3 single fields, added an index (see bottom for more details), ran 2 queries with explain: This one is fine, uses the index: mysql explain select isbn from tmp order by isbn\G *** 1. row *** table: tmp type: index possible_keys: NULL key: isbn key_len: 13 ref: NULL rows: 1000 Extra: Using index 1 row in set (0.00 sec) Adding just an extra field to the select and no longuer is the index used: mysql explain select isbn,author from tmp order by isbn\G *** 1. row *** table: tmp type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1000 Extra: Using filesort 1 row in set (0.00 sec) When used with the real table which has 160k rows and is called within a complex join that works fine (0.04 sec) and uses index until I add an order by clause, then takes 12secs. Help or hints on fixing the above will probably fix my real problem. Thanks for any help. Further details below, including mySQL version (3.23.30) and OS (RedHat 6.0). Francois mysql CREATE TEMPORARY TABLE tmp select isbn,author,title from ws_inventory where available = 1 limit 1000; Query OK, 1000 rows affected (0.04 sec) Records: 1000 Duplicates: 0 Warnings: 0 mysql alter table tmp add index(isbn); Query OK, 1000 rows affected (0.09 sec) Records: 1000 Duplicates: 0 Warnings: 0 mysql explain tmp\G *** 1. row *** Field: isbn Type: char(13) Null: Key: MUL Default: Extra: Privileges: select,insert,update,references *** 2. row *** Field: author Type: char(60) Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references *** 3. row *** Field: title Type: char(255) Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references 3 rows in set (0.00 sec) mysql explain tmp; ++---+--+-+-+---+--- --+ | Field | Type | Null | Key | Default | Extra | Privileges | ++---+--+-+-+---+--- --+ | isbn | char(13) | | MUL | | | select,insert,update,references | | author | char(60) | YES | | NULL| | select,insert,update,references | | title | char(255) | YES | | NULL| | select,insert,update,references | ++---+--+-+-+---+--- --+ 3 rows in set (0.00 sec) mysql Ver 11.10 Distrib 3.23.30-gamma, for pc-linux-gnu (i686) Connection id: 157 Current database: schoen Current user: schoen_root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.30-gamma Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 1 day 21 hours 24 min 47 sec Threads: 1 Questions: 655 Slow queries: 38 Opens: 89 Flush tables: 2 Open tables: 23 Queries per second avg: 0.004 - 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 executes on command-line but not in PERL
Thank you, Ryan, but the PERL code runs perfectly if I try it on any other field. It just doesn't run on THIS field. It's not a SPECIAL field in any way (like PRI Key or Unique or anything like that). When I run it in a compound statement like "update accounts set users=10, loggedin=10 where username='user'" -- the users field updates but the loggedin field does not. Both fields have exactly the same definition int(11). Plus the exact same query updates BOTH from the command line -- though only the one field in PERL. Thank you very much, Laszlo - 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
sometimes hanging queries
I've been having a problem for quite awhile now with a particular query sometimes taking a long time. The query in question is a web-based search for messages in a bbs archive. Every time a message is added to the bbs each word in the message is parsed out and added to the 'search_messages_archive' table. It is based on the 'Slapping together a search engine...' article on phpbuilder.com. When the query hangs the server load spikes and can cause other queries to fail. The tables involved in the query are: mysql show columns from search_messages_archive; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | word | char(50) | | MUL | | | | message_number | mediumint(8) unsigned | | MUL | 0 | | ++---+--+-+-+---+ mysql show columns from messages_archive; +-+---+--+-++---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-++---+ | message_number | mediumint(8) unsigned | | MUL | 0 | | | message_area_number | smallint(5) unsigned | | MUL | 0 | | | message_area| varchar(100) | | | | | | topic_number| mediumint(8) unsigned | | MUL | 0 | | | topic | varchar(100) | | | | | | message | text | | | | | | post_date | date | | | -00-00 | | | post_time | time | | | 00:00:00 | | | user_name | varchar(40) | | MUL | | | +-+---+--+-++---+ 14 rows in set (0.00 sec) Here is the query 'EXPLAINED': EXPLAIN SELECT DISTINCT messages_archive.message_number FROM search_messages_archive,messages_archive WHERE messages_archive.message_number = search_messages_archive.message_number AND search_messages_archive.word IN ('warmoth') LIMIT 0,11; +-+---+-++-++--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+-++-++--+-+ | search_messages_archive | range | word,message_number | word | 50 | NULL | 1630 | where used; Using temporary | | messages_archive| ref | message_number | message_number | 3 | search_messages_archive.message_number | 19 | Using index | +-+---+-++-++--+-+ + Now here are the results of the query: From the slow query log (26 seconds): # Time: 010215 11:24:06 # User@Host: [nobody] @ localhost [] # Time: 26 Lock_time: 0 Rows_sent: 11 SELECT DISTINCT messages_archive.message_number FROM search_messages_archive,messages_archive WHERE messages_archive.message_number = search_messages_archive.message_number AND search_messages_archive.word IN ('warmoth') LIMIT 0,11; The same query run from the command line: (only .39 seconds!) mysql SELECT DISTINCT messages_archive.message_number FROM search_messages_archive,messages_archiveWHERE messages_archive.message_number = search_messages_archive.message_number AND search_messages_archive.word IN ('warmoth') LIMIT 0,11; ++ | message_number | ++ |427 | |438 | |622 | | 1485 | | 2147 | | 1520 | | 1675 | |679 | | 1021 | | 1226 | | 2560 | ++ 11 rows in set (0.39 sec) Even now as I run the query from the web browser again it is very fast. I just have not been able to track down what causes this query to be so slow at times and very fast at others. MySQL version: 3.23.32 OS: SuSE Linux (2.2.10 kernel) System: PIII w/ 256Mb RAM Let me know if more info is required TIA. -karl - Before posting, please check: http://www.mysql.com/manual.php
Re: Restart server when it hangs?
Hi Alan, Sounds like you need to do some tuning, you are running MySQL low on resources. This is one situation MySQL does not handle well. You need to adjust the login class to have more memory for instance you could create a class named "sql" and place it in your login .conf, then use vipw to change to login class of the mysql user. I have attached an example. You could also just use the daemon class. #Add more relaxed memory for database users sql:\ :path=/bin /usr/bin /usr/contrib/bin /usr/X11/bin:\ :datasize-max=128M:\ :datasize-cur=64M:\ :maxproc-max=128:\ :maxproc-cur=64:\ :openfiles-cur=6000:\ :radius-challenge-styles=activ,crypto,skey,snk,token:\ :stacksize-cur=64M:\ :tc=auth-bsdi-defaults:\ :tc=auth-ftp-bsdi-defaults: On the PHP errors Are you using the latest PHP 4.0.4pl1 or are you using the contrib, I would guess the contrib, try the latest PHP. Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Alan Halls" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 12:12 PM Subject: Restart server when it hangs? Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not using persistent connections, should I be. is there a way to have mysql restart when it hangs? These are the errors I am getting: 010212 4:24:29 /usr/local/libexec/mysqld: Out of memory (Needed 16384 bytes) 010212 04:25:53 mysqld restarted /usr/local/libexec/mysqld: ready for connections 010208 3:42:57 Aborted connection 9634 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error reading communication packets) 010208 3:43:57 Aborted connection 9505 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error writing communication packets) 010208 03:54:55 mysqld restarted Alan - 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: Percent?
couldn't you just do: SELECT data1 * 100 FROM table; which if data1 is 0.25, you'd get a result of 25, and depending on what you're using for the frontend, it would be really easy to add on the percentage sign - Atle On Thu, 15 Feb 2001, John Halladay wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay - 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
FW: Accessing mysql tables from apache
Mark: You can either load perl module and use perl/cgi , or install php with mysql module enabled karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 9:10 AM To: [EMAIL PROTECTED] Subject: Accessing mysql tables from apache Hello, We created a database in mysql and would like to know if there is any way to access them through a Web browser using Apache? Thanks for your help Mark - 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
Query/Left Join problem
Hi there. I'm having a problem with a couple of tables I'm using and finding some missing records and I was hoping someone could help me. Here is the setup. I have a table that is called "perms". Within here I have a bunch of columns, only 2 of which are important. ID which is an auto increment field and is my primary key for this table. mass_mail which has a value of 'Si' or 'No'. +---+--+ | mass_mail | count(mass_mail) | +---+--+ | No| 2871 | | Si| 8854 | +---+--+ The second table I have is called "newsletter_subscription". This table also has a bunch of columns member_id which is the only important one. There is one record in newsletter_subscription for each record within perms where mass_mail='Si', plus a few records (almost 100) which have a member_id of 0. When I do this: select count(*) from newsletter_subscription where member_id0; I get: +--+ | count(*) | +--+ | 8857 | +--+ As you can see there are three more records in the newsletter_subscription table that should not be (8854/8857). So to find those three records I try this: SELECT newsletter_subscription.member_id FROM newsletter_subscription LEFT JOIN perms ON newsletter_subscription.member_id=perms.id WHERE newsletter_subscription.member_id0 AND perms.id IS NULL; I get: Empty set (0.11 sec) I need to find the three extra records that are in newsletter_subscription and remove them. How would I go about finding them. I also checked the newsletter_subscription table to make sure that it did not have any duplicate member_id's other then the few records with a member_id of 0. The way I did it was to do this: SELECT member_id, count(member_id) FROM newsletter_subscription GROUP BY member_id ORDER BY 2 ASC Then I look at the last couple of lines and see this: | 11922 |1 | | 0 | 73 | +---+--+ 8859 rows in set (0.10 sec) Is there a faster/easier way to do this? something like WHERE count(member_id) 1 (although I know this does not work in that query) Thanks, Roger Ramirez Senior Developer TodoBebe.com - Todo lo que quiere saber de su beb. TodoBebe.com - The best baby website in Spanish! www.todobebe.com [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
FW: from SQLServer7 to MySQL
Hi Dan: I am looking for solution now , please email me if you get the answer karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 -Original Message- From: Daniel Kirk [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 11:35 PM To: [EMAIL PROTECTED] Subject: from SQLServer7 to MySQL Does anyone know of any good resources on converting an SQLServer7 database to MySQL? In particular, what's the best method of copying the data (about 150MB over 10 000 kilometres), and do any changes need to be made to datatypes? thx for any info or pointers to resources Dan - 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: taxes
Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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 _ Get your FREE download of MSN Explorer at http://explorer.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 - 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: Index not used for order by when more than 1 field selected, no where clause
Hi, I think you are mis-understanding the information provided. What the "using index" note means is that the isbn column is part of the index, and since that is all that is selected, the index file is used to provide the data, the data file is not touched. Since there is (usually) less data in the index file, and it is more organised, the query takes less time. Adding the author to the query means that the query now has to go to the data file to get the information, and since there is no restriction on isbn, the entire table is scanned for records to provide the result, which is then sorted. If you had an index of (isbn, author), then the index file would still be used. The clue is in the 'possible keys' value - NULL means that no keys are available that would help in providing the query. Can someone else tell me and Francois, when the index is used like this, is the result pre-sorted, so the order by is trivial, or is a sort still performed. Hope this helps Regards Quentin -Original Message- From: Franois Blanger [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 08:01 To: [EMAIL PROTECTED] Subject: Index not used for order by when more than 1 field selected, no where clause Hi, I'm having a hard time figuring why mySQL does not use the index when sorting a table without any where clause when I include more than 1 field in the select part. To resume the case, I created a temp table with 3 single fields, added an index (see bottom for more details), ran 2 queries with explain: This one is fine, uses the index: mysql explain select isbn from tmp order by isbn\G *** 1. row *** table: tmp type: index possible_keys: NULL key: isbn key_len: 13 ref: NULL rows: 1000 Extra: Using index 1 row in set (0.00 sec) Adding just an extra field to the select and no longuer is the index used: mysql explain select isbn,author from tmp order by isbn\G *** 1. row *** table: tmp type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1000 Extra: Using filesort 1 row in set (0.00 sec) When used with the real table which has 160k rows and is called within a complex join that works fine (0.04 sec) and uses index until I add an order by clause, then takes 12secs. Help or hints on fixing the above will probably fix my real problem. Thanks for any help. Further details below, including mySQL version (3.23.30) and OS (RedHat 6.0). Francois mysql CREATE TEMPORARY TABLE tmp select isbn,author,title from ws_inventory where available = 1 limit 1000; Query OK, 1000 rows affected (0.04 sec) Records: 1000 Duplicates: 0 Warnings: 0 mysql alter table tmp add index(isbn); Query OK, 1000 rows affected (0.09 sec) Records: 1000 Duplicates: 0 Warnings: 0 mysql explain tmp\G *** 1. row *** Field: isbn Type: char(13) Null: Key: MUL Default: Extra: Privileges: select,insert,update,references *** 2. row *** Field: author Type: char(60) Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references *** 3. row *** Field: title Type: char(255) Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references 3 rows in set (0.00 sec) mysql explain tmp; ++---+--+-+-+---+--- --+ | Field | Type | Null | Key | Default | Extra | Privileges | ++---+--+-+-+---+--- --+ | isbn | char(13) | | MUL | | | select,insert,update,references | | author | char(60) | YES | | NULL| | select,insert,update,references | | title | char(255) | YES | | NULL| | select,insert,update,references | ++---+--+-+-+---+--- --+ 3 rows in set (0.00 sec) mysql Ver 11.10 Distrib 3.23.30-gamma, for pc-linux-gnu (i686) Connection id: 157 Current database: schoen Current user: schoen_root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.30-gamma Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 1 day 21 hours 24 min 47 sec Threads: 1 Questions: 655 Slow queries: 38 Opens: 89 Flush tables: 2 Open tables: 23 Queries per second avg: 0.004 - Before posting, please check: http://www.mysql.com/manual.php (the
Re: MySQL/MyODBC on Netware network
I implemented something almost identical to this setup in 1999. It worked well with Netware 4.11 (with IP enabled on the network) and mySQL 3.22.x running on both a Solaris and FreeBSD box. It should work fine with newer versions of Netware controlling the network. There are the standard integration issues with MS Access (search the myodbc list for these) and some issues with deploying a shared installation of MSAccess on Netware (contact me privately if you want more info), but other than that it went swimmingly well. Good luck. "Rob Graber" [EMAIL PROTECTED] wrote: I have a customer that is running on a Netware network. They do have the TCP/IP protocol running on the workstations that are using the Microsoft Client for Netware. I am planning to attach a SCO Openserver 5.0.5 Unix server running MySQL to their network and then use MyODBC to connect a MS Access front-end application to the MySQL database from each workstation. Has anyone done this? Any compatibility problems with Netware? Any patches or considerations to note in design and setup? Thanks for any feedback! Very truly yours, Rob G. - 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: Embedded MySQL: Opinion Please
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 1:00 PM Subject: Embedded MySQL: Opinion Please Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [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
Size of database vs. performance?
Hey folks... quick question -- are there any performance issues associated with databases of extremely large size? I'm not talking about hundreds of thousands of records to be searched -- I'm talking about a few hundred images being stored in a database. It's not like I'd be full text searching or sorting them, or anything like that... Thanks a lot, -- jon http://jonroig.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: Percent?
SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table; John Halladay [EMAIL PROTECTED] wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay - 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: Restart server when it hangs?
PHP4.0.4pl1 does not appear to fix the "lost connections" problem as it relates to persistent connections. It does appear to be fixed in the latest CVS version (currently 4.0.5-dev). Just FYI. "Ken Menzel" [EMAIL PROTECTED] wrote: On the PHP errors Are you using the latest PHP 4.0.4pl1 or are you using the contrib, I would guess the contrib, try the latest PHP. 010208 3:42:57 Aborted connection 9634 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error reading communication packets) 010208 3:43:57 Aborted connection 9505 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error writing communication packets) 010208 03:54:55 mysqld restarted - 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 Client Application Suggestions
Hi Carlo : You should be able to use MyODBC for windows which work with mysql karl chen Programmer , Information System Department Valley Presbyterian Hospital Tel (818) 782-6600 ext. 5141 -Original Message- From: Carlo Macis [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 1:43 AM To: [EMAIL PROTECTED] Subject: MySQL Client Application Suggestions Hello all, I'm planning to develop a MySQL client application for Windows. This application should be able to connect, make queries, search, insert, view and create and print reports. My intention is to make the source code free to download for anyone interested. Help, advice, suggestions and comments are all welcome. Please email me direct at: [EMAIL PROTECTED] or simply reply to this list. Thank you in advance. -- Carlo Macis - 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: Index not used for order by when more than 1 field selected, no where clause
15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]: Hi, I think you are mis-understanding the information provided. What the "using index" note means is that the isbn column is part of the index, and since that is all that is selected, the index file is used to provide the data, the data file is not touched. You're right. From Explain doc: Using index The column information is retrieved from the table using only information in the index tree without having to do an additional seek to read the actual row. This can be done when all the used columns for the table are part of the same index. Adding the author to the query means that the query now has to go to the data file to get the information, and since there is no restriction on isbn, the entire table is scanned for records to provide the result, which is then sorted. If you had an index of (isbn, author), then the index file would still be used. That's where I don't get it, I don't want to sort by author, only by isbn. Why does mysql needs to resort to a filesort while it has all the ISBN neatly ordered in an index? Can someone else tell me and Francois, when the index is used like this, is the result pre-sorted, so the order by is trivial, or is a sort still performed. Yes, how can we get mySQL to use an index for doing an order by? Must I create an index for each and every possible fields combination? Thanks for your lights on Using Index Quentin. Franois Blanger Sitepak: nouvelle vision Internet pour l'entreprise http://www.sitepak.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: Percent?
How about... mysql select concat(50/1432, '%') as percentage; ++ | percentage | ++ | 0.03% | ++ 1 row in set (0.00 sec) mysql select concat(1324/4.14, '%') as percentage; ++ | percentage | ++ | 319.8068% | ++ 1 row in set (0.01 sec) mysql select concat(round(1324/4.14, 2), '%') as percentage; ++ | percentage | ++ | 319.81%| ++ 1 row in set (0.00 sec) Keep in mind, that this value is now a string. -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 11:27 AM To: John Halladay Cc: MySQL List (E-mail) Subject: Re: Percent? couldn't you just do: SELECT data1 * 100 FROM table; which if data1 is 0.25, you'd get a result of 25, and depending on what you're using for the frontend, it would be really easy to add on the percentage sign - Atle On Thu, 15 Feb 2001, John Halladay wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay - 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: Percent?
Thanks again, that works great. One more question. Aside from giving it a percentage sign, how could I specify that I wanted to see two characters after the decimal? i.e. instead of 25% I would want 25.00% -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 1:36 PM To: John Halladay Cc: MySQL List (E-mail) Subject: Re: Percent? SELECT CONCAT(data1*100,'%') as percdata1, data2, data3 FROM table; John Halladay [EMAIL PROTECTED] wrote: I can't find this in the manual (maybe I'm looking in the wrong place). How do I show a value as a percent? For example. SELECT data1, data2, data3 FROM table; Assuming data1 is 0.25, how do I show it as 25%? SELECT PERC(data1), data2, data3 FROM table;? Thanks. John Halladay - 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: Query/Left Join problem
Hi, Your left join tried to find members in newsletter_subscriptions that don't exist in perms. How about they exist, but are 'No'?: SELECT newsletter_subscription.member_id FROM newsletter_subscription LEFT JOIN perms ON newsletter_subscription.member_id=perms.id WHERE newsletter_subscription.member_id0 AND (perms.id IS NULL OR mass_mail='No'); Does that give you what you need? Regards Quentin -Original Message- From: Roger Ramirez [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 08:34 To: MySQL List Subject: Query/Left Join problem Hi there. I'm having a problem with a couple of tables I'm using and finding some missing records and I was hoping someone could help me. Here is the setup. I have a table that is called "perms". Within here I have a bunch of columns, only 2 of which are important. ID which is an auto increment field and is my primary key for this table. mass_mail which has a value of 'Si' or 'No'. +---+--+ | mass_mail | count(mass_mail) | +---+--+ | No| 2871 | | Si| 8854 | +---+--+ The second table I have is called "newsletter_subscription". This table also has a bunch of columns member_id which is the only important one. There is one record in newsletter_subscription for each record within perms where mass_mail='Si', plus a few records (almost 100) which have a member_id of 0. When I do this: select count(*) from newsletter_subscription where member_id0; I get: +--+ | count(*) | +--+ | 8857 | +--+ As you can see there are three more records in the newsletter_subscription table that should not be (8854/8857). So to find those three records I try this: SELECT newsletter_subscription.member_id FROM newsletter_subscription LEFT JOIN perms ON newsletter_subscription.member_id=perms.id WHERE newsletter_subscription.member_id0 AND perms.id IS NULL; I get: Empty set (0.11 sec) I need to find the three extra records that are in newsletter_subscription and remove them. How would I go about finding them. I also checked the newsletter_subscription table to make sure that it did not have any duplicate member_id's other then the few records with a member_id of 0. The way I did it was to do this: SELECT member_id, count(member_id) FROM newsletter_subscription GROUP BY member_id ORDER BY 2 ASC Then I look at the last couple of lines and see this: | 11922 |1 | | 0 | 73 | +---+--+ 8859 rows in set (0.10 sec) Is there a faster/easier way to do this? something like WHERE count(member_id) 1 (although I know this does not work in that query) Thanks, Roger Ramirez Senior Developer TodoBebe.com - Todo lo que quiere saber de su beb. TodoBebe.com - The best baby website in Spanish! www.todobebe.com [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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
RedHat 7
Hi, I just wanted to confirm that MySQL is supported on RedHat 7. I saw references to RedHat 5.x and 6.x on the website but no references to RedHat 7. Thanks, shawn - 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: Setting up Access 2000 to work using a mySQL db...
I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host, the database name of "metrics" and port 3306. I had to setup the privileges very carefully in the MySQL user table and to spell my database name correctly in order to make it work. Rodrigo Antonio Reyes Cabrera wrote: Hi I am using Access 2000 and I would like to configure it in order to use it as a interface to a mySQL db. Is this possible? I think it is, but I haven't been able to get it done so far. I am using the myODBC driver, but I get error messages when I try to import or link a table from my db into Access. Nevertheless, I can connect from PHP using the same ODBC connection. What could be wrong? Rodrigo - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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: taxes
guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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 _ Get your FREE download of MSN Explorer at http://explorer.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 - 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: Query/Left Join problem
Duh why didn't I think of that. Thank you graciously. :) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 4:26 PM To: 'Roger Ramirez'; MySQL List Subject: RE: Query/Left Join problem Hi, Your left join tried to find members in newsletter_subscriptions that don't exist in perms. How about they exist, but are 'No'?: SELECT newsletter_subscription.member_id FROM newsletter_subscription LEFT JOIN perms ON newsletter_subscription.member_id=perms.id WHERE newsletter_subscription.member_id0 AND (perms.id IS NULL OR mass_mail='No'); Does that give you what you need? Regards Quentin -Original Message- From: Roger Ramirez [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 08:34 To: MySQL List Subject: Query/Left Join problem Hi there. I'm having a problem with a couple of tables I'm using and finding some missing records and I was hoping someone could help me. Here is the setup. I have a table that is called "perms". Within here I have a bunch of columns, only 2 of which are important. ID which is an auto increment field and is my primary key for this table. mass_mail which has a value of 'Si' or 'No'. +---+--+ | mass_mail | count(mass_mail) | +---+--+ | No| 2871 | | Si| 8854 | +---+--+ The second table I have is called "newsletter_subscription". This table also has a bunch of columns member_id which is the only important one. There is one record in newsletter_subscription for each record within perms where mass_mail='Si', plus a few records (almost 100) which have a member_id of 0. When I do this: select count(*) from newsletter_subscription where member_id0; I get: +--+ | count(*) | +--+ | 8857 | +--+ As you can see there are three more records in the newsletter_subscription table that should not be (8854/8857). So to find those three records I try this: SELECT newsletter_subscription.member_id FROM newsletter_subscription LEFT JOIN perms ON newsletter_subscription.member_id=perms.id WHERE newsletter_subscription.member_id0 AND perms.id IS NULL; I get: Empty set (0.11 sec) I need to find the three extra records that are in newsletter_subscription and remove them. How would I go about finding them. I also checked the newsletter_subscription table to make sure that it did not have any duplicate member_id's other then the few records with a member_id of 0. The way I did it was to do this: SELECT member_id, count(member_id) FROM newsletter_subscription GROUP BY member_id ORDER BY 2 ASC Then I look at the last couple of lines and see this: | 11922 |1 | | 0 | 73 | +---+--+ 8859 rows in set (0.10 sec) Is there a faster/easier way to do this? something like WHERE count(member_id) 1 (although I know this does not work in that query) Thanks, Roger Ramirez Senior Developer TodoBebe.com - Todo lo que quiere saber de su beb. TodoBebe.com - The best baby website in Spanish! www.todobebe.com [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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to add to a set
Bob Hall writes: What I want to do is something like this...a set variable in a table has a current value of "a,b,c" and I want to add the value "d" to it so the new value is now "a,b,c,d". The type is already defined as setval SET ('a', 'b', 'c', 'd', 'e', 'f') Ma'am, by variable, do you mean a column in a row? Try UPDATE table_name SET column_name = Concat(column_name, ",d") WHERE ... This worked perfectly, thanks! --Cindy - 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: taxes
Most of my clients get around this problem by incorperating the web side of the business under a different name. There have typically been two reasons for this; 1. it circumvents the tax issue. 2. if the web business encounters legal troubles et cettera...they can go belly up w/o affecting the core storefront locations...Anyway that's how they do it...not how everyone else does...this make good sense if your host is located in one state...;) ok I think we've veer far enough off course... cheers, mikel Mike Wexler wrote: Mikel King wrote: guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. Actually it gets complicated for two reasons. On the web site I run http://www.tias.com/ we have vendors in all 50 states. Second, if you have a business presence in the state the customer is located in, then you need to calculate the tax for *their* locality. So in the normal case where you are calculating the taxes for just 1 vendors. Who has only one location, then things can be simplified by dealing with only the rules of the state (and the localities within the state). cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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 _ Get your FREE download of MSN Explorer at http://explorer.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 Before posting, please check: http://www.mysql.com/manual.php
Install Prob
Hi, I am trying to install the latest distribution of mysql on a win 2000 box. The install program returns the following error each time: "An error occurred during the move data process -132" I noticed that someone else has brought up the same problem in the past on this list. I'm very curious to learn how that person resolved it. Thank you, Michael - 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: RedHat 7
Shawn Boedecker wrote: I just wanted to confirm that MySQL is supported on RedHat 7. I saw references to RedHat 5.x and 6.x on the website but no references to RedHat 7. I'm running the latest stable release under RH7 with no problems. (NOTE: I compiled it myself, instead of using RedHat's rpms) AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - 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: taxes
Also some states, like California, base their sales taxes for mail-order on the recipients postal code, not the vendors, unless the codes are the same. There are eight or nine different sales tax rates in CA depending on local taxes. Mike Wexler wrote: Mikel King wrote: guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. Actually it gets complicated for two reasons. On the web site I run http://www.tias.com/ we have vendors in all 50 states. Second, if you have a business presence in the state the customer is located in, then you need to calculate the tax for *their* locality. So in the normal case where you are calculating the taxes for just 1 vendors. Who has only one location, then things can be simplified by dealing with only the rules of the state (and the localities within the state). cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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 _ Get your FREE download of MSN Explorer at http://explorer.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 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
sometimes hanging query - more info
* I left out a piece of probably important information the first time: search_messages_archive contains 11.5 million records. messages_archive contains 760,000 records. Thanks. -karl * I've been having a problem for quite awhile now with a particular query sometimes taking a long time. The query in question is a web-based search for messages in a bbs archive. Every time a message is added to the bbs each word in the message is parsed out and added to the 'search_messages_archive' table. It is based on the 'Slapping together a search engine...' article on phpbuilder.com. When the query hangs the server load spikes and can cause other queries to fail. The tables involved in the query are: mysql show columns from search_messages_archive; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | word | char(50) | | MUL | | | | message_number | mediumint(8) unsigned | | MUL | 0 | | ++---+--+-+-+---+ mysql show columns from messages_archive; +-+---+--+-++---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-++---+ | message_number | mediumint(8) unsigned | | MUL | 0 | | | message_area_number | smallint(5) unsigned | | MUL | 0 | | | message_area| varchar(100) | | | | | | topic_number| mediumint(8) unsigned | | MUL | 0 | | | topic | varchar(100) | | | | | | message | text | | | | | | post_date | date | | | -00-00 | | | post_time | time | | | 00:00:00 | | | user_name | varchar(40) | | MUL | | | +-+---+--+-++---+ 14 rows in set (0.00 sec) Here is the query 'EXPLAINED': EXPLAIN SELECT DISTINCT messages_archive.message_number FROM search_messages_archive,messages_archive WHERE messages_archive.message_number = search_messages_archive.message_number AND search_messages_archive.word IN ('warmoth') LIMIT 0,11; +-+---+-++-++--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+-++-++--+-+ | search_messages_archive | range | word,message_number | word | 50 | NULL | 1630 | where used; Using temporary | | messages_archive| ref | message_number | message_number | 3 | search_messages_archive.message_number | 19 | Using index | +-+---+-++-++--+-+ + Now here are the results of the query: From the slow query log (26 seconds): # Time: 010215 11:24:06 # User@Host: [nobody] @ localhost [] # Time: 26 Lock_time: 0 Rows_sent: 11 SELECT DISTINCT messages_archive.message_number FROM search_messages_archive,messages_archive WHERE messages_archive.message_number = search_messages_archive.message_number AND search_messages_archive.word IN ('warmoth') LIMIT 0,11; The same query run from the command line: (only .39 seconds!) mysql SELECT DISTINCT messages_archive.message_number FROM search_messages_archive,messages_archiveWHERE messages_archive.message_number = search_messages_archive.message_number AND search_messages_archive.word IN ('warmoth') LIMIT 0,11; ++ | message_number | ++ |427 | |438 | |622 | | 1485 | | 2147 | | 1520 | | 1675 | |679 | | 1021 | | 1226 | | 2560 | ++ 11 rows in set (0.39 sec) Even now as I run the query from the web browser again it is very fast. I just have not been able to track down what causes this query to be so
Re: Re: Replication Bug in 3.23.33
Does this problem exist in 3.23.32?? Thanks for the bug report. The problem is a bug in the code that skips events when it sees a log entry with the same server id - something that can only happen in the bi-directional replicaiton setup. Fix: --- 1.85/sql/slave.cc Sat Jan 27 15:33:30 2001 +++ edited/slave.cc Wed Feb 14 12:35:34 2001 @@ -849,7 +849,8 @@ mi-inc_pos(event_len); flush_master_info(mi); - --slave_skip_counter; + if(slave_skip_counter) +--slave_skip_counter; delete ev; return 0;// avoid infinite update loops } --- Tenha uma conta de email Grátis no ACBusca! - 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: If, then, else . . .
Hi, Look in the manual under Flow Control functions for use in select statements, and you should find what you need. Regards Quentin -Original Message- From: John Halladay [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 12:32 To: MySQL List (E-mail) Subject: If, then, else . . . If I am querying a field that has either "a" or "b" as a value and I want a second field's value to be dependant on the first field's value, how would I right that? SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; The IF,THEN,ELSE is the only thing I can think of, but that is the Excel, Access side of my brain talking. Sorry for the basis question. Any help would be much appreciated. Thanks. John H. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: If, then, else . . .
Hi, U can do nested ifs in Mysql. I am not sure if there is a limit in the no of levels it can go upto. If U R going to do this for 1000's of records there may be a slight drop in performance. SELECT field1, if(field1="a",100,if(field1="b",200,"ERROR")) FROM table; will do perfect. Cheers! Thiru On Thu, 15 Feb 2001 16:32:25 -0700 John Halladay [EMAIL PROTECTED] wrote: - If I am querying a field that has either "a" or "b" as a value and I want a - second field's value to be dependant on the first field's value, how would I - right that? - - SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table; - - The IF,THEN,ELSE is the only thing I can think of, but that is the Excel, - Access side of my brain talking. Sorry for the basis question. Any help - would be much appreciated. - - Thanks. - - John H. - - - - 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 - - lB I --- T[rXJ peB@(a) eB |2402 --- - 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 executes on command-line but not in PERL
What about repairing the table and what does DESC tablename say? - Original Message - From: "Laszlo G. Szijarto" [EMAIL PROTECTED] To: "Ryan Wahle" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 3:20 Subject: Re: SQL executes on command-line but not in PERL Thank you, Ryan, but the PERL code runs perfectly if I try it on any other field. It just doesn't run on THIS field. It's not a SPECIAL field in any way (like PRI Key or Unique or anything like that). When I run it in a compound statement like "update accounts set users=10, loggedin=10 where username='user'" -- the users field updates but the loggedin field does not. Both fields have exactly the same definition int(11). Plus the exact same query updates BOTH from the command line -- though only the one field in PERL. Thank you very much, Laszlo - 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
MyODBC Prompt on connect
I've setup MyODBC (Win98) so I can access a MySQL db from Excel. It works fine, except that everytime I refresh the data, I get the MyODBC prompt, even when I select the option "Don't Prompt on Connect". This is kind of anoying, as I need to execute well over 700 queries. Anybody have any ideas? Thanks, JuanE -- http://FWDer.com -- FWD your way to a fun and SPAM-free mailbox. Unlimited email addresses at your domain yourname.FWDer.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: Re: Replication Bug in 3.23.33
On Thursday 15 February 2001 18:50, Rodolfo Sikora wrote: Does this problem exist in 3.23.32?? Thanks for the bug report. The problem is a bug in the code that skips events when it sees a log entry with the same server id - something that can only happen in the bi-directional replicaiton setup. Fix: --- 1.85/sql/slave.cc Sat Jan 27 15:33:30 2001 +++ edited/slave.ccWed Feb 14 12:35:34 2001 @@ -849,7 +849,8 @@ mi-inc_pos(event_len); flush_master_info(mi); - --slave_skip_counter; + if(slave_skip_counter) + --slave_skip_counter; delete ev; return 0;// avoid infinite update loops } This one does not, but there is a bigger one - restarting the slave does not work. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
Membership will be terminated.
If you wish to continue to receiving our FREE "Stock Pick" newsletter, you must click here: http://www.actionstocks.com, and enter your email address. Otherwise, you will not receive any future updates. Cyber Digital, Inc. - OUTLOOK Overview Cyber Digital, Inc. (OTC BB: CYBD) is a leading manufacturer, software developer and provider of a vast array of high performance Internet products such as routers, gateways, firewalls and servers for the creation of digital broadband and virtual private network (VPN) applications and services. Cyber Digital is also a manufacturer and software developer of advanced digital voice switching infrastructure equipment for private and public switched voice network operators worldwide, especially for developing countries. The Company's mission is to become the leading provider of: i. digital broadband products in the U.S., and ii. digital voice switches to developing countries. Unlike its competitor's products, Cyber Digital's products are neither labor nor capital intensive but are software intensive. This capability in contrast to that of its competitor's makes its products more affordable for both voice and Internet network operators worldwide. All digital voice switching and Internet Protocol (IP) infrastructure products are based on the Company's proprietary operating system software, which provides high performance, reliability and functionality. Recent Developments * During the year 1999, Cyber Digital forged an alliance with ATT to enter the high-speed Internet access and virtual private network (VPN) markets. Since, then as Cyber Digital has proven its Internet products, the main focus is to market its products through distributors in the U.S. * During the year 2000, Cyber Digital developed its Cyber Business Internet Gateway (CBIG) and Cyber Internet Access Network (CIAN) distribution router. * On November 30, 2000, Cyber Digital enters the Nigerian Telecommunications market to provide 10,000 lines of its CDCO and CTSX digital voices switches for public switched network applications by its lowest offer of $26 million to NITEL in partnership with Sidney Telecommunications (Nigeria) Ltd. * On January 16, 2001, Cyber Digital jointly announced with Sidney Telecommunications their expansion into the PABX market. The initial order for 10,000 CSX PABX reflects approximately $4 million in revenues. * On January 23, 2001, Cyber Digital enters the $5 billion Internet firewall appliance market with the introduction of its Cyber Firewall (CFW) series standalone IPSec (Internet Protocol Security) firewall appliances. Outlook During the next twelve months, the Company expects to derive its revenues from two of its core business segments: i. Domestically, the Company will initiate sales of its firewall and virtual private network (VPN) appliances to small and medium size businesses. The Company expects to ship 1000 firewall units generating $12 million in gross revenue with an approximate net income of $2.4 million; and ii. Internationally, the Company currently has a backlog of $30 million to supply to Nigerian telecom market with its digital voice switches. The Company expects to deliver $30 million of these switches resulting in an approximate net income of $7.5 million. In Conclusion We are uniquely positioned to become the leading provider of digital broadband products and digital voice switches because: * We forged an alliance with ATT to enter the high speed Internet access and virtual private network (VPN) markets thus reducing marketing risk. * Customer testimonials confirm our business model is proven thus reducing business risk. * We have fully developed our CBIG gateway, CIAN router, Firewall and Servers thus eliminating development risk. * Simple do-it-yourself installation software for gateway, router and firewall appliances thus eliminating the need for costly specialists. * Cyber Digital products offer cost savings in excess of 50% over competitors' offerings thus reducing sales risk. * Our broadband solution brings the Internet closer to users thus eliminating bottlenecks, reducing network delays and increasing reliability thus reducing any performance risk. Our solution will make the Internet as reliable as telephone networks. * Captive Nigerian telecom market customer with orders backed by irrevocable letters of credit thus reducing profit risk. * Captive Nigerian telecom market customer wants 2 million lines by year 2003 thus reducing market share risk. For further information: Action Stocks, Inc. http://www.actionstocks.com/ 1-800-801-8151 Please note that no further action on your behalf is necessary, as you will not receive future mailings unless you subscribe through the following website: http://www.actionstocks.com, and enter your email address. This announcement does not constitute an offer to sell or the solicitation of an offer to buy any
MyODBC Prompt on connect -- Setup
Everytime I try and connect to MySQL Server I get Host then it's IP address is not allowed to connect to this Server.. Where can I get more info for a newbie to do this.. Cheers Mike /'^'\ ( o o ) ---oOOO--(_)--OOOo-- Mike Benzel --- To err is human, to really foul things up requires a computer. .oooO ( ) Oooo. -\ (( )--- \_)) / (_/ - 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: taxes
"MK" == Mikel King [EMAIL PROTECTED] writes: MK guys I think you are making this a way bigger problem than it MK really is...e-merce crap is generally taxed based on the location MK of the vendor; much the same way in which mail order businesses MK are taxed. You really only have to worry about the state/locality What world (or country) do you live in? When was the last time you ordered something from Dell or Apple on line? What tax rate did you pay? You pay your local rate; not the rate of the location of the store. - 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: MyODBC Prompt on connect -- Setup
At 19:49 15/02/2001 -0700, Mike wrote: Hi! First read the MySQL Manual about the GRANT/REVOKE commands and How the privilege system works on MySQL. Here you will learn how the MySQL grant tables handle the client machine (IP number or DNS or localhost when you are connecting the server locally), the user name, password and database. You should fill the MyODBC DSN setup screen text boxes with the data you have inserted in the grant tables. Regards, Miguel Everytime I try and connect to MySQL Server I get Host then it's IP address is not allowed to connect to this Server.. Where can I get more info for a newbie to do this.. Cheers Mike /'^'\ ( o o ) ---oOOO--(_)--OOOo-- Mike Benzel --- To err is human, to really foul things up requires a computer. .oooO ( ) Oooo. -\ (( )--- \_)) / (_/ - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re:how to know the information about a certern database?
thanks for your help, i have read the vararies through mysqld, there's no the varary defining the max_space of a certern database.i think it's important defect in mysql. i can define how much space will be dispensed to a database,and show how much space have been used to my database user. In sql server i can do it with a stored precedure . yin du
Re: [OT] C program warnning (Just a test i try to understand C in order to build my mysql client program)
Hi. You know, this question is off-topic on the MySQL list. On Wed, Feb 14, 2001 at 09:54:44AM +, [EMAIL PROTECTED] wrote: Hi folks, I am trying to compile a simple program to play with mysql. But i am running into single problems, but i guess easy to solve by too many of the wizards here. I am too paranoic when compiling my programs, so i activate all warnning (at least i try) flags to gnu c compiler. The problem occurs when type conversion: type conversion is automatic when a functions takes a single pointer to const anything, but when there is a double pointer to a const type and i pass double pointer to a non const type i run into problem? Why in the later case conversion is not automatic? the former is. This is a FAQ, see e.g. http://faqs.jmas.co.jp/FAQs/C-faq/faq, section 11.10. For a somewhat better explanation have a look at the C++ FAQ (and also applies to your C program): http://reality.sgi.com/austern_mti/std-c++/faq.html#C1 The summary is that one could bypass the const qualifier c() adds (not in your example, but in general). Here is the simple code (just to test): #include stdio.h int t(const int *i) { printf("%d\n", *i); return 0; } void c(const char **reg) With C++, you can declare it as void c(const char * const* reg) but this does not seem to be allowed in C (I am not used to C anymore, but gcc 2.95.3 complains). { while (*reg) printf("%s\n", *reg++); } int main(int argc, char *argv[]) { int i; char*reg[] = { "Gustavo", "Vieira", "Goncalves", "Coelho", "Rios", NULL}; The other way is to declare "reg" to what is really is, instead: const char *reg[] = ... This will also work with C. The solution of the C-FAQ is dirty (as it opens the hole again because of which the auto cast is not made) and should IMHO be avoided, if possible. Bye, Benjamin. i = 10; (void) t(i); c(reg); return 0; } But when compiling: grios@etosha$ cc -ansi -pedantic -Wconversion -Wall -Werror t.c cc1: warnings being treated as errors t.c: In function `main': t.c:30: warning: passing arg 1 of `c' from incompatible pointer type grios@etosha$ [...] - 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: Reserved words in MySQL update
Hi. On Wed, Feb 14, 2001 at 03:28:23PM -, [EMAIL PROTECTED] wrote: Description: Upgrading from 3.22 to 3.23 with a field having a reserved name ALTER TABLE barfs and doesn't let me do ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL; ALTER TABLE casualties CHANGE `when` cas_when DATE NOT NULL; should work. Note, that backticks will allow to use reserved words or special characters in table, field and other names/labels. Bye, Benjamin. cos of the reserved word "when". How-To-Repeat: Have a field called "when" in 3.22, upgrade to 3.23 Fix: Manually edited the .frm file - didn't feel right Need something to either do it automatically on upgrade, or a standalone utility to modify the mysql files directly. [...] - 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/MyODBC on Netware network
In the last episode (Feb 15), [EMAIL PROTECTED] said: I have a customer that is running on a Netware network. They do have the TCP/IP protocol running on the workstations that are using the Microsoft Client for Netware. I am planning to attach a SCO Openserver 5.0.5 Unix server running MySQL to their network and then use MyODBC to connect a MS Access front-end application to the MySQL database from each workstation. Has anyone done this? Any compatibility problems with Netware? Any patches or considerations to note in design and setup? So you're connecting from Windows boxes to an SCO Unix server; I don't see where Netware would affect this at all. -- Dan Nelson [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: ranking album plays by city, help me beat Oracle
Hi. Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM album_by_city". And, for how much cities does this gets executed? Additionally, I would be interested, if you used the same method with Oracle or another. If so, would you please post it, too. Bye, Benjamin. On Thu, Feb 15, 2001 at 10:47:16AM -0800, [EMAIL PROTECTED] wrote: I'm moving over a music play database from Oracle to MySQL. So far MySQL is faster for all reports except this one where Oracle takes 8 seconds MySQL will take 108 with my current method. [...] I want to report the ranking of an album's plays (against all other albums ) for every city over a time period. National album ranking for "Beatles #1" between 1/1/2001 and 2/14/2001 : New York #1 Chicago #2 Boston #1 Miami #3 Right now the current approach involves looping over every city making 2 queries. First query to get the total # of plays for this album for the time period in that city. Next query to figure out how many other albums for that city for that time have total play sums that are greater, which is the Rank. foreach $cities as $this_city { $this_album_total_plays = "select sum(total_plays) from album_by_city where album_id = $album_id and city = $this_city and date = $StartDate and date = $EndDate"; $rank = "select album_id, sum(total_plays) from album_by_city where city = $this_city and date = $StartDate and date = $EndDate group by album_id having sum(total_plays) $this_album_total_plays"; echo "$this_city $rank"; } Is there a way to do this with fewer queries or perhaps temporary tables for greater speed ? - 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: ranking album plays by city, help me beat Oracle
Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM album_by_city". I haven't used EXPLAIN before. There are indexes on each column. And, for how much cities does this gets executed? There are about 100 cities or regions that are used for ranking. Additionally, I would be interested, if you used the same method with Oracle or another. If so, would you please post it, too. I didn't write the Oracle queries but they used sub selects and all kinds of not available in MySQL optimizations. Thanks for your reply. - Sam. Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM album_by_city". And, for how much cities does this gets executed? Additionally, I would be interested, if you used the same method with Oracle or another. If so, would you please post it, too. Bye, Benjamin. On Thu, Feb 15, 2001 at 10:47:16AM -0800, [EMAIL PROTECTED] wrote: I'm moving over a music play database from Oracle to MySQL. So far MySQL is faster for all reports except this one where Oracle takes 8 seconds MySQL will take 108 with my current method. [...] I want to report the ranking of an album's plays (against all other albums ) for every city over a time period. National album ranking for "Beatles #1" between 1/1/2001 and 2/14/2001 : New York #1 Chicago #2 Boston #1 Miami #3 Right now the current approach involves looping over every city making 2 queries. First query to get the total # of plays for this album for the time period in that city. Next query to figure out how many other albums for that city for that time have total play sums that are greater, which is the Rank. foreach $cities as $this_city { $this_album_total_plays = "select sum(total_plays) from album_by_city where album_id = $album_id and city = $this_city and date = $StartDate and date = $EndDate"; $rank = "select album_id, sum(total_plays) from album_by_city where city = $this_city and date = $StartDate and date = $EndDate group by album_id having sum(total_plays) $this_album_total_plays"; echo "$this_city $rank"; } Is there a way to do this with fewer queries or perhaps temporary tables for greater speed ? - 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 To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!
Re: Embedded MySQL: Opinion Please
Hi. On Thu, Feb 15, 2001 at 02:00:04PM -0500, [EMAIL PROTECTED] wrote: [...] Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? Well, I see no principle problem here. The servers I administer run about 200-400 days without interruption (then the counters get interrupted by hardware/software upgrades ;-) Exceptions are massive internet accesses (so called slashdot effect), but with enough memory and some reasonable limits set, one gets even this stuff stable (not responsive, but stable). What you have to have a look at is anything which is incremental, mainly log files and such stuff. Either disable or rotate those. What I would do is make a test install, then leave it alone for some time and then compare all file sizes and assure that the growing files will be no problem or handle them with cronjobs. For case of emergency (i.e. if some program crashes anyhow), there are several solutions for watchers available, which can restart them (although, as I said, I did not need that stuff until now on x86 boxes). For this environment, is the MySQL / Linux combo a good idea? The question is whether the support for your hardware is stable. If so, I would dare to say that I get the software part stable, too. Or, should I stick with Linux, but seek out an alternate DBMS? MySQL is rock solid if you avoid newly added features and have tested your queries once to be supported. I won't say anything about other DBMSes, because I use none intensively enough to justify a opinion on it. Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? No comment. ;-) Bye, Benjamin. - 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: Good tutorial sites
I have got the same confg and works perfect. WinNT Linux MySQL. Why dont U directly edit the user table of mysql DB. Let Host be '%' and give some username password. mysql insert into mysql.user values('%','username',password('passwd'),'Y','Y','Y'); For test purpose let all priv fields be 'Y'. Then try again it shud work. Cheers! Thiru On Thu, 15 Feb 2001 22:28:31 -0700 "Mike" [EMAIL PROTECTED] wrote: - Hi All - - Where are some good tutorial sites for beginners in the MySQL World. I read - the man pages as sugested but I am stuck on the GRANT HOST issues. I am - connecting my NT MyODBC to my LINUX's MySQL Server. - - I tried - mysql GRANT ... -ON *.* -TO myusername@"%100.100.100.1" -IDENTIFIED BY 'mypassword'; - - - but I get a syntax error. - - Good news is I figured out how to build tablesg - /'^'\ -( o o ) - ---oOOO--(_)--OOOo-- - - Mike Benzel - --- - To err is human, to really foul things up requires a computer. - .oooO - ( ) Oooo. - -\ (( )--- - \_)) / - (_/ - - - - - 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 - - lB I --- T[rXJ peB@(a) eB |2402 --- - 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: Index not used for order by when more than 1 field selected, no where clause
Hi. On Thu, Feb 15, 2001 at 03:53:39PM -0500, [EMAIL PROTECTED] wrote: 15/02/01 15:14, Quentin Bennett, [EMAIL PROTECTED]: [...] Adding the author to the query means that the query now has to go to the data file to get the information, and since there is no restriction on isbn, the entire table is scanned for records to provide the result, which is then sorted. If you had an index of (isbn, author), then the index file would still be used. That's where I don't get it, I don't want to sort by author, only by isbn. Why does mysql needs to resort to a filesort while it has all the ISBN neatly ordered in an index? You have to look at it the other way around: If MySQL uses the index, it has one of two possibilities. First: 1. Read the whole isbn index, and for each row 2. seek the record in the data file and get author from it. This is quite slow because of the random file seeks needed. Second: 1. Read the whole isbn index (since you have no restricting WHERE clause) 2. Read isbn,author from the whole data file in unsorted order (you need isbn, too, else MySQL wouldn't know where the authors belong too) 3. Sort isbn,autor (using sorted isbn, so using selection sort?) This is still slower than MySQL's approch: Third: 1. Read isbn,author from the whole data file in unsorted order 2. Sort isbn,autor as "Second" additionally has to read the index file from disk with no additional benefit. I don't know how to express that elegant, but the problem is that by including author to the queried fields, you have an unsorted column which requires a full sort. "Second" is never the best way. MySQL uses "First" up to some percentage of the amount of records (30% I believe), then uses "Third", because reading the data in file order (unsorted) and sorting is usually faster than random seeks (due to index usage) over that percentage of records. Can someone else tell me and Francois, when the index is used like this, is the result pre-sorted, so the order by is trivial, or is a sort still performed. If the index is used, the data is read in-order and therefore the sort is skipped, AFAIK. Yes, how can we get mySQL to use an index for doing an order by? Must I create an index for each and every possible fields combination? There are several reasonable approaches and which to use depends on your environment and usage. One is almost the one you propose, but not indexes for all combinations, but only for the common ones (you are restricted in the number of indexes). Since the time difference is quite large, your data file seems to be quite big and you may want to consider to split it into two tables, if the scanned fields (like author,isbn) are relatively small compared to the rest of the record. One table would contain all small fields that are needed in the full table scans and the other table the rest. On the other hand, you may question yourself whether these full tables scans are really needed that much (it sounds rather unusual). Bye, Benjamin. - 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: Embedded MySQL: Opinion Please
Benjamin Pflugmann wrote: Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? A RTOS? I would go for QNX, better yet: Neutrino (this is a really weird RTOS) No comment. ;-) Bye, Benjamin. - 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: RedHat 7
"Ashley M. Kirchner" schrieb: Shawn Boedecker wrote: I just wanted to confirm that MySQL is supported on RedHat 7. I saw references to RedHat 5.x and 6.x on the website but no references to RedHat 7. I'm running the latest stable release under RH7 with no problems. (NOTE: I compiled it myself, instead of using RedHat's rpms) same - with RPMs -- IrmundThum +49 179 6998564 +49 6374 992541 - 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