mysql-4.0.5a+linux+FLUSH QUERY CACHE = crash
Hello mysql, after FLUSH QUERY CACHE in error.log 021127 17:25:17 mysqld started 021127 17:25:19 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=115 max_connections=200 threads_connected=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211610 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a7e870 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfd1f2a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80de403 0x80de1ab 0x80dcbd9 0x807dc27 0x807bdb3 0x807cad5 0x8077d4b 0x8077795 0x8077007 0x82657cc 0x829ad6a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Res olved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x66daadf0 is invalid pointer thd-thread_id=431408 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 431408 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 021205 00:49:35 mysqld restarted Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join help.
Is there a good tutorial somewhere on the join command. No matter what I do it just doesn't work. Obviously I'm doing something wrong, but the MySQL manual just doesn't help at all. Try this link. http://www.devshed.com/Server_Side/MySQL/Join/page1.html One of the best books for understanding how joins work is SQL for Dummies It was a combination of the article and the book that helped me understand joins and how to use them with MySQL. (mysql, query) I hope that helps. Scott Pippin [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
Visual studio .Net and mysql++
Hello, I recently upgraded to Visual Studio .NET to realize that I can no longer compile my Visual C++ 6.0 projects that use the MySQL++ classes with Visual C++ .NET. I get an error relating to the iterator and how it is templated (I don't have the exact error with me now). Has anyone else run into this problem? What the problem is , end what the answer? __Noi va asiguram comunicarea!__ http://www.cyber.ro/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WoW!!!! SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
ITD103
ITD104
ITD105
Because of the different lengths, this was a nightmare for order by and so
it led me to my first experiments with case
and I go the following:
select req_number, case
when (length(req_number)=4) then concat('00', req_number)
when (length(req_number)=5) then concat('0', req_number)
when (length(req_number)=6) then req_number
END as sort_req
from req order by sort_req;
Now there might be other ways to handle this and I would love to hear about
them but I thought that this taught me
something about sql that I had not understood until now. Just would like to
give a little back.
Thanks to all.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 port number
On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote: How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike Default is 3306 /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
Re: mysql port number
Show Variables Like 'port'; PB - How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 port number
On Wed, Dec 04, 2002 at 12:04:52PM -0500, Mike At Spy wrote: How can I tell what port number mysql is running on? I need it for a chat program. :) 3306 A google search would have found the answer in no time. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 434,170,735 queries (344/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql port number
mysql show variables; 3306 is the default. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: mysql port number How can I tell what port number mysql is running on? I need it for a chat program. :) Thanks, -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Remote connection is blocked because of many connection errors
On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote: I have a problem here. I cannot connect to a particular server remotely at certain times. I get the error remote connection is blocked because of many connection errors. I can login locally on the box. Ok. To resolve this problem i would run FLUSH HOST and i can connect remotely. But say about every 10 hours i get the same error and i have to run FLUSH HOST. You shoud fix the bug that's causing connection errors. Are you checking for errors in your code? Watching return values on connecting to MySQL? So to further investigate i ran SHOW VARIABLES on the mysql server and the variable max_connections is set to 100 and i ran SHOW STATUS and max_used_connections is 17. So Therefore, the server should allow more connections because it only states that 17 connections is used. Right, but that has nothing to do with connection *errors*. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 434,386,735 queries (344/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: access-mysql
I have used Access to MySQL pro and it worked for a few of my databases. http://www.convert-in.com/acc2sqlp.htm Chris -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug Report: Replication in 4.0.5beta
Michael, I was able to repeat the bug on Linux now. It seems to happen if I set max_binlog_size to 2M in the SLAVE. The relay binlog gets split into several 2 MB pieces. It does not happen always, but I have a randomized test which produces the error in 1 minute. I was not able to repeat the bug when I had not set the max binlog size in the slave, in which case I think it defaults to 1 GB. heikki@hundin:~/mysql-4.0/sql mysqld --defaults-file=/home/heikki/slavemy.cnf 021204 23:55:45 InnoDB: Started mysqld: ready for connections 021204 23:55:45 Slave I/O thread: connected to master 'slaveuser@hundin:3307', replication started in log 'FIRST' at position 4 021204 23:57:42 Error in Log_event::read_log_event(): 'Event too big', data_len =1447971143,event_type=115 021204 23:58:03 Slave SQL thread: I/O error reading event(errno: -1 cur_log-e rror: 12) 021204 23:58:03 Error reading relay log event: Aborting slave SQL thread becaus e of partial event read 021204 23:58:03 Could not parse log event entry, check the master for binlog co rruption This may also be a network problem, or just a bug in the master or slave code. 021204 23:58:03 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'binlog. 002' position 13659061 heikki@hundin:~/data ls -l total 51832 -rw-rw1 heikki users24086965 Dec 4 23:57 binlog.001 -rw-rw1 heikki users28925234 Dec 4 23:58 binlog.002 -rw-rw1 heikki users 26 Dec 4 23:57 binlog.index -rw-rw1 heikki users 5 Dec 4 23:55 hundin.pid drwxr-xr-x2 heikki users 619 Sep 5 20:51 mysql drwxr-xr-x2 heikki users 513 Dec 4 23:57 test heikki@hundin:~/data Also, I observed that if I do a big LOAD DATA INFILE when autocommit=1, then the master splits the master binlog into 2 MB pieces as I have instructed, and since I have set max packet size to 1M in both master and the slave, the slave complains: heikki@hundin:~/mysql-4.0/sql mysqld --defaults-file=/home/heikki/slavemy.cnf 021204 23:48:21 InnoDB: Started mysqld: ready for connections 021204 23:48:21 Slave I/O thread: connected to master 'slaveuser@hundin:3307', replication started in log 'FIRST' at position 4 021204 23:52:08 Error reading packet from server: log event entry exceeded max_ allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021204 23:52:08 Got fatal error 1236: 'log event entry exceeded max_allowed_pac ket; Increase max_allowed_packet on master' from master when reading data from b inary log 021204 23:52:08 Slave I/O thread exiting, read up to log 'binlog.002', position 4 This does NOT happen if I set AUTOCOMMIT=0. I think the above should also be fixed. The slave should read the binlog in smaller pieces, also in the case where AUTOCOMMIT=1. Yet another problem: When LOAD DATA INFILE failed in the master (AUTOCOMMIT=1): mysql load data infile '/home/heikki/rtdump' into table replt3; ERROR 1114: The table 'replt3' is full mysql the slave failed like this: heikki@hundin:~/mysql-4.0/sql mysqld --defaults-file=~/slavemy.cnf 021204 21:45:35 InnoDB: Started mysqld: ready for connections 021204 21:45:35 Slave I/O thread: connected to master 'slaveuser@hundin:3307', replication started in log 'FIRST' at position 4 021204 22:04:22 Slave: Could not open file '/tmp/SQL_LOAD-2-1-4.data', error_co de=2 021204 22:04:22 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'binlog. 026' position 27 I am forwarding these to the replication developer of MySQL AB. I hope he can fix these to 4.0.6. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 12:24 AM Subject: Re: Bug Report: Replication in 4.0.5beta Michael, I have been running tests on 4.0.6 with big insert transactions on Linux. I set max_binlog_size to 2M and max_packet_size to 16M. So far no errors with tables up to 400 MB in size. Looks like MySQL always writes a big transaction as one big block to the current binlog file, and does not cut the binlog file into 2 MB pieces. Thus, it looks like the binlog file rotation cannot be the source of the bug you have observed. If you look in the datadir with ls -l the actual sizes of the master's binlogs, could it be that there really is a 1.3 GB file there? Can you make a script which would always repeat the replication failure? What is the CREATE TABLE statement of your table? What is your my.cnf like? Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL
RE: UPDATE
The problem shows up when receiving the response of the query which tells me that the query was OK but rows affected. Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina -Mensaje original- De: Egor Egorov [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 04 de diciembre de 2002 12:38 Para: [EMAIL PROTECTED] Asunto: re: UPDATE Cesar, Wednesday, December 04, 2002, 2:31:13 AM, you wrote: CA I'm using MyCC to make changes to a remote DB, but I found a problem CA while trying to update a record... does anyone knows what's wrong with CA this? CA UPDATE maraadmins SET adminpassword = password(1234) WHERE adminid = 3 The query seems OK. What problem did you find? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: access-mysql
I can concur - you pay a little, but you get a much better product with this one. Ian Zabel wrote: The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went through my access database and removed certain invalid records (some rows had a screwed up primary key in access that mysql didn't like, and the import would fail), I got a perfect copy of my access database into MySQL. http://www.convert-in.com/acc2sql.htm -Original Message- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LEGAL information about MySQL.
On Sat, 2002-11-30 at 13:42, Pae Choi wrote: I do not know about MySQL marketing strategies. But as far as GPL goes, it even encourge to sell. Does the GPL allow me to sell copies of the program for money? Yes, the GPL allows everyone to do this. The [1]right to sell copies is part of the definition of free software. Except in one special situation, there is no limit on what price you can charge. (The one exception is the required written offer to provide source code that must accompany binary-only release.) [1] http://www.gnu.org/philosophy/selling.html Maybe MySQL.com is concern about own profit so does other commercial vendors. They all use public-domain code in some degree. I do encourge everyone same as GPL to sell your own products without concerning about license violation. Just put the copy of GPL license, as well as source and binary combo. in the corresponding package. (I personally think that the binary will be a necesssary portion when you distribute your own products and provide the URL where they can download the source.) And you can have your own license in your products. You are wrong. I have talked with the people who wrote the GPL many times and if you did the above they (or us if it where MySQL you mistreated) will send you some legal letters. You must provide the source for the combined work when you distribute under the GPL. But you can sell the MySQL code for money under the GPL without our approval. But you may not use our trademark. And you can not stop the customer giving it all away for free (since you had to give him/her source code). I have been in court once discussing this issue and I would like to stay out of those kind of issues for the rest of my life. You have all the rights for your own products same as the GPL packages do for their own. /David MySQL Co-Founder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LEGAL information about MySQL.
On Sat, 2002-11-30 at 10:51, Mark wrote: - Original Message - From: Mark Matthews [EMAIL PROTECTED] To: Pae Choi [EMAIL PROTECTED] Cc: Tonu Samuel [EMAIL PROTECTED]; Darney Lampert [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 5:30 AM Subject: Re: LEGAL information about MySQL. If you are not sure exactly how the GPL works, and you have read the license terms that I've referenced above, and still want to distribute your software that uses and/or links to software licensed under the GPL, I suggest you first seek a lawyer's opinion, and have it explained to you in non-legalese. Are you suggesting that every program that uses MySQL has to be GPL?? I doubt that. If so, you are effectively saying, for instance, that no program written in Perl could ever be non-GPL (as all Perl scripts use/link to GPL Perl). And this is, of course, not the case. There are many commercial products out there, like Perl debuggers, for example, that are definitely NOT licenced GPL, yet still use/link to Perl. With MySQL 4.0 that has a GPL client every program that is distributed linked with MySQL needs to be under a GPL compatible license. We will extend the compatibility to cover a given set of OSI (opensource.org) approved licenses. As for Perl is has two licenses one which is less restrictive than the GPL. I read the MySQL Licensing Policy, and, to me, it said: If your application is NOT licensed under GPL or compatible OSI license approved by MySQL AB and you intend to distribute MySQL software (be that internally or externally), you must first obtain a commercial license to the MySQL software in question. The licence talks about DISTRIBUTING the MySQL software itself; or, as it says, More specifically: a) If you include the MySQL server in your non Open Source application, you need a commercial licence for the MySQL server, b) If you include one of the MySQL drivers in your non Open Source application (so that your application can run with MySQL), you need a commercial licence for the driver(s) in question. The MySQL drivers currently include an ODBC driver, a JDBC driver and the C language library. Except, of course, that most people do NOT distribute MySQL software, or drivers with their own programs. Besides, if I write a program in Perl, which uses MySQL, it is still Perl that distributes drivers and such. My OWN program does no such thing. My program just says: Use DBI;. Sorry, but MySQL is a part of the combined work. So if you distribute a Perl program that is indirectly linked with MySQL you need to distribute the source of you program. /David MySQL Co-Founder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] LEGAL information about MySQL.
On Mon, 2002-12-02 at 14:45, Darney Lampert wrote: Sorry continue this subject ... I´m the author original question, LEGAL information about MySQL. But I Think that my question is simple and the other answers do not make sense to me. I never said that I change original MySQL source code, and I just want know if I can use MySQL database on my comercial application without pay for it. My application ONLY access MySQL. Our basic answer is No. If you ship MySQL (server or client) with a commercial (non opensource) application you should pay. I develop a program with Delphi with access MySQL database. I'll sell my program, and ONLY give a copy of MySQL to the users, or indicate the place to download to them. Does my client need to pay a license to MySQL AB? Not, it actually you who need to pay in this case. Or you can distribute with source code (just like we do!). Other case: I develop a web-site with PHP wich access MySQL database to a client who paid for it. The users do not need to install MySQL. Does anybody need to pay something? Who? (Remember that my Web Server just run PHP and MySQL, wich are free. My site (wich is paid) uses the services provided by the web-server) In this case there is not distribution so no fee is needed. We would like to be paid in this case also but there is legal requirement for a license if you do not distribute. But we would like every one who uses MySQL for commercial services to pay for support! In this case, does my client, the web-server or I need to pay a license to MySQL AB? No, as explained above. The GPL kicks in when you *distribute* and then you can either distribute all (including your) source code or buy a commercial license from us. Please, just wellfounded answers, not personal opinions. I am the licensing guru for MySQL AB and one of the founders. /David MySQL Co-Founder Thanks At 15:51 30/11/2002 +0100, you wrote: Hello. I do not intent to follow-up on the issue, as you are either trolling or clueless (and not willing to inform yourself) or both. On Sat 2002-11-30 at 08:30:52 -0500, [EMAIL PROTECTED] wrote: Seems like all against I see are coming from MySQL team. But I want to prevent a misconception: I am in no way affiliated to MySQL AB than being an user of their software. Bye, Benjamin. Darney Lampert Sky Informática Ltda - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about MySQL replication and OPTIMIZE TABLE
Hello, I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM Indices. I would like to set replication (one master and one slave). My question is: When I OPTIMIZE TABLE table1, ... on the master will the slave be updated or if I want to optimize the same tables on the slave I need to explicitly run OPTIMIZE TABLE on the slave side ? Thanks a lot for your help, Mariella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] LEGAL information about MySQL.
Look! I already unsubscribed this. Do you understand what that mean? I have no interest to dealing with MySQL and have no time for this. You must understand that this thread was started from someone who were interested to sell his/her product that utilize MySQL. And I was trying to help both sides. One who is creating an innovative products as well as MySQL. Do you know how both sides get benefits? Actually, MySQL should appreciate them. Those folks actually help your business by moving your products. Also, you MUST understand that if one product provides the persistence service that only comes with JDBC/JDO/or similar functionality. So the product can adopt any back-end DBMS, for example, and leaving the choice of DBMS to thier customers. They will more than likely go with the *reliable* DBMS. In case the customers somehow select MySQL for thier DBMS solution, to wit, if they download and use it. You are out of luck! 1) The Product innovation group did not distributed; Their customers download it. 2) In their own license, they can declare own rights. Still want to chase them, it's your choice(I don't know what you are going to after for, but it will be your choice as well to spend the time and your own expenses.) Last, by no means least, put me out of this. I am no longer interesting to waste my time with MySQL. I already seen enough and got sense of attitudes from MySQL. Pae P.S.: If your intention was for commercializtion from the beginning, you should started with .com, not .org -- I can see your sly marketing strategy. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 setup question
On Thu, 2002-12-05 at 14:42, Beauford.2003 wrote: Adolfo, Thanks for the info, but can you elaborate on it, 'cause basically I am just not getting the concept. No way no how can I get these joins to work. mysql describe songs; (this contains an ID field and the title of the song and the artist.) ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | ids| int(11) | | PRI | 0 | | | title | varchar(55) | YES | | NULL| | | artist | varchar(30) | YES | | NULL| | ++-+--+-+-+---+ 3 rows in set (0.00 sec) mysql describe album; (this contains an ID field and the name of the album the above songs came from.) +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | ida | int(11) | | PRI | 0 | | | name | varchar(35) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) mysql describe reference; (this contains the ID's that corrspond to the above two tables.) +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | ida | int(11) | | PRI | 0 | | | ids | int(11) | | PRI | 0 | | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) This table is in this format: The left column corresponds to the ID of the ablum and the right field correspond to the ID of the song. From the example below, you can see that song #1 appears on Albums 2, 3, 6, and 16. SongAlbum 12 13 16 115 27 221 223 So with all this information, how would I perform a select that would show the all the albums a particular song were on. (from the example above what would I need to do to show the album name and song title for song ID # 1 above). Try Select name from album join reference join songs where album.ida=reference.ida and reference.ids=songs.ids and songs.title='sometitle'; John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Graphical data visualization for RDBMS/SQL schema?
I'm looking for something that will take mySQL databases and show me graphically how the tables all relate to each other. At the very least, show me boxes with the schema in each one and allow me to draw lines as I see fit (or use the foreign keys of InnoDB tables). This could then be printed to paste on a wall or something. MS Access has something like this I think, and there's probably a way to connect to mySQL via ODBC mebbe? Does Visio? Or Diag (on linux)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB shared lock with JOINs
Hallo. I have this query: SELECT table1.id FROM table1 LEFT JOIN table2 USING(id) WHERE table1.a=1 and table2.b=1 table1 is MyISAM and table2 is InnoDB. I want a shared mode lock on the table2. Is it possible, or i should split this query? -- Have a nice day. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow performance using 3.23 on RH 8.0
On Wed, Dec 04, 2002 at 05:18:26PM -0500, Adam Nelson wrote: Don't let this list fool you. SQL Server is a very good product. It is far superior to Mysql in every way except cost and the fact that it doesn't run on unix. This smells a lot like flaim bait on a MySQL list... Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 440,492,778 queries (343/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Possible date bug
John,
Am I mistaken or does 2002-02-31 translate into February 31, 2002? If it
does ...
Your observation is interesting.
The MySQL manual says the query should set all zeroes if the date value is
illegal. This does happen if you enter 32 days for a month, for example.
Furthermore, I got two different unix_timestamp values in separate
experiments when I queried the 31st-of-February date:
mysql select td, unix_timestamp(td), from_unixtime(unix_timestamp(td)) from
mine;
+-++
---+
| td | unix_timestamp(td) |
from_unixtime(unix_timestamp(td)) |
+-++
---+
| 2002-02-31 00:00:00 | 1014962400 | 2002-03-01 00:00:00
|
| 2002-11-31 00:00:00 | 1038722400 | 2002-12-01 00:00:00
|
+-++
---+
2 rows in set (0.00 sec)
** Note it says March 1st in the third column.
Then I decided to add a few more illegal values and do another from_unixtime
conversion...
mysql insert into mine values (2002-02-29);
Query OK, 1 row affected (0.01 sec)
mysql insert into mine values (2002-02-30);
Query OK, 1 row affected (0.00 sec)
mysql select td, unix_timestamp(td), from_unixtime(unix_timestamp(td)) from
mine;
+-++
---+
| td | unix_timestamp(td) |
from_unixtime(unix_timestamp(td)) |
+-++
---+
| 2002-02-31 00:00:00 | 1015135200 | 2002-03-03 00:00:00
|
| 2002-11-31 00:00:00 | 1038722400 | 2002-12-01 00:00:00
|
| 2002-02-29 00:00:00 | 1014962400 | 2002-03-01 00:00:00
|
| 2002-02-30 00:00:00 | 1015048800 | 2002-03-02 00:00:00
|
+-++
---+
4 rows in set (0.00 sec)
** Note that the unix_timestamp is different this time for the Feb 31st
date and that it says March 3rd in the third column.
I am running version 3.23.51 on Red Hat Linux release 6.0 (Hedwig) Kernel
2.2.5-15 on an i486.
I have a scheduling application that uses unix_timestamps throughout (stored
as unsigned INTs instead of DATETIMEs), and I haven't noticed any such
problem with illegal date values.
There must be an explanation but scouring the books and manual I could not
find one.
Bruce MacDonald
Minnesota Public Radio
- Original Message -
From: John Griffin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 3:35 PM
Subject: Possible date bug
Hi All,
I ran the following commands:
DROP TABLE IF EXISTS test_date;
CREATE TABLE test_date (test_date datetime);
INSERT INTO test_date (test_date) VALUES ('2002-02-31');
SELECT * FROM test_date;
I got the following results:
mysql DROP TABLE IF EXISTS test_date;
Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE test_date (test_date datetime);
Query OK, 0 rows affected (0.03 sec)
mysql INSERT INTO test_date (test_date) VALUES ('2002-02-31');
Query OK, 1 row affected (0.01 sec)
mysql SELECT * FROM test_date;
+-+
| test_date |
+-+
| 2002-02-31 00:00:00 |
+-+
1 row in set (0.00 sec)
mysql
Am I mistaken or does 2002-02-31 translate into February 31, 2002? If it
does ...
I am running MySQL 3.23.41 on Windows 2000.
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Slow performance using 3.23 on RH 8.0
From: DELETED TO PROTECT THE GUILTY [Four original lines and SEVERAL HUNDRED quoted lines deleted] PLEASE folk, trim up your quotes a bit! Nothing spells newbie so much as mindlessly including everything anyone has ever written on a topic. And when two of you go at it with each other, it's essentially unreadable to those who get the list in digest format. The polite, thoughtful thing to do is to take a moment and pull out just those lines that you are addressing. Your few moments of thoughtfulness saves several thousand people several thousand moments of scrolling through the mess you make when you mindlessly include the entire thread in your reply. Thanks in advance for your thoughtfulness! SQL SQL SQL QSL SOL -- : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WoW!!!! SQL is something!
Sorry,
should be the lpad function:
http://www.mysql.com/doc/en/String_functions.html
LPAD(str,len,padstr)
Returns the string str, left-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql SELECT LPAD('hi',4,'??');
- '??hi'
-Original Message-
From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
Sent: December 04, 2002 18:26
To: Mysql_List (E-mail)
Subject: WoW SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
ITD103
ITD104
ITD105
Because of the different lengths, this was a nightmare for
order by and so
it led me to my first experiments with case
and I go the following:
select req_number, case
when (length(req_number)=4) then concat('00', req_number)
when (length(req_number)=5) then concat('0', req_number)
when (length(req_number)=6) then req_number
END as sort_req
from req order by sort_req;
Now there might be other ways to handle this and I would love
to hear about
them but I thought that this taught me
something about sql that I had not understood until now. Just
would like to
give a little back.
Thanks to all.
---
DISCLAIMER:
This message, including attachments, is confidential and may be
privileged. If you are not an intended recipient, please notify the
sender then delete and destroy the original message and all copies. You
should not copy, forward and/or disclose this message, in whole or in
part, without permission of the sender.
---
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: WoW!!!! SQL is something!
What you want is the rpad function:
http://www.mysql.com/doc/en/String_functions.html
RPAD(str,len,padstr)
Returns the string str, right-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql SELECT RPAD('hi',5,'?');
- 'hi???'
-Original Message-
From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
Sent: December 04, 2002 18:26
To: Mysql_List (E-mail)
Subject: WoW SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
ITD103
ITD104
ITD105
Because of the different lengths, this was a nightmare for
order by and so
it led me to my first experiments with case
and I go the following:
select req_number, case
when (length(req_number)=4) then concat('00', req_number)
when (length(req_number)=5) then concat('0', req_number)
when (length(req_number)=6) then req_number
END as sort_req
from req order by sort_req;
Now there might be other ways to handle this and I would love
to hear about
them but I thought that this taught me
something about sql that I had not understood until now. Just
would like to
give a little back.
Thanks to all.
---
DISCLAIMER:
This message, including attachments, is confidential and may be
privileged. If you are not an intended recipient, please notify the
sender then delete and destroy the original message and all copies. You
should not copy, forward and/or disclose this message, in whole or in
part, without permission of the sender.
---
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 port number
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 4 Dec 2002, R. Hannes Niedner wrote: On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote: How can I tell what port number mysql is running on? I need it for a chat program. :) Default is 3306 And with -P=123 or --port=123 for mysqld you can specify any server port you'd like your server to run on. Regards, Iikka Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE97xG8CVGYZ+r4ZncRAkKuAJ9BlXVwcii5C/zep+g3kh3GTuu/3wCgl/H8 VCssqRZS8ggqiFdtqBI50is= =kbxs -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error compiling 3.23.53
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 4 Dec 2002, Philip Molter wrote: Compiling on Solaris 8 x86 - mysql 3.23.53 - gcc version 2.95.2 19991024 (release) CC=gcc CFLAGS=-O3 -fno-omit-frame-pointer CXX=gcc CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql-3.23.53 --with-extra-charsets=complex --enable-safe-client --enable-local-infile --enable-assembler --with-innodb --without-readline I get the error: Making all in strings make[2]: Entering directory `/tmp/mysql-3.23.53/strings' gcc -c -o strings-x86.o strings-x86.s Assembler: strings-x86.s, line 1 : Illegal mnemonic [SNIP] Please do not use the --enable-assembler switch for Solaris/x86 - this assembler code os for Solaris/sparc only... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE97wF+SVDhKrJykfIRAhKQAJwMz8nKHF5smj9CDni8uXfF2XUVagCggmHp tgr5zbruST4LEH7T+GRDnnU= =eazQ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Aggregating function which returns more than one row
No. It is not what I want. This is a normal aggregation. The sum function will be called once for each group (SalespersonNm) and it will return one row. What I have asked is : if I have 10 rows, can I return 12? It's rude, but that's the idea. Thanks, Felix DL Neil wrote: Felix, Is is it possible to write an aggregation function which returns more than one row? Yes - if I have understood your requirement correctly. It would have been helpful if you had given some idea of the application/what you want to achieve. Here's an example from out of my imagination: if there is a table holding details of all of the sales (invoiced lines) for a particular month's trading, and if each is recorded/credited against a particular salesperson. Let's say there are one million rows in the table, but only ten sales staff. You can ask MySQL to return the sum of (aggregate) all sales attributed to each salesperson, and to count the number of sales/lines for each person: SELECT SalespersonNm-or-ID, COUNT( * ) AS NumberOfSales, SUM( ExtendedValue) AS TValueOfSales FROM =tbl= WHERE =this-month= GROUP BY SalespersonNm This will analyse the million rows but only output ten lines of results/salespersons' names (and the NumberOfSales column's entries will add up to one million/the number of rows in the table). What you wanted? =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Aggregating function which returns more than one row
The idea is simple: I want to implement some temporal computation on timeseries like normalization and interpolation to smooth the data and fill the missing values. So, for example if have a table like that: starttime,endtime,counter 12:00,12:30,34 13:00,14:00,25 you see that for 12:00 the measurement was for 30 minutes and a segement is missing (12:30-13:00). What I want is to write some aggregation functions the will do this kind of computations like the following: select nisum(starttime,endtime,counter,interval,trashold) from my_table where That's it, Felix --- sql, query Victor Pendleton wrote: Felix, Can you please give an example of what you are attempting to do? -Original Message- From: Felix LUNGU [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:22 AM To: [EMAIL PROTECTED] Subject: Aggregating function which returns more than one row Is is it possible to write an aggregation function which returns more than one row? Thanks, felix Mysql sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can 4.0.x be used to replace 3.23.xx _now_?
i read in several places (like in recent osnews.com newspiece and some other prior postings to this list) that mysql 4.0.x is supposed to be stable now. but the front page of mysql.com still lists 4.0.5 under development. so does the mysql developers suggest that mysql is still unstable or non-production yet? i'd love to use some 4.x features, but i am reluctant of migrating my max-3.23.53a installations over to max-4.0.5 because of this. is migration recommended/acceptable now? (yes, i know the if it ain't broken, don't fix it saying. but i could use some of the new features of 4.x...) -- dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question about mysql_real_escape_string()
On Wednesday 04 December 2002 22:35, Stefan Hinz, iConnect \(Berlin\) wrote: Hello Stefan, The communication buffer (between client and server) is set to 1 MByte by default. You can change this either by starting the server with a different option or by setting the appropriate variable in the my.cnf/my.ini file. I prefer the latter: mysql_real_escape_string ist a client_side function, so in this case there is no communication between client and server (the charset information is stored on the client side too (in mysql-charset)). Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Serwer Hardware p4 or pIII ?
Its more to do with the amount of memmory than its speed. As MySQL will try and load as much data (tables) into memmory as posible the more the better. The next thing is disc speed. Simon -Original Message- From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 15:46 To: Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: --- Simon Green [EMAIL PROTECTED] wrote: MySQL uses memory and HDD the most and so processor speed is not so important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. If your bottleneck is memory speed, you will see 100% CPU usage even if the CPU actually spend 99% of its time idle, waiting for data to come in. I'm not too up to date on the latest RAM technology, but I hear there's several types of DDR, the most expensive one being significantly faster. Or is it? Anyone care to share some insight on this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Select Problem
Hi Just try this select distinct(a.id) from test a , test b where a.code = 23 and b.code = 45 and a.id = b.id Regards, -Arul - Original Message - From: Robert Gehrig [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 10:52 PM Subject: Select Problem Hi all I have a detail table that has multiple records associated with an ID number Both fields are integers E.G. Id Code 4 23 4 27 34 23 34 45 34 28 What I need to find is the Id where the code is 23 and 45 for the same Id (the result in this case would be 34) How do I do this with a SQL query Thanks Robert Gehrig Webmaster at www.gdbarri.com e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [OT] LEGAL information about MySQL.
-Original Message- From: David Axmark [mailto:[EMAIL PROTECTED]] In this case there is not distribution so no fee is needed. We would like to be paid in this case also but there is legal requirement for a license if you do not distribute. Missing 'no'? - rick cronan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow performance using 3.23 on RH 8.0
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ledet, Mike wrote: | I'm running Mysql 3.23.52 on a Redhat 8.0 installation booting to Gnome. | The machine is a dual AMD 1800, 1 gig of ram, one Ultra ATA IDE drive, and 2 | 18 gig scsi 10,000 RPM drives on a RAID controller running Raid 0. | | I've got everything except /db on the IDE drive, /db is the only thing on | the raid array. | | I've got a couple of smallish tables and one larger table with about 7 gigs | of data. The larger table is a fixed row format table with each row being | 462 bytes wide. I have a primary auto increment int column and a unique | index on a varchar 60. Pack keys is off, delayed key writes on. | I'm afraid, you table row isn't fixed-length row, as far as you'll be using varchar your rows will not be considered to be a fixed length rows. try to change it to char(60) (BINARY if you don't care for U/L case) this may help. it will be more helpful if you provide table structure for us... I have table with approx 6M rows with fixed length, used for site statistics with approx. ++250k rows/day. There are extensive writes (UPDATE DELAYED) and minor reads and I'm not having problems... As for my config its 2x 1GHz PIII + 1GB RAM + 2 channel onboard SCSI on 64-bit PCI WITHOUT RAID, 2x 16GB 10,000 RPM SCSI-HDD one disc is used for db data only. As for RAID 0 it is not very good idea to have databases stored in that manner (safety - if one disk fails, you will lost everything ...). | With this kind of hardware I was expecting pretty good performance, but I | haven't seen it yet. I finally decided something was wrong when I had to | run an alter table on the 7 gig table, adding 3 columns, a varchar 12, a | varchar 50, and a datetime columm and it took over 10 HOURS to complete. | As I wrote, to keep table fixed-length you must not use varchar. As for datetime I'm using UNSIGNED int(11) and unix_timestamp to store date and time. | That seems way too slow to me... | | I've included relevant portions (the uncommented portions) from my.cnf, the | OS installation was fairly vanilla, using defaults for just about | everything. The file system is ext3. ext-3 is so-called journaling file system. it has small performance slow-down (no flame, please ;-)) | | Any suggestions or things I haven't included that you need? Sorry if I'm | doing something really stupid here... relatively new to Linux after a lot of | years of windoze. everyone had been newbie. Keep trying :) TIPS: - check settings for your RAID controller - are you using native driver for SCSI/RAID controller ? # of TCQ (tagged commands queuing) elevator sorting - should be ON - do you really need ext3? - rethink structure of your table (R. M. Ryordan Designing relational database, ISBN:073560634X - it is MS oriented, but theoretical parts are very good and helpful for any platform) | | Thanks in advance | | Mike - -- Mirek Novak Anima Publishers, s.r.o. Prilucka 360, Zlin 760 01 Czech Republic tel/fax: 067/721 91 32 jabber:[EMAIL PROTECTED] ICQ:119499448 GSM:+420603807837 AUTO.CZ http://www.auto.cz NEWS.AUTO.CZ http://news.auto.cz FORMULE1.CZ http://www.formule1.cz -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj3vJNoACgkQz+tW1WzgrpSjSACcD1R30nPOyUUgjmg//61aQaBX ltsAmwTEHf+A3eZo5kNKnF6F+qJs8Keb =53Lx -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Server Hardware p4 or pIII ?
Thanks for advice, --- Adam Nelson [EMAIL PROTECTED] wrote: I've posted my comments before but the important thing is that P4 is largely unnecessary as it doesn't have instructions that apply to server applications (mostly). thats mainly what I was asking for. I'll go with pIII than. So, PIII (dual is quite helpful) the fastest you can get without paying a premium 1 GB ram dual scsi drives (raid 1) This is the simplest scenario and will handle tons of queries (100/sec) with drive failover (very very nice) very fast and it can fit in 1U. I'm aiming rather at 500 queries a sec. Will have 4 cheetah SCSI drives. Two pairs of RAID1 and databases will be spread on them. We already run similiar setup and its avarage load is about 250q/s. If you have less money, I would drop the second proc, then move to lower speed proc, then less memory. -Original Message- From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:46 AM To: Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: --- Simon Green [EMAIL PROTECTED] wrote: MySQL uses memory and HDD the most and so processor speed is not so important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. If your bottleneck is memory speed, you will see 100% CPU usage even if the CPU actually spend 99% of its time idle, waiting for data to come in. I'm not too up to date on the latest RAM technology, but I hear there's several types of DDR, the most expensive one being significantly faster. Or is it? Anyone care to share some insight on this? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql-4.0.5a+linux+FLUSH QUERY CACHE = crash
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 5 Dec 2002, Andrew Sitnikov wrote: after FLUSH QUERY CACHE key_buffer_size=402649088 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=115 max_connections=200 threads_connected=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211610 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a7e870 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfd1f2a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80de403 0x80de1ab 0x80dcbd9 0x807dc27 0x807bdb3 0x807cad5 0x8077d4b 0x8077795 0x8077007 0x82657cc 0x829ad6a New value of fp=(nil) failed sanity check, terminating stack trace! Unfortunately this info is not very helpful - we would need some more background info and a repeatable test case to be able to resolve this :( The command above is part or our test suites and passed fine during the build phase. Can you reliably reproduce this? If yes, please describe in more detail, how. Thanks! LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE97yxMSVDhKrJykfIRAmGcAJ4wrh3hm5m1KnUcllsyfLuKEGofdwCfcX2K UaBYB6ofrEzb7h9p4W3sCHY= =cQlM -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: UPDATE
Cesar, Wednesday, December 04, 2002, 2:31:13 AM, you wrote: CA I'm using MyCC to make changes to a remote DB, but I found a problem CA while trying to update a record... does anyone knows what's wrong with CA this? CA UPDATE maraadmins SET adminpassword = password(1234) WHERE adminid = 3 The query seems OK. What problem did you find? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't Figure out Username and Password
Hello list. I'm new here. I programmed dBase several lifetimes ago and now fumble with Access when I have to. I've just purchased a license to a vBulletin message board, which employs PHP and MySQL, so it's time I FINALLY get around to learning these two. I am at my first hurdle. I uploaded all the files for vBulletin and it appears to be working correctly, but I can't get past the first setup screen because I am not supplying it with the correct username and password. My web host, who does NOT know PHP or MySQL, believes that the username/password I use for my domain should work. It doesn't. I have PHPMyadmin installed on the server. I went into it, went to the User table and entered name and pw into the default column. Still no go. Now I'm thinking that the installed MySQL either has no name/pw set up or some others I don't know about. Does anyone have any suggestions? Anybody know of good documentation for PHPMyAdmin that does not assume a lot of prior knowledge of MySQL? I've searched online and everything I found assumes a lot of terminology I don't know yet. I'm hoping I don't have to read the whole manual before I can get past that first screen. Linda Carter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trigger
Neal: What you are really asking is: Does MySQL support stored procedures? The answer is ... at this point ... no. Implementation of stored procedures is on the 'to-do' list, but it will be awhile before you see it. There are some work-arounds ... do a search of the archive for this list, or perhaps others reading your post can offer some pointers. In my case, I run a cronjob that calls a shell script which runs an SQL query that does cleanup and backup work. Gerald Jensen - Original Message - From: neal [EMAIL PROTECTED] To: mySQL [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:23 PM Subject: Trigger Is there an equivilent to a trigger in mySQL? I need to build a cache mechanism for a website and I thought I'd use MySQL for persistance. The problem is that I need it to schedule a cleanup task every 24 hours - to remove old cache records. MS SQL Server provides a trigger for scheduling such tasks - I am looking for the functional analog on MySQL. Thanks. Neal Cabage - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
RES: RES: RES: SQL Select Idea
Hi Michael, The ten last dates appear as a default result of a Archives page. When I enter for the first time in the page, it give me the last ten Files that was uploaded. In the same page, I can ORDER BY the ten last dates results by COD, DATE, NAME or FILE. So, when I click in some os then, I need to ORDER the TEN DATES, not the entire table and give ten results, did you get it? Any idea? Regards, Felipe -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de dezembro de 2002 17:33 Para: [EMAIL PROTECTED] Assunto: Re: RES: RES: SQL Select Idea On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote: Well, the SQL Query you requested is exatcly the one I'm asking! :-) No; I want to know what you intended for those 10 dates to do. The LIMIT query worked, as posted by someone else, which you quoted. What do you then intend to do with that data? Since I have a link in the header of the tabel that make the ORDER BY work, when I select de COD after the result above, I should get: [ you didn't give the EXACT SQL QUERY that you're typing in; please give it ] Again, you didn't quote the when I select the COD after ... -- what is that query? And how do you expect it to behave. I'm assuming that you're forgetting a step, or misunderstanding a step involved. Are you doing anything with that data you're selecting, or just selecting it and leaving it? You might be wanting to select it into a new table or something; look up INSERT INTO ... SELECT FROM This still applies. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB: a detailed bug report
On Wed, 4 Dec 2002, Heikki Tuuri wrote:
what MySQL version you are running? On what OS?
Version 3.23.53-max-nt-log on Windows Professional 2000
What does SHOW CREATE TABLE tabdocumentoconsultado; print?
I created again all the tables of the database called bdatena.
Now that the table is no more corrupt, it prints
Create Table: CREATE TABLE `tabdocumentoconsultado` (
`IdDocConsultado` int(11) NOT NULL auto_increment,
`IdAprendiz` varchar(15) NOT NULL default '',
`codcurso` int(11) NOT NULL default '0',
`IdP` int(11) NOT NULL default '0',
`DiaHoraInicial` datetime NOT NULL default '-00-00 00:00:00',
`Tipo` enum('Cur','Top','UE') NOT NULL default 'Top',
`DiaHoraFinal` datetime default NULL,
`EmPausa` enum('S','N') NOT NULL default 'N',
PRIMARY KEY (`IdDocConsultado`),
UNIQUE KEY `umDoc` (`IdAprendiz`,`codcurso`,`IdP`,
`DiaHoraInicial`,`Tipo`,`DiaHoraFinal`,`EmPausa`),
KEY `DoConsInd` (`IdAprendiz`,`codcurso`),
FOREIGN KEY (`IdAprendiz`, `codcurso`)
REFERENCES `bdatena.cursa` (`idaluno`, `codcurso`)
) TYPE=InnoDB
Have you used an InnoDB version = 3.23.43 and stored characters with code
127 in the table? E.g., accent characters? The ordering of such characters
in the latin1 charset changed in 3.23.44.
In other tables, I stored accent characters.
In tabdocumentoconsultado (in English, something like
ConsultedDocumentTable), I don't store characters with code 127.
How do I discover the InnoDB version? I don't know its version.
What kind of operations you did to the table? INSERT, UPDATE, DELETE?
INSERT and UPDATE.
Can you repeat the corruption starting from a fresh table?
The corruption didn't happen again with a fresh table.
You can repair the corruption by dump + DROP + CREATE + import of the table.
Thanks for the hint!
Regards,
Willie D. Leiva
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Trigger
Neal, I need to build a cache mechanism for a website and I thought I'd use MySQL for persistance. The problem is that I need it to schedule a cleanup task every 24 hours - to remove old cache records. MS SQL Server provides a trigger for scheduling such tasks - I am looking for the functional analog on MySQL. Use a CRON job on the server to have mysql execute SQL statements in batch mode periodically. Write a shell script to invoke mysql in batch mode and take its input from a file. Here's one example: #! /bin/sh /usr/bin/mysql -h localhost -u username -ppassword database-name /path/to/commands.sql where the file 'commands.sql' contains the SQL statements to clean up the cache. Then add an entry to your CRONTAB. The following example would run the shell script at 2am each day: 0 2 * * * /path/to/shellscript See the CRONTAB manual on your system for details. If using Windows to run your MySQL server, use the cmd interpreter, the 'at' command, and the Schedule service. There are versions of CRON available for Windows, too. Bruce MacDonald Minnesota Public Radio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] LEGAL information about MySQL.
- Original Message - From: David Axmark [EMAIL PROTECTED] To: Darney Lampert [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:55 AM Subject: Re: [OT] LEGAL information about MySQL. I am the licensing guru for MySQL AB and one of the founders. With regard to MySQL software falling under the GPL licence, I was too focussed on studying the GPL licence itself, and missed this very clear section of the MySQL AB licence: As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL or other OSI approved license or not. In all fairness to MySQL AB, that wording is clear enough, I would say. :) My eye also caught the following blurb: We also believe that if you have strong reasons NOT to go GPL, you also have the monetary means to purchase commercial licences. Conversely, I would say: I also believe that if you have strong reasons NOT to go COMMERCIAL, you also do not have the monetary means to purchase commercial licences. In other words: relax. :) Worried people who are asking questions here to the effect of their program using MySQL requires a commercial licence, are likely people who cannot afford a commercial licence anyway. - 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
Re: access-mysql
DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Graphical data visualization for RDBMS/SQL schema?
Datanamic is a very useful tool. http://www.datanamic.com -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 8:58 PM To: [EMAIL PROTECTED] Subject: Graphical data visualization for RDBMS/SQL schema? I'm looking for something that will take mySQL databases and show me graphically how the tables all relate to each other. At the very least, show me boxes with the schema in each one and allow me to draw lines as I see fit (or use the foreign keys of InnoDB tables). This could then be printed to paste on a wall or something. MS Access has something like this I think, and there's probably a way to connect to mySQL via ODBC mebbe? Does Visio? Or Diag (on linux)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: take one database offline
On Wed, 2002-12-04 at 22:32, Richardson, David E (MVC Corporation) wrote: On a single Linux box w/mysql 3.23.52 I have mysqld running and there are about 20 databases live in the environment. I want to take one of the databases offline but leave mysqld running with the other db's - without interrupting service. I want mysqld to gracefully refresh itself that the database is offline and not require a restart. I have the luxury of time if that's helpful to the solution. How do I disable a database in a running server and leave the rest of the db's in production? A nasty hack for unix-flavoured os is: * place a write lock on all tables in the database you want to disable (eg. lock table one write, two write, three write, ... ) * flush tables * as root, chdir to the mysql datadir (eg. cd /var/lib/mysql) * create a database to hide your database in (eg. mkdir __safe__) * move your database (eg. mv actual_database __safe__) * in mysql, unlock the tables (eg. unlock tables ) Moving a database into a sub-directory makes the database inaccessible. Locking the tables makes you wait for all users to stop using the tables, and prevents anyone else opening one. flushing the tables releases any filehandles MySQL has cached on any of the affected tables. == Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: access-mysql
thnx to all! am checking this links out.. looks great! :) -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de Dezembro de 2002 12:30 To: MySQL List Subject: Re: access-mysql DBTools works great on this matter. You find it at http://www.dbtools.com.br/EN and is totally free. []s Crercio - Original Message - From: Sandeep Murphy [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 12:39 PM Subject: access-mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table copy problem
Hello! I want to copy one table's structure to another (non existing) table, but i didn't find any command or example to do that. Exactly, the situation is the following: A dynamic database structure has tables. We want to copy any of tha tables (while we don't know that table's structure) to another template table, which isn't exist. So, that looks like on MsSQL: SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null and the SQL server creates a [temptablename] table with no records (or we hope that ;) ) But we can't do this on MySQL server, 'cause MySQL isn't know the SELECT...INTO syntax, but in the INSERT...INTO syntax, we must count the columns, which we wnat to create. (it's not good for me...) Can somebody solve this problem? Or it's willn't work for the next version? (uhh-uhh, thats the worst...) Thanx, Barnabas Olah Cegedim Hungary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install PHP with MySQL
I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability of the Linux VM on s390 platform. The application url is http://epayroll.sourceforge.net/ and it required mysql v3,22x or higher, Apache running as a webserver, and PHP v4.0.2 or higher (mine is v4.0.6). However, when I finally attempted to log into this application, I got the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/eps/datacon.php on line 14 I contacted the author of this application who suggested that I reinstall PHP with the mysql option enabled. Towards that end, I downloaded and installed the php-mysql-4.0.6-15.s390.rpm file. Unfortunately I got the same error. I am somewhat certain that the author of this application was on the right track. Would anyone on this forum care to offer me any direction on this matter? Thank you in advance for your time. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Warning: thr_alarm queue is full
Hi, I get this error/warning each time server reaches 623 connections and thus no new clients can connect. What may I do to allow more clients? I know that the limit on the size of `alarm_queue' is set in mysys/thr_alarm.c, but is increasing the value in call of init_thr_alarm() safe? Regards, Maciek -- database, mysql, query, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems Configuring MySQL...
Hi all and thx in advance for trying to fix my problem. I'm instaling for the first time MySQL and when I try to test the program, I receive an error like Cannot connect to localhost (100060)...How can I configure the MySQL. Thx again Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiselect
Hi, can anybody tell me how can i select,update, delete the records from two table having same structure in the mysql. For ex MainTable --- id(int)|val (varchar) --- 1 a 2 b 3 c --- Duplicate Table --- id (int) | val (varchar) --- 1 d 5 e 6 f --- I want result for id 1 like this --- id (int) | val (varchar) --- 1 a 1 d --- Thanks in advance DK Dubey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WoW!!!! SQL is something!
select req_number,
right(concat('00',trim(req_number)),6) as sort_req,
case
from req
order by sort_req;
Haven't tried it but it should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:08 PM
To: Mysql_List (E-mail)
Subject: FW: WoW SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
ITD103
ITD104
ITD105
Because of the different lengths, this was a nightmare for order by and so
it led me to my first experiments with case
and I go the following:
select req_number, case
when (length(req_number)=4) then concat('00', req_number)
when (length(req_number)=5) then concat('0', req_number)
when (length(req_number)=6) then req_number
END as sort_req
from req order by sort_req;
Now there might be other ways to handle this and I would love to hear about
them but I thought that this taught me
something about sql that I had not understood until now. Just would like to
give a little back.
Thanks to all.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: RE: UPDATE
Cesar, Thursday, December 05, 2002, 2:50:30 AM, you wrote: CA The problem shows up when receiving the response of the query which CA tells me that the query was OK but rows affected. How many row were affected? 0? Was the password changed? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Question about MySQL replication and OPTIMIZE TABLE
Mariella, Thursday, December 05, 2002, 4:15:52 AM, you wrote: MDG I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM MDG Indices. MDG I would like to set replication (one master and one slave). MDG My question is: MDG When I OPTIMIZE TABLE table1, ... on the master will the slave be updated MDG or if I want to optimize the same tables on the slave I need to explicitly run MDG OPTIMIZE TABLE on the slave side ? OPTIMIZE TABLE isn't written to the binary logs. So, OPTIMIZE TABLE isn't replicated. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: take one database offline
Richardson, Thursday, December 05, 2002, 12:32:27 AM, you wrote: RDE On a single Linux box w/mysql 3.23.52 I have mysqld running and there are RDE about 20 databases live in the environment. I want to take one of the RDE databases offline but leave mysqld running with the other db's - without RDE interrupting service. RDE I want mysqld to gracefully refresh itself that the database is offline RDE and not require a restart. I have the luxury of time if that's helpful to RDE the solution. RDE How do I disable a database in a running server and leave the rest of the RDE db's in production? What do you mean disable database? You can't turn off the database.. You can make backup of the database and then drop the database.. Why do you want to do it? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Serwer Hardware p4 or pIII ?
I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump error
Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Serwer Hardware p4 or pIII ?
I saw some discussion on this topic last night, and forgot to put in my .02: Whomever said that memory and hard disk hardware should be the focal point in a new mySQL DB server, and not processors, I very much disagree with. While I agree that ample and fast memory, in addition to an efficient, reliable, and speedy storage system, is vital, neither of those mean squat if you don't have a high speed bus and powerful CPU to do the computations. You can have gigs and gigs of RAM and the fastest SCSI RAID array, for all I care, if it's still on a tiny 100MHZ FSB (like _original_ P3s), you still have a huge bottleneck looming on your horizon. I've been an AMD user for quite some time, and I really think AMD can kick some butt, but I think the statement that P4 FPU performance is poor is not entirely correct. the 2.53GHz P4 is right on par, if not better, than all but the highest (2600+) AMD XP chips. The 2.8 certainly edges them out, and the 3.06 GHz's performance is ASTONISHING. This is based on multiple benchmarks I've either seen or done, so I'm not just talking whitepapers (and keep in mind, I've been a big AMD fan for a couple years now). I refused to be impressed by the performance of Intel's processors, but this made my head spin. As far as cash goes, yes the 3.06 is VERY expensive (around $700 right now), but the other tiers below it are getting ever more reasonable. It comes down to cash flow, I think. P3's strong points is that they are tried and true, powerful, reliable, but inexpensive. P4's fast memory bandwidth, and the upper echelon of P4s are just impressive, but expensive. AMD's are cheap and pack a good punch. I won't go into Xeon, MP, and other multi-proc stuff, that's a slightly different ballgame. I very much agree with mixing and matching different types of boxes based on their strongpoints. Mike -Original Message- From: Robert Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:22 AM To: andy thomas; [EMAIL PROTECTED]; Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Install PHP with MySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kenneth, I would download the source packages from php.net and explicitly compile the mysql options into PHP. As an alternative, you can look for the mysql-php library rpms on rpmfind.net. My linux webserver (running apache and PHP 4.1.2) has php-mysql-4.1.2-7.i386.rpm, and I am sure that there is a comparable rpm package for your version. HTH, Bryant Hester - -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 7:50 AM To: Subject: Install PHP with MySQL I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability of the Linux VM on s390 platform. The application url is http://epayroll.sourceforge.net/ and it required mysql v3,22x or higher, Apache running as a webserver, and PHP v4.0.2 or higher (mine is v4.0.6). However, when I finally attempted to log into this application, I got the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/eps/datacon.php on line 14 I contacted the author of this application who suggested that I reinstall PHP with the mysql option enabled. Towards that end, I downloaded and installed the php-mysql-4.0.6-15.s390.rpm file. Unfortunately I got the same error. I am somewhat certain that the author of this application was on the right track. Would anyone on this forum care to offer me any direction on this matter? Thank you in advance for your time. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPe9ij0lWu7/HFp4nEQIdAwCgpmddOCcEdtpTQTR4oYV3YfRnCrUAn1AH psNBnvk4dbfG81g0CEQdSoQU =t/gi -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table copy problem
On 5 Dec 2002, at 14:44, Ol h Barnab s wrote: SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null and the SQL server creates a [temptablename] table with no records (or we hope that ;) ) But we can't do this on MySQL server, 'cause MySQL isn't know the SELECT...INTO syntax, but in the INSERT...INTO syntax, we must count the columns, which we wnat to create. (it's not good for me...) If I understand you correctly, the query you want is CREATE TABLE temptablename SELECT * FROM sourcetablename LIMIT 0; The only problem is that indexes and some other properties of the source table (defaults, for example) are not copied over, but I imagine that happens with your MS SQL statement as well. If you need to preserve those things, you'll have to take the output from SHOW CREATE TABLE sourcetablename, change the table name in the SQL, and execute the new statement. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile error on HPUX
Hi, I tried to compile mysql-3.23.49 on HPUX 11.11 system. When I run: CC=cc CXX=aCC CFLAGS=+DD64 CXXFLAGS=+DD64 ./configure Everything is fine, no errors. But when I run: make I got: cc: password.c, line 95: error 1000: Unexpected symbol: char_val. cc: panic 2017: Cannot recover from earlier errors, terminating. *** Error exit code 1 Stop. *** Error exit code 1 Stop. *** Error exit code 1 Do anyone have some ideas? Thanks a lot! Zengfa __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Fulltext
Hi, is there a possibility to query a column with a FULLTEXT-INDEX for a word fragment? I mean if there's the word skyscraper in a column I want to find it looking for sky and also looking for crap. It seems to me it does not work with something like: match(column) against(*crap*) Regards Bernhard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Problems Configuring MySQL...
Alejandro, Thursday, December 05, 2002, 4:03:23 PM, you wrote: ACG Hi all and thx in advance for trying to fix my problem. ACG I'm instaling for the first time MySQL and when I try to test the program, I ACG receive an error like Cannot connect to localhost (100060)...How can I ACG configure the MySQL. It usually means that MySQL server isn't running. You should run MySQL server as a service or in standalone mode (as I suppose you are using Windows): http://www.mysql.com/doc/en/NT_start.html http://www.mysql.com/doc/en/Win95_start.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Multiselect
Daya, Thursday, December 05, 2002, 4:14:02 PM, you wrote: DKD can anybody tell me how can i select,update, delete the records from two DKD table having same structure in the mysql. DKD For ex DKD MainTable DKD --- DKD id(int)|val (varchar) DKD --- DKD 1 a DKD 2 b DKD 3 c DKD --- DKD Duplicate Table DKD --- DKD id (int) | val (varchar) DKD --- DKD 1 d DKD 5 e DKD 6 f DKD --- DKD I want result for id 1 like this DKD --- DKD id (int) | val (varchar) DKD --- DKD 1 a DKD 1 d DKD --- Since v4.0 you can easy do it using UNION: http://www.mysql.com/doc/en/UNION.html In 3.23. you can do it using TEMPORARY tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 copy problem
Oláh, Thursday, December 05, 2002, 2:44:24 PM, you wrote: OB I want to copy one table's structure to another (non existing) table, but i OB didn't find any command or example to do that. Exactly, the situation is the OB following: OB A dynamic database structure has tables. We want to copy any of tha tables OB (while we don't know that table's structure) to another template table, OB which isn't exist. So, that looks like on MsSQL: OB SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null OB and the SQL server creates a [temptablename] table with no records (or we OB hope that ;) ) OB But we can't do this on MySQL server, 'cause MySQL isn't know the OB SELECT...INTO syntax, but in the INSERT...INTO syntax, we must count the OB columns, which we wnat to create. (it's not good for me...) OB Can somebody solve this problem? Or it's willn't work for the next version? OB (uhh-uhh, thats the worst...) You can use: CREATE TABLE new_table SELECT * FROM old_table LIMIT 0; but you must create indexes manually. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: I can not post to this list after I have joined
Mysql, sql,query --- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Why cannot I post questions to this list since I joined a month ago? Why? It says it cannot include attachment, but definately I didn't include attachment when I tried to post. Shawn __ Post your free ad now! http://personals.yahoo.ca __ Post your free ad now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiselect
* Daya Krishan Dubey can anybody tell me how can i select,update, delete the records from two table having same structure in the mysql. select, update and delete are three different operations. From your example data, it looks like you want to do select. For ex MainTable --- id(int)| val (varchar) --- 1 a 2 b 3 c --- Duplicate Table --- id (int) | val (varchar) --- 1 d 5 e 6 f --- I want result for id 1 like this --- id (int) | val (varchar) --- 1 a 1 d --- If you use mysql 4.0.x, you can try UNION: URL: http://www.mysql.com/doc/en/UNION.html If you use mysql 3.23.x, you can use a temporary table: CREATE TEMPORARY TABLE tmp1 SELECT * FROM MainTable WHERE id = 1; INSERT INTO tmp1 SELECT * FROM DuplicateTable WHERE id = 1; SELECT * FROM tmp1; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join-question
* Michelle de Beer I believe this question is solved by a join, but I haven't really got a hang of it. My table: -- | uid | rootid | parentid | name | -- | 1 | 0 | 0| name1| | 2 | 1 | 1| name2| | 3 | 1 | 2| name3| | 4 | 1 | 3| name4| | 5 | 1 | 2| name5| ... How do I get this (WHERE uid=5): -- | rootid_name | parentid_name | name | -- | name1 | name2 | name5| -- Try two self joins: SELECT r.name rootid_name,p.name parentid_name, name FROM tablename t LEFT JOIN tablename r ON r.uid = t.rootid LEFT JOIN tablename p ON p.uid = t.parentid WHERE t.uid = 5; -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join-question
- Original Message - From: Michelle de Beer [EMAIL PROTECTED] I believe this question is solved by a join, but I haven't really got a hang of it. My table: -- | uid | rootid | parentid | name | -- | 1 | 0 | 0| name1| | 2 | 1 | 1| name2| | 3 | 1 | 2| name3| | 4 | 1 | 3| name4| | 5 | 1 | 2| name5| ... How do I get this (WHERE uid=5): -- | rootid_name | parentid_name | name | -- | name1 | name2 | name5| -- Here you go. select a.name, b.name, c.name from yourtable as a, yourtable as b, yourtable as c where a.uid=c.rootid and b.uid=c.parentid and uid=5; or, as left joins: select a.name, b.name, c.name from yourtable as c left join yourtable as a on a.uid=c.rootid left join yourtable as b on b.uid=c.parentid where uid=5; Ryan sql to the hizzo query to the hizza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join-question
Hi: You might find these articles from O'Reilly Network will help clear the water. http://www.onlamp.com/pub/ct/19 Doug On Thu, 5 Dec 2002 07:46:03 -0800 (PST), Michelle de Beer wrote: I believe this question is solved by a join, but I haven't really got a hang of it. My table: -- | uid | rootid | parentid | name | -- | 1 | 0 | 0| name1| | 2 | 1 | 1| name2| | 3 | 1 | 2| name3| | 4 | 1 | 3| name4| | 5 | 1 | 2| name5| ... How do I get this (WHERE uid=5): -- | rootid_name | parentid_name | name | -- | name1 | name2 | name5| -- If you need more info, please tell me. Any thoughts? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: UPDATE ... SELECT FROM ... :)
On Wed, Dec 04, 2002 at 04:32:35PM -0500, Michael T. Babcock wrote: information from a to b. Any ideas for a one-shot SQL command to do this? I'm about to try selecting everything from b and the CommID from a as a join into a temporary table, then REPLACE it back into b. In case anyone wants to know how to do an UPDATE ... SELECT FROM ..., I did the equivalent of: BEGIN; ALTER TABLE b ADD Col3 ...; CREATE TABLE CopyCol3 SELECT b.id, b.Col1, b.Col2, a.Col3 FROM b LEFT JOIN a ON a.id = b.id; REPLACE INTO b (Col1, Col2, Col3) SELECT * FROM CopyCol3; DROP TABLE CopyCol3; ALTER TABLE a DROP Col3; COMMIT; This was to move the value Col3 from table a to b based on 'id'. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Join-question
I believe this question is solved by a join, but I haven't really got a hang of it. My table: -- | uid | rootid | parentid | name | -- | 1 | 0 | 0| name1| | 2 | 1 | 1| name2| | 3 | 1 | 2| name3| | 4 | 1 | 3| name4| | 5 | 1 | 2| name5| ... How do I get this (WHERE uid=5): -- | rootid_name | parentid_name | name | -- | name1 | name2 | name5| -- If you need more info, please tell me. Any thoughts? // Michelle sql, query __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow performance using 3.23 on RH 8.0
On Wed, Dec 04, 2002 at 05:06:54PM -0500, Ledet, Mike wrote: I tried your TOP suggestion but didn't see anything out of the ordinary. Swap size was constant (6400 or so) and didn't increase or decrease under load. Familiarize yourself with vmstat if you aren't already and then run `vmstat 1` and run your queries. See how the blocked/running processes look, how much CPU time is in use by the system/user processes and how many blocks per second the disk is reading/writing. SQL -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WoW!!!! SQL is something!
Thanks - this is even better - I will give it a try.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 6:19 AM
To: Norris, Joseph; Mysql_List (E-mail)
Subject: RE: WoW SQL is something!
select req_number,
right(concat('00',trim(req_number)),6) as sort_req,
case
from req
order by sort_req;
Haven't tried it but it should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Norris, Joseph [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:08 PM
To: Mysql_List (E-mail)
Subject: FW: WoW SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
IT68
ITD39
ITD40
IT69
ITD55
ITD56
IT72
ITD57
ITD58
ITD59
ITD60
IT73
ITD73
ITD67
IT74
ITD69
ITD70
IT78
IT79
IT83
ITD71
IT81
ITD75
ITD76
IT84
ITD96
ITD97
ITD98
ITD99
ITD100
ITD101
ITD102
ITD103
ITD104
ITD105
Because of the different lengths, this was a nightmare for order by and so
it led me to my first experiments with case
and I go the following:
select req_number, case
when (length(req_number)=4) then concat('00', req_number)
when (length(req_number)=5) then concat('0', req_number)
when (length(req_number)=6) then req_number
END as sort_req
from req order by sort_req;
Now there might be other ways to handle this and I would love to hear about
them but I thought that this taught me
something about sql that I had not understood until now. Just would like to
give a little back.
Thanks to all.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 select query returns incorrect no of rows
Vinay, Wednesday, December 04, 2002, 3:05:03 PM, you wrote: VM I m developing a web based application using Tomcat, Struts, JSP, mysql. VM I m using mysql 3.23.39-max-nt and mysql-connector-java-2.0.14 to access VM mysql through java 1.3.1. VM But sometimes the select query on 1 particular table returns less no of rows VM than the actual. VM Most of the times it works perfectly but only sometimes it returns incorrect VM no of rows. VM Everything works fine if I restart the mysql service and try again. What is the table type? Have you checked tablse with CHECK TABLE or myisamchk? Could you make a repeatable test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Index timestamp column
Michal, Tuesday, December 03, 2002, 7:19:08 PM, you wrote: MF Its possible to use index on this query ?? MF select .. MF from .. MF where timestamp_col2002110100 and timestamp_col2001110100 MF I have index on timestamp column, but EXPLAIN says that not using any of MF possible keys. MF I also try using BETWEEN function instead of two compares, but same result. Yes, it's possible: mysql explain select id from mybox where mydate 20020610010101 and mydate 20020101010101\G *** 1. row *** table: mybox type: range possible_keys: mydate key: mydate key_len: 4 ref: NULL rows: 20727 Extra: where used 1 row in set (0.01 sec) What is the output of explain? What is the table structure? What indexes are in the table? How many rows in the table? What is the version of MySQL server? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Join-question
Michelle, Thursday, December 05, 2002, 5:46:03 PM, you wrote: MdB I believe this question is solved by a join, but I MdB haven't really got a hang of it. MdB My table: MdB -- MdB | uid | rootid | parentid | name | MdB -- MdB | 1 | 0 | 0| name1| MdB | 2 | 1 | 1| name2| MdB | 3 | 1 | 2| name3| MdB | 4 | 1 | 3| name4| MdB | 5 | 1 | 2| name5| MdB ... MdB How do I get this (WHERE uid=5): MdB -- MdB | rootid_name | parentid_name | name | MdB -- MdB | name1 | name2 | name5| MdB -- MdB If you need more info, please tell me. Yes, JOIN is what you need. Something like that: mysql SELECT t1.uid, t1.name, t2.name, t3.name - FROM mytest t1 - LEFT JOIN mytest t2 ON t1.rootid=t2.uid - LEFT JOIN mytest t3 ON t1.parentid=t3.uid - WHERE t1.uid=5; +--+---+---+---+ | uid | name | name | name | +--+---+---+---+ |5 | name5 | name1 | name2 | +--+---+---+---+ 1 row in set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: take one database offline
another trick that might work is just to deny access to everyone to the database. if no one has access to it, then its as good as gone. i don't know if MySQL would allow just grant blah on *.* to user; revoke all on disabled_db.* from user; and alot of it depends on how the security is setup and possibly why you want just that database temporaraly gone. On Thursday 05 December 2002 8:05, you wrote: Richardson, Thursday, December 05, 2002, 12:32:27 AM, you wrote: RDE On a single Linux box w/mysql 3.23.52 I have mysqld running and there are RDE about 20 databases live in the environment. I want to take one of the RDE databases offline but leave mysqld running with the other db's - without RDE interrupting service. RDE I want mysqld to gracefully refresh itself that the database is offline RDE and not require a restart. I have the luxury of time if that's helpful to RDE the solution. RDE How do I disable a database in a running server and leave the rest of the RDE db's in production? What do you mean disable database? You can't turn off the database.. You can make backup of the database and then drop the database.. Why do you want to do it? -- mysql, sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ÓòÃû×¢²á£¬ÐéÄâÖ÷»ú³ö×â
Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»ÇÐ!ÏêÇéÇëä¯ÀÀ:http://www.28dns.com email:[EMAIL PROTECTED] лл£¡ ¡¡ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢AS P£©£¬È«ÃæÂú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢200M¿Õ¼ä£«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ150Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ236Ôª/Äꣻ 3¡¢200M¿Õ¼ä£«200MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ336Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåӯͨÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢Ó¯Í¨Ö÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢Ó¯Í¨Ö÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢Ó¯Í¨Ö÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ×££º¿ªÐÄ£¡Ë³Àû£¡ ӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾ QQ:7091499 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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
mi_test_all error help
I am using BSDI 4.3, and downloaded MySql source code 3.23.53. After untarring it, it passed ./configure --prefix=/usr/local/mysql. But when I run make, finally it says make: don't know how to make mi_test_all. Stop *** Error code 1 Your help will be appreciated Shawn Xu __ Post your free ad now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
EXCEPT, NOT IN
hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself then i have one table with questions. ID Text 1 What is ... 2 Who is ... 3 Question 3 and i have a table with possible answers ID QuestionIDref Text 1 1 Yes 2 1 No 3 2 Me 4 2 You 5 3 Well 6 3 not well when a user anwers somthing to a question the result is saved in a table called answerToQuestion ID QuestionIDref AnswerIDref PersonIDref 1 1 1 1 2 1 2 2 3 2 3 2 now i would like to find out that person 1 has not answerd question 2 and 3 and person 2 has not answered to question 3, and that person 3 has not answerd to any question. i would like something like (to get person 3's remaining questions) SELECT q.ID FROM questions AS q1 EXCEPT ( SELECT q2.ID FROM questions AS q2, answerToQuestion AS atq WHERE atq.PersonIDref=3 ); however the LEFT JOIN statement in MySQL seems not allow anything like WHERE atq.PersonIDref=3. the problem is that if i write: SELECTq.ID FROM questions AS q LEFT JOIN answerToQuestion ON q.questionID=answerToQuestion.QuestionIDref WHERE resultQuestion.questionIDref IS NULL ORDER BY q.questionID; this does not select the remaining question for a specific person. so i would need somthing like: SELECTq.ID FROM questions AS q LEFT JOIN answerToQuestion ON q.questionID=answerToQuestion.QuestionIDref WHERE answerToQuestion.questionIDref IS NULL AND answerToQuestion.PersonIDref=3 ORDER BY q.questionID; but this does not produce any answer. also tried to use IN instead of AND to select the current person, but still no luck. any help is appreciated. stig _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hola, Tenia instalado MySQL 3.23.53 en mi pc. He reinstalado todo el sistema y lo he vuelto a instalar, pero no consigo arrancar el servidor sql. La instalación la he hecho según indica el manual y tal como la habia hecho en la otra ocasión. Cuando quiero arrancar el servidor (/bin/safe_mysqld --user=mysql ) obtengo el siguiente mensaje: starting mysqld daemon with databases from /var/lib/mysql mysqld ended A qué puede deberse? Gracias ___ Copa del Mundo de la FIFA 2002 El único lugar de Internet con vídeos de los 64 partidos. ¡Apúntante ya! en http://fifaworldcup.yahoo.com/fc/es/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: WoW!!!! SQL is something!
Colin,
According to the docs this function wants a string and when I use the field
name it says unknown column.
Thanks anyway.
-Original Message-
From: Colin Kettenacker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 5:32 PM
To: Mysql_List (E-mail)
Subject: Re: WoW SQL is something!
I had a problem that required a proper sort of the following:
IT66
ITD38
.
.
SNIP
.
.
ITD100
ITD101
ITD102
ITD103
ITD104
ITD105
Because of the different lengths, this was a nightmare for order by and
so
it led me to my first experiments with case
and I go the following:
select req_number, case
when (length(req_number)=4) then concat('00', req_number)
when (length(req_number)=5) then concat('0', req_number)
when (length(req_number)=6) then req_number
END as sort_req
from req order by sort_req;
Now there might be other ways to handle this and I would love to hear
about
them but I thought that this taught me
something about sql that I had not understood until now. Just would like
to
give a little back.
Thanks to all.
Well I'm fairly new to MySQL so I am not sure if this'll work. If it does it
will save a few cycles of logic.
SELECT LPAD(req_number,6,'0');
Don't know if you need to coerce the numeric data into a string first
though.
ck
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: InnoDB shared lock with JOINs
Evgeny, - Original Message - From: Evgeny Chuykov [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, December 05, 2002 12:28 PM Subject: InnoDB shared lock with JOINs Hallo. I have this query: SELECT table1.id FROM table1 LEFT JOIN table2 USING(id) WHERE table1.a=1 and table2.b=1 table1 is MyISAM and table2 is InnoDB. I want a shared mode lock on the table2. Is it possible, or i should split this query? I think LOCK IN SHARE MODE will work, if you want to lock the rows in table2 which the join touches. But better test it with 2 connections. -- Have a nice day. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
import size
I'm attempting to import 36 files of varying size from about 500kb to 80mb. I've found that using the local infile import query on files that are several mb in size takes up to a min per mb and much longer if it get's over 100mb. The system we're using has 500mb RAM and a 1600mHz processor. Is there a faster way to do these bulk imports? This is supposed to be faster than the insert function especially on large numbers of imports. Can anyone tell me anything about this to speed this up perhaps? Thank you, Sarah - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Server
Hola de nuevo, he mirado el log de mysqld, y pone lo siguiente: bind on unix socket : permission denied Donde reside el problema? Gracias ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump error
Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table copy problem
Dear Olh, SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null In MySQL, you simply do: CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0 That's even simpler, 100% reliable and FAST! :) HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschftsfhrer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Olh Barnabs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 1:44 PM Subject: Table copy problem Hello! I want to copy one table's structure to another (non existing) table, but i didn't find any command or example to do that. Exactly, the situation is the following: A dynamic database structure has tables. We want to copy any of tha tables (while we don't know that table's structure) to another template table, which isn't exist. So, that looks like on MsSQL: SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null and the SQL server creates a [temptablename] table with no records (or we hope that ;) ) But we can't do this on MySQL server, 'cause MySQL isn't know the SELECT...INTO syntax, but in the INSERT...INTO syntax, we must count the columns, which we wnat to create. (it's not good for me...) Can somebody solve this problem? Or it's willn't work for the next version? (uhh-uhh, thats the worst...) Thanx, Barnabas Olah Cegedim Hungary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
make: don't know how to make mi_test_all. Stop
I am forwarding Shawn's real question to the list, since I haven't got a clue :) -Original Message- From: shawn xu [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:42 PM To: Luc Foisy Subject: RE: I can not post to this list after I have joined Hi, Luc Foisy: I don't know why this one got through, but the question I post never get through. Did you get my post : Subject: mi_test_all error help Content: I am using BSDI 4.3, and downloaded MySql source code 3.23.53. After untarring it, it passed ./configure --prefix=/usr/local/mysql. But when I run make, finally it says make: don't know how to make mi_test_all. Stop *** Error code 1 Your help will be appreciated Shawn Xu ps: I am using www.yahoo.com. I really appreciate if you can help with this. --- Luc Foisy [EMAIL PROTECTED] wrote: Why cannot I post questions to this list since I joined a month ago? Why? It says it cannot include attachment, but definately I didn't include attachment when I tried to post. What do you use to send your mail? Is it web mail? Things like incredimail and some webmails attach stuff to your email, like pictures and stuff to make it look pretty If thats the case, try using a plain text email client sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection to MySQL server during query.
Oops. I should have been paying more attention to the lost connection thread. What does the Lost connection to MySQL server during query error message mean and where can I find more information about it? I just installed the DBTools on a XP box. When I try to connect to by Linux box, it gives me this error. Linux 2.4 MySQL 3.23.52 Theodore Reph [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: Install PHP with MySQL
yes... it seems that you do not have mysql in the PHP module. you can use --with-mysql in the php configure, but you should use --with-mysql=/your/mysql/directory PHP has included code for the default mysql build. try to use your own libs and headers. HTH brian sql, query, mysql On Thursday 05 December 2002 08:28, Bryant Hester wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kenneth, I would download the source packages from php.net and explicitly compile the mysql options into PHP. As an alternative, you can look for the mysql-php library rpms on rpmfind.net. My linux webserver (running apache and PHP 4.1.2) has php-mysql-4.1.2-7.i386.rpm, and I am sure that there is a comparable rpm package for your version. HTH, Bryant Hester - -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 7:50 AM To: Subject: Install PHP with MySQL I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability of the Linux VM on s390 platform. The application url is http://epayroll.sourceforge.net/ and it required mysql v3,22x or higher, Apache running as a webserver, and PHP v4.0.2 or higher (mine is v4.0.6). However, when I finally attempted to log into this application, I got the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/eps/datacon.php on line 14 I contacted the author of this application who suggested that I reinstall PHP with the mysql option enabled. Towards that end, I downloaded and installed the php-mysql-4.0.6-15.s390.rpm file. Unfortunately I got the same error. I am somewhat certain that the author of this application was on the right track. Would anyone on this forum care to offer me any direction on this matter? Thank you in advance for your time. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPe9ij0lWu7/HFp4nEQIdAwCgpmddOCcEdtpTQTR4oYV3YfRnCrUAn1AH psNBnvk4dbfG81g0CEQdSoQU =t/gi -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Select Idea [ORDER BY]
On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote: The ten last dates appear as a default result of a Archives page. When I enter for the first time in the page, it give me the last ten Files that was uploaded. In the same page, I can ORDER BY the ten last dates results by COD, DATE, NAME or FILE. So, when I click in some os then, I need to ORDER the TEN DATES, not the entire table and give ten results, did you get it? So you want your query to have 'ORDER BY DATE,COD' ?? -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
EXCEPT, NOT IN
hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself then i have one table with questions. ID Text 1 What is ... 2 Who is ... 3 Question 3 and i have a table with possible answers ID QuestionIDref Text 1 1 Yes 2 1 No 3 2 Me 4 2 You 5 3 Well 6 3 not well when a user anwers somthing to a question the result is saved in a table called answerToQuestion ID QuestionIDref AnswerIDref PersonIDref 1 1 1 1 2 1 2 2 3 2 3 2 now i would like to find out that person 1 has not answerd question 2 and 3 and person 2 has not answered to question 3, and that person 3 has not answerd to any question. i would like something like (to get person 3's remaining questions) SELECT q.ID FROM questions AS q1 EXCEPT ( SELECT q2.ID FROM questions AS q2, answerToQuestion AS atq WHERE atq.PersonIDref=3 ); however the LEFT JOIN statement in MySQL seems not allow anything like WHERE atq.PersonIDref=3. the problem is that if i write: SELECTq.ID FROM questions AS q LEFT JOIN answerToQuestion ON q.questionID=answerToQuestion.QuestionIDref WHERE resultQuestion.questionIDref IS NULL ORDER BY q.questionID; this does not select the remaining question for a specific person. so i would need somthing like: SELECTq.ID FROM questions AS q LEFT JOIN answerToQuestion ON q.questionID=answerToQuestion.QuestionIDref WHERE answerToQuestion.questionIDref IS NULL AND answerToQuestion.PersonIDref=3 ORDER BY q.questionID; but this does not produce any answer. also tried to use IN instead of AND to select the current person, but still no luck. any help is appreciated. stig _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
Try use commit before use this statement... 5/12/2002 14:29:17, lpkvb [EMAIL PROTECTED] wrote: Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»ÇÐ!ÏêÇéÇëä¯ÀÀ:http://www.28dns.com email:[EMAIL PROTECTED] лл£¡ ¡¡ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢AS P£©£¬È«ÃæÂú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£ 1¡¢200M¿Õ¼ä£«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ150Ôª/Äꣻ 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ236Ôª/Äꣻ 3¡¢200M¿Õ¼ä£«200MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ336Ôª/Äê¡£ ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåӯͨÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º 1¡¢Ó¯Í¨Ö÷»úÈ«²¿²ÉÓÃÔ×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£» 2¡¢Ó¯Í¨Ö÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£» 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£» 4¡¢Ó¯Í¨Ö÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£ ×££º¿ªÐÄ£¡Ë³Àû£¡ ӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾ QQ:7091499 --- ·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com) ½øCMMÍøУ(http://www.21cmm.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 - Darney Lampert SKY Informática - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump error
thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again: mysql --debug -eselect * from table /tmp/lista.log ERROR 2013 at line 1: Lost connection to MySQL server during query I think is problem with the binary, but I don't know why.. an idea may be install a recent new version from mysql. From: Listen Hinz [EMAIL PROTECTED] To: Carlos A. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysqldump error Date: Thu, 5 Dec 2002 18:16:40 +0100 Dear Carlos, Got error: 2013: Lost connection to MySQL server during query when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server, and the dump should work. HTH! -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Carlos A. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 3:13 PM Subject: mysqldump error Hello I have a Red Hat 7.1 server with mysql 3.23.49a installed. Recently I get an error when run mysqldump in order to backup my dbs. The error is following: /usr/local/bin/mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server I ran mysqldump with --opt or without it, the error is the same. I must say the table have many registers, almost 200.000 PD: I ran myisamchk before do the dump, and the error remains. Thanks in advance. _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple hosts w/ GRANT
I'm wondering if it's possible to specify multiple hosts for a user when setting up permissions, but without using wildcards. For example.. if I have these two GRANT statements: GRANT SELECT on database.* to [EMAIL PROTECTED] identified by 'passwd'; GRANT SELECT on database.* to [EMAIL PROTECTED] identified by 'passwd'; Is it possible to combine them in some fashion such that there would be one entry in the mysql.user table with multiple hosts? -Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems with MySQL lists internet line
Hi We are having some problems with high load on our Internet line in the MySQL office in Uppsala. And we might need to temporary ( about 12-24 hours) turn off the MySQL mailing lists. If our current workaround will work we can stay up. We should get a upgrade of our Internet line equipment tomorrow and hopefully that will solve the problem. /David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
