client side tool of MySQL
Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering if there is any great client side tools of it, like the toad for oracle? actually I'm not expecting it to be that functional, but at least i wish it's better than the one in the mySQL package. Any input is greatly appreciated ! Hao
Re: client side tool of MySQL
Get the actual version 1.17 of MySQL-Front at http://www.mysqlfront.de/ or http://www.anse.de/mysqlfront/ Greetings, Ansgar Becker [EMAIL PROTECTED] | http://www.anse.de AB7670-RIPE Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering if there is any great client side tools of it, like the toad for oracle? actually I'm not expecting it to be that functional, but at least i wish it's better than the one in the mySQL package. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transaction
Hi ! I have simply question. When do i have use transaction in mysql ?? I have mysql 3.23.37 from RPM for Redhat Linux. do i have to compile from source when i want transaction with BDB tables ?? Or i simply type type=bdb when i create table and it'all. Now my table uses transaction ?? Regards Ireneusz Piasecki [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: LIKE clause in DELETE-Statement
Dear all, Does anyone know how I can run a script that calls other scripts in order to create the DB and its tables? How do I do it from my Windows NT? Thanks From: Sascha Dahl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: LIKE clause in DELETE-Statement Date: Wed, 25 Apr 2001 10:48:51 +0200 Hi! We just encountered that MySQL seeems not to accept a LIKE '%...' clause in a DELETE statement. In the annotated online documentation it is said a DELETE statement can be followed by any valid WHERE clause. LIKE is listed as a common string comparison function in the SELECT and WHERE functions chapter. So does MySQL actually deny LIKE in DELETEs as it seems to do or is there a way to use this combination as you can guess reading the manual?! Thanks in advance for a short No, not possible or a hint how it could work. Regards, Sascha Dahl ___ b e s t E s h o p . d e A G · Sascha Dahl · IT Consultant TZ/Friedrich-Ebert-Str. · 51429 Bergisch Gladbach · Germany Phone: +49 (0)2204 - 84 34 03 · Fax: +49 (0)2204 - 84 34 19 mailto:[EMAIL PROTECTED] · http://www.besteforschung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
conversions
hi ! I need to insert a value into the database whose column type is datetime. the value that i am receiving is on the form of a string. the problem is that how does one convert this value recieved from a jsp page to the datatype that of SQL using JDBC callable statement. thanking you in anticipation. shilpa
Re: MySQL Visual C++ API problems
Hi! I'm having problems compiling the example programs provided with the MySQL++ API package on MS Visual C++ 6.0. The compiler reports errors on longlongs. Does anybody know hot to get around this? What files should be included in the project? Thanks in advance on any info, Kristian - Kristian Lukander [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
Primary key not unique on Innodb tables.
Bonjour, Mysql-3.23.37 on Solaris 2.8. I created this table : CREATE TABLE livequote_last_PAR ( symbole char(20) NOT NULL default '', id int(10) unsigned NOT NULL default '0', date datetime NOT NULL default '-00-00 00:00:00', last double(17,5) NOT NULL default '0.0', volume int(10) unsigned NOT NULL default '0', PRIMARY KEY (symbole,id), KEY idx_id (id) ) TYPE=Innobase; As you can see, (symbole,id) is the primary key. But : mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33121 | 2001-04-25 11:59:39 | 78.7 |492 | | 1rPFTE | 33121 | 2001-04-25 11:59:39 | 78.7 |492 | | 1rPFTE | 33120 | 2001-04-25 11:59:39 | 78.7 | 1290 | | 1rPFTE | 33120 | 2001-04-25 11:59:39 | 78.7 | 1290 | | 1rPFTE | 33119 | 2001-04-25 11:59:29 | 78.7 | 10 | | 1rPFTE | 33118 | 2001-04-25 11:59:04 | 78.7 |106 | | 1rPFTE | 33117 | 2001-04-25 11:58:49 | 78.7 | 50 | | 1rPFTE | 33116 | 2001-04-25 11:57:57 | 78.7 | 76 | | 1rPFTE | 33115 | 2001-04-25 11:57:33 | 78.6 | 99 | | 1rPFTE | 33114 | 2001-04-25 11:56:44 | 78.7 | 1768 | | 1rPFTE | 33113 | 2001-04-25 11:56:44 | 78.7 |118 | | 1rPFTE | 33112 | 2001-04-25 11:56:04 | 78.7 | 1000 | +-+---+-+--++ 12 rows in set (0.00 sec) I've not yet deeply explored what the problem is, but there is a problem. I will have to ckech exactly what queries my programs are doing in order to have this result, but there is a problem in mysql or innodb anyway I think. Regards, 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
RE: transaction
Hi there Depending on whether you have downloaded the new mysqld-max or not, if you have not, then you have to compile with the Berkelely DB option, if you have, then you just create the tale with type=bdb. Look at the table afterwards, show table status, if it is MYIsam then you don't have the BDB option, otherwise it will say BerkelyDB Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Ireneusz Piasecki Sent: 25 April 2001 10:29 To: [EMAIL PROTECTED] Subject: transaction Hi ! I have simply question. When do i have use transaction in mysql ?? I have mysql 3.23.37 from RPM for Redhat Linux. do i have to compile from source when i want transaction with BDB tables ?? Or i simply type type=bdb when i create table and it'all. Now my table uses transaction ?? Regards Ireneusz Piasecki [EMAIL PROTECTED] [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: Primary key not unique on Innodb tables.
Alex, check by other queries whether it is the table which contains a duplicate row, or if the SELECT gives a wrong answer. Check what SELECT * FROM ... WHERE symbole='1rPFTE'; returns. Regards, Heikki At 12:04 PM 4/25/01 +0200, you wrote: Bonjour, Mysql-3.23.37 on Solaris 2.8. I created this table : CREATE TABLE livequote_last_PAR ( symbole char(20) NOT NULL default '', id int(10) unsigned NOT NULL default '0', date datetime NOT NULL default '-00-00 00:00:00', last double(17,5) NOT NULL default '0.0', volume int(10) unsigned NOT NULL default '0', PRIMARY KEY (symbole,id), KEY idx_id (id) ) TYPE=Innobase; As you can see, (symbole,id) is the primary key. But : mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33121 | 2001-04-25 11:59:39 | 78.7 |492 | | 1rPFTE | 33121 | 2001-04-25 11:59:39 | 78.7 |492 | | 1rPFTE | 33120 | 2001-04-25 11:59:39 | 78.7 | 1290 | | 1rPFTE | 33120 | 2001-04-25 11:59:39 | 78.7 | 1290 | | 1rPFTE | 33119 | 2001-04-25 11:59:29 | 78.7 | 10 | | 1rPFTE | 33118 | 2001-04-25 11:59:04 | 78.7 |106 | | 1rPFTE | 33117 | 2001-04-25 11:58:49 | 78.7 | 50 | | 1rPFTE | 33116 | 2001-04-25 11:57:57 | 78.7 | 76 | | 1rPFTE | 33115 | 2001-04-25 11:57:33 | 78.6 | 99 | | 1rPFTE | 33114 | 2001-04-25 11:56:44 | 78.7 | 1768 | | 1rPFTE | 33113 | 2001-04-25 11:56:44 | 78.7 |118 | | 1rPFTE | 33112 | 2001-04-25 11:56:04 | 78.7 | 1000 | +-+---+-+--++ 12 rows in set (0.00 sec) I've not yet deeply explored what the problem is, but there is a problem. I will have to ckech exactly what queries my programs are doing in order to have this result, but there is a problem in mysql or innodb anyway I think. Regards, 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
What's the max number of records mysql can handle
we're looking at implementing a system that will need to store an average of between 3 and 5 million records in the main table - we've decided interbase cant handle our volume-will mysql be able to do it? Matt Benic +27 72 182 6161 [EMAIL PROTECTED] http://i.am/mbenic
Re: Question about MySQL GUI on Win32
Jason Holliston writes: This is probably something I'll smack my head about afterward, but here goes: is it possible to execute multiple queries in the MySQL client GUI on Win32? What's accepted on the command line or in a .sql script doesn't work when pasted into it. Thanks in advance! -Jason No, mysqlgui does not work with several queries. For scripts, mysql monitor program is the best. With mysqlgui, however you have an interactive command history (with deletion of entries and many other stuff) , plus hierarchy of queries on the main menu. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: client side tool of MySQL
Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering = if there is any great client side tools of it, like the toad for oracle? = actually I'm not expecting it to be that functional, but at least i wish = it's better than the one in the mySQL package. Any input is greatly appreciated ! Hao Hi! Try our mysqlgui version for Windows from GUI clients page on www.mysql.com. After you download, follow instructions in README. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Possible bug with InnoDB table
Tianlin, you are right. If InnoDB did a scan from a secondary index to an empty table, then it returned an error code MySQL did not accept in this context. I changed now the error code and it will be right in the next release .38, if Monty has not yet gotten it out. Regards, Heikki I am running MySQL 3.23.37 compiled by myself on Linux platform. Here is a repeatable example: mysql create table test (id int not null, - KEY id (id)) type=InnoDB; mysql SELECT id FROM test WHERE id1; ERROR 1032: Can't find record in 'test' I am expecting something like the following: Empty set (0.00 sec) You need the following combination to repeat this bug: (1) InnoDB table (MyISAM works OK) (2) where clause (without WHERE clause works OK) (3) or = comparison operator (= or or = work OK) (4) NOT NULL in column definition(wothout NOT NULL works OK) (5) KEY id (id) in column definition (otherwise it works OK) I also noticed that in C API, mysql_store_result() fails with query ELECT id FROM test WHERE id1. Regards, Tianlin WANG - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Visual C++ API problems
Kristian Lukander writes: Hi! I'm having problems compiling the example programs provided with the MySQL++ API package on MS Visual C++ 6.0. The compiler reports errors on longlongs. Does anybody know hot to get around this? What files should be included in the project? Thanks in advance on any info, Kristian - Kristian Lukander [EMAIL PROTECTED] Hi! Most probably you are using 3.22 or some early 3.23 MySQL client libraries and / or include files. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What's the max number of records mysql can handle
Matt Benic writes: we're looking at implementing a system that will need to store an average of between 3 and 5 million records in the main table - we've decided interbase cant handle our volume-will mysql be able to do it? Matt Benic +27 72 182 6161 [EMAIL PROTECTED] http://i.am/mbenic yes, MySQL will do it easily, provided you choose the right OS and filesystem. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Primary key not unique on Innodb tables.
Heikki, I did the downgrade to Mysql-3.23.36. I don't have this problem with 3.23.36 ! Alex. HT check by other queries whether it is the table which contains a HT duplicate row, or if the SELECT gives a wrong answer. HT Check what HT SELECT * FROM ... WHERE symbole='1rPFTE'; HT returns. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please, problem with french accentual characters like à é è
Hello,I am a java developper and using mysql database engine, I am using tomcat, I wrote a servlet wich writes a sentences, it works fine but the accentual characters like à é è are replaced by ? character, can some one help me, it's urgent. Thanks ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.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: Why MySQL db will only allow 127 records imported?
Howard Picken [EMAIL PROTECTED] wrote: I'm trying to import a csv file into a db. all text fields are enclosed and all fields are , delimited. the file is 900 records long. The error I'm getting is.. ERROR 1062 at line 1: Duplicate entry '127' for key 1 Your ID field is type 'TINYINT' which can contain a max value of 127. Numbers larger than that are saved to the DB as 127 so it's choking b/c it's causing duplicate values for a key field. Change the field type to INT or something appropriate for your dataset. Make it UNSIGNED if you don't expect negative numbers in the ID field. SQL is your friend (added to please the filter). -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
Problem with InnoDB
Hey, I dunno whether it's a bug or just I don't know how to use transactions properly. I've got 3.23.36 on FreeBSD 4.2-STABLE, and when I do this: CREATE TABLE test TYPE=Innobase SELECT * otherdb.sometable; MySQL hangs. If I limit the SELECT query to 10-100 rows, it executes quite fast (same if I change TYPE to MyISAM). But larger limit or no limit causes mysqld to eat up 99% CPU and then I have to kill the process. Same thing with: INSERT INTO test SELECT * FROM otherdb.sometable; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: Primary key not unique on Innodb tables.
Heikki, Another exemple : mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33561 | 2001-04-25 14:04:04 | 78.6 |150 | | 1rPFTE | 33560 | 2001-04-25 14:03:13 | 78.5 | 30 | | 1rPFTE | 33559 | 2001-04-25 14:02:20 | 78.45000 | 27 | | 1rPFTE | 33558 | 2001-04-25 14:02:11 | 78.5 | 1000 | | 1rPFTE | 33557 | 2001-04-25 14:02:11 | 78.5 | 38 | | 1rPFTE | 33556 | 2001-04-25 14:02:03 | 78.5 | 27 | | 1rPFTE | 33555 | 2001-04-25 14:01:39 | 78.5 | 28 | | 1rPFTE | 33554 | 2001-04-25 14:01:23 | 78.5 |246 | | 1rPFTE | 33553 | 2001-04-25 14:01:21 | 78.5 |488 | | 1rPFTE | 33552 | 2001-04-25 14:01:21 | 78.55000 | 1512 | +-+---+-+--++ 10 rows in set (0.00 sec) UPDATE livequote_last_PAR SET date=concat(CURDATE(), ' 14:04:51'),last=78.50,volume=32,id=33562 WHERE symbole='1rPFTE' AND id=33552 mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33562 | 2001-04-25 14:04:51 | 78.5 | 32 | | 1rPFTE | 33561 | 2001-04-25 14:04:04 | 78.6 |150 | | 1rPFTE | 33560 | 2001-04-25 14:03:13 | 78.5 | 30 | | 1rPFTE | 33559 | 2001-04-25 14:02:20 | 78.45000 | 27 | | 1rPFTE | 33558 | 2001-04-25 14:02:11 | 78.5 | 1000 | | 1rPFTE | 33557 | 2001-04-25 14:02:11 | 78.5 | 38 | | 1rPFTE | 33556 | 2001-04-25 14:02:03 | 78.5 | 27 | | 1rPFTE | 33555 | 2001-04-25 14:01:39 | 78.5 | 28 | | 1rPFTE | 33554 | 2001-04-25 14:01:23 | 78.5 |246 | | 1rPFTE | 33553 | 2001-04-25 14:01:21 | 78.5 |488 | +-+---+-+--++ 10 rows in set (0.01 sec) UPDATE livequote_last_PAR SET date=concat(CURDATE(), ' 14:04:57'),last=78.45,volume=42,id=33563 WHERE symbole='1rPFTE' AND id=33553 UPDATE livequote_last_PAR SET date=concat(CURDATE(), ' 14:04:57'),last=78.45,volume=91,id=33564 WHERE symbole='1rPFTE' AND id=33554 mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33564 | 2001-04-25 14:04:57 | 78.45000 | 91 | | 1rPFTE | 33564 | 2001-04-25 14:04:57 | 78.45000 | 91 | | 1rPFTE | 33563 | 2001-04-25 14:04:57 | 78.45000 | 42 | | 1rPFTE | 33563 | 2001-04-25 14:04:57 | 78.45000 | 42 | | 1rPFTE | 33562 | 2001-04-25 14:04:51 | 78.5 | 32 | | 1rPFTE | 33561 | 2001-04-25 14:04:04 | 78.6 |150 | | 1rPFTE | 33560 | 2001-04-25 14:03:13 | 78.5 | 30 | | 1rPFTE | 33559 | 2001-04-25 14:02:20 | 78.45000 | 27 | | 1rPFTE | 33558 | 2001-04-25 14:02:11 | 78.5 | 1000 | | 1rPFTE | 33557 | 2001-04-25 14:02:11 | 78.5 | 38 | | 1rPFTE | 33556 | 2001-04-25 14:02:03 | 78.5 | 27 | | 1rPFTE | 33555 | 2001-04-25 14:01:39 | 78.5 | 28 | +-+---+-+--++ 12 rows in set (0.00 sec) 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
lt: About Last Insert ID and Getting Column Names
- Original Message - From: Yusuf Incekara To: [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 2:50 PM Subject: About Last Insert ID and Getting Column Names I created a Visual Basic Project that uses Last insert id function and getting column names. Working properly. Anyone interested please mail me. Regards Yusuf Incekara Stupid robot : database,sql,query
Error 1031 when altering merge table. Bug? (plus on-line manualcomment system broken)
Hi all, I'm having more merge table woes! I'm trying to alter a merge table to remap it without dropping and re-creating. This is what I get: mysql ALTER TABLE eventlog_all UNION=(eventlog_11, ..lots of tables..., eventlog_88); ERROR 1031: Table handler for '#sql-1f1_ea6d9' doesn't have this option At first, I thought I might need to add in TYPE=MERGE to the query, but that doesn't help. I think this might be a bug - could it be related to the ALTER TABLE now remembers the old UNION() definition. bug fix? I'm using version 3.23.32. Would an upgrade help? By the way, I noticed a syntax error in the one the examples in the manual concerning merge tables. It's in section 8.2. The bullet-point example reading: * Use ALTER TABLE table_name UNION(...) Should of course be: * Use ALTER TABLE table_name UNION=(...) Notice the equals sign between UNION and the accompanying brackets. I would've made a comment in the manual, but the new account registration seems to be broken - you just get an Unknown column 'country_id' in 'field list' SQL error. Regards, Basil Hussain ([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
Problem with mysqlgui 1.7.4-2 on Win 98 2nd edition
Hi Thanks for your very good work. The problem is : I'am not able to edit or create table when using mysqlgui 1.7.4-2 on Win 98 2nd edition. When I try to select the corresponding menu, no new window appears and nothing happen. Thanks for your help.
Re[2]: Primary key not unique on Innodb tables.
Heikki, HT check by other queries whether it is the table which contains a HT duplicate row, or if the SELECT gives a wrong answer. HT Check what HT SELECT * FROM ... WHERE symbole='1rPFTE'; HT returns. Really strange : mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33548 | 2001-04-25 13:54:43 | 78.55000 | 37 | | 1rPFTE | 33547 | 2001-04-25 13:54:30 | 78.55000 | 40 | | 1rPFTE | 33546 | 2001-04-25 13:54:19 | 78.55000 |300 | | 1rPFTE | 33545 | 2001-04-25 13:54:09 | 78.55000 | 61 | | 1rPFTE | 33544 | 2001-04-25 13:54:09 | 78.55000 | 9 | | 1rPFTE | 33543 | 2001-04-25 13:53:37 | 78.55000 |968 | | 1rPFTE | 33542 | 2001-04-25 13:53:37 | 78.6 |482 | | 1rPFTE | 33541 | 2001-04-25 13:53:37 | 78.65000 |950 | | 1rPFTE | 33540 | 2001-04-25 13:53:30 | 78.7 |152 | | 1rPFTE | 33539 | 2001-04-25 13:53:06 | 78.65000 | 1700 | +-+---+-+--++ 10 rows in set (0.00 sec) Then I see in the logs of my prog that it does : UPDATE livequote_last_PAR SET date=concat(CURDATE(), ' 13:58:17'),last=78.55,volume=20,id=33549 WHERE symbole='1rPFTE' AND id=33539 And then mysql select * from livequote_last_PAR where symbole='1rPFTE'; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33549 | 2001-04-25 13:58:17 | 78.55000 | 20 | | 1rPFTE | 33540 | 2001-04-25 13:53:30 | 78.7 |152 | | 1rPFTE | 33541 | 2001-04-25 13:53:37 | 78.65000 |950 | | 1rPFTE | 33542 | 2001-04-25 13:53:37 | 78.6 |482 | | 1rPFTE | 33543 | 2001-04-25 13:53:37 | 78.55000 |968 | | 1rPFTE | 33544 | 2001-04-25 13:54:09 | 78.55000 | 9 | | 1rPFTE | 33545 | 2001-04-25 13:54:09 | 78.55000 | 61 | | 1rPFTE | 33546 | 2001-04-25 13:54:19 | 78.55000 |300 | | 1rPFTE | 33547 | 2001-04-25 13:54:30 | 78.55000 | 40 | | 1rPFTE | 33548 | 2001-04-25 13:54:43 | 78.55000 | 37 | | 1rPFTE | 33549 | 2001-04-25 13:58:17 | 78.55000 | 20 | +-+---+-+--++ 11 rows in set (0.00 sec) mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33549 | 2001-04-25 13:58:17 | 78.55000 | 20 | | 1rPFTE | 33549 | 2001-04-25 13:58:17 | 78.55000 | 20 | | 1rPFTE | 33548 | 2001-04-25 13:54:43 | 78.55000 | 37 | | 1rPFTE | 33547 | 2001-04-25 13:54:30 | 78.55000 | 40 | | 1rPFTE | 33546 | 2001-04-25 13:54:19 | 78.55000 |300 | | 1rPFTE | 33545 | 2001-04-25 13:54:09 | 78.55000 | 61 | | 1rPFTE | 33544 | 2001-04-25 13:54:09 | 78.55000 | 9 | | 1rPFTE | 33543 | 2001-04-25 13:53:37 | 78.55000 |968 | | 1rPFTE | 33542 | 2001-04-25 13:53:37 | 78.6 |482 | | 1rPFTE | 33541 | 2001-04-25 13:53:37 | 78.65000 |950 | | 1rPFTE | 33540 | 2001-04-25 13:53:30 | 78.7 |152 | +-+---+-+--++ 11 rows in set (0.01 sec) After other updates, the duplicated line disappears : mysql select * from livequote_last_PAR where symbole='1rPFTE' order by id desc; +-+---+-+--++ | symbole | id| date| last | volume | +-+---+-+--++ | 1rPFTE | 33551 | 2001-04-25 14:00:46 | 78.6 | 4 | | 1rPFTE | 33550 | 2001-04-25 14:00:45 | 78.6 | 2000 | | 1rPFTE | 33549 | 2001-04-25 13:58:17 | 78.55000 | 20 | | 1rPFTE | 33548 | 2001-04-25 13:54:43 | 78.55000 | 37 | | 1rPFTE | 33547 | 2001-04-25 13:54:30 | 78.55000 | 40 | | 1rPFTE | 33546 | 2001-04-25 13:54:19 | 78.55000 |300 | | 1rPFTE | 33545 | 2001-04-25 13:54:09 | 78.55000 | 61 | | 1rPFTE | 33544 | 2001-04-25 13:54:09 | 78.55000 | 9 | | 1rPFTE | 33543 | 2001-04-25 13:53:37 | 78.55000 |968 | | 1rPFTE | 33542 | 2001-04-25 13:53:37 | 78.6 |482 | +-+---+-+--++ 10 rows in set (0.00 sec) I didn't noticed this problem with Mysql-3.23.36. I will try to downgrade to 3.23.36 in order to see if I have the problem. 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:
not configuring on solaris 2.7
solaris 2.7 + gcc 2.95.2 mysql 3.23.37 in my last message i describe the probolem that configure thinks it is cross compiling. when i manually changt the configure file to avoid this test, i get the next error configure output: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! config.log configure:6493: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/servers/space/neuwirt h/src/mysql-3.23.37/include -DHAVE_RWLOCK_T conftest.c 15 configure:6516: checking size of char configure:6535: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/servers/spac e/neuwirth/src/mysql-3.23.37/include -DHAVE_RWLOCK_T conftest.c -lz -lcrypt -l gen -lsocket -lnsl -lm -lpthread -lthread 15 configure: failed program was: #line 6524 configure #include confdefs.h #include stdio.h main() { FILE *f=fopen(conftestval, w); if (!f) exit(1); fprintf(f, %d\n, sizeof(char)); exit(0); } i do have libm.a in /lib but when i create conftest.c manuallu abd compile it with the given command line only without redirection of the output i get: [sunsite@root:~/space/src/mysql-3.23.37] gcc -o conftest -O3 -DDBUG_OFF -DHAVE _CURSES_H -I/servers/space/neuwirth/src/mysql-3.23.37/include -DHAVE_RWLOCK_T co nftest.c -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread conftest.c: In function `main': conftest.c:3: `FILE' undeclared (first use in this function) conftest.c:3: (Each undeclared identifier is reported only once conftest.c:3: for each function it appears in.) conftest.c:3: `f' undeclared (first use in this function) since FILE is declared in include/dbug.h it seems that this compile rund does not find the header files in the include dir any advice? -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on solaris
checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 i am trying to install mysql 3.23.37 from source on solaris 2.7 on sparc. i managed to install the binary distribution, and it works, but it does not work with php4.0.4pl1 i suspect this is because there is no libmysql.so with the standard binary distribution, only a libmysql.a configure on my platform crashes. the first problem is that at a certain moment it thinks that it is cross compiling. i will send more error reports, because this is not the only problem this is what happens (icluded configure output and config.log checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking for bison... bison -y checking for pdftex... manual.pdf checking return type of sprintf... configure: error: can not run test program while cross compiling ltconfig:1654: gcc -cconftest.c 15 ltconfig:1657: eval /usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT] \)[ ][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' conftest.nm ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions confte st.c conftstm.o 15 configure:2250: checking for a BSD compatible install configure:2308: checking for bison configure:2341: checking for pdftex configure:2369: checking return type of sprintf -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: client side tool of MySQL
Have a look at urSQL -- http://www.urbanresearch.com/ursql On Tue, 24 Apr 2001, Hao Cheng wrote: Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering if there is any great client side tools of it, like the toad for oracle? actually I'm not expecting it to be that functional, but at least i wish it's better than the one in the mySQL package. Any input is greatly appreciated ! Hao - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: not configuring on solaris 2.7
What you might try looking at is your environment variable $LD_LIBRARY_PATH. If you don't have it in your environment, set it up with all the usual lib places i.e /lib:/usr/lib:/usr/local/lib:/usr/share/lib:/usr/local/share/lib and so one. I think that this should clear up your problem with cross-compiling. Ed On Wed, 25 Apr 2001, Erich Neuwirth wrote: solaris 2.7 + gcc 2.95.2 mysql 3.23.37 in my last message i describe the probolem that configure thinks it is cross compiling. when i manually changt the configure file to avoid this test, i get the next error configure output: checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! config.log configure:6493: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/servers/space/neuwirt h/src/mysql-3.23.37/include -DHAVE_RWLOCK_T conftest.c 15 configure:6516: checking size of char configure:6535: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/servers/spac e/neuwirth/src/mysql-3.23.37/include -DHAVE_RWLOCK_T conftest.c -lz -lcrypt -l gen -lsocket -lnsl -lm -lpthread -lthread 15 configure: failed program was: #line 6524 configure #include confdefs.h #include stdio.h main() { FILE *f=fopen(conftestval, w); if (!f) exit(1); fprintf(f, %d\n, sizeof(char)); exit(0); } i do have libm.a in /lib but when i create conftest.c manuallu abd compile it with the given command line only without redirection of the output i get: [sunsite@root:~/space/src/mysql-3.23.37] gcc -o conftest -O3 -DDBUG_OFF -DHAVE _CURSES_H -I/servers/space/neuwirth/src/mysql-3.23.37/include -DHAVE_RWLOCK_T co nftest.c -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread conftest.c: In function `main': conftest.c:3: `FILE' undeclared (first use in this function) conftest.c:3: (Each undeclared identifier is reported only once conftest.c:3: for each function it appears in.) conftest.c:3: `f' undeclared (first use in this function) since FILE is declared in include/dbug.h it seems that this compile rund does not find the header files in the include dir any advice? -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
solaris again
gcc -o conftest -O3 -DHAVE_CURSES_H -I/servers/space/neuwirth/src/mysql-3.23.37/include/ -DHAVE_RWLOCK_T conftest.c -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread In file included from /usr/include/stdio.h:23, from conftest.c:4: /usr/include/sys/va_list.h: In function `main': /usr/include/sys/va_list.h:26: storage class specified for parameter `__va_list' ok, no i managed to get the includes in the test file right. when configure tries to compile the following conftest.c i get the following problems: main() #include confdefs.h #include stdio.h { FILE *f=fopen(conftestval, w); if (!f) exit(1); fprintf(f, %d\n, sizeof(char)); exit(0); } In file included from /usr/include/stdio.h:24, from conftest.c:4: /usr/include/stdio_tag.h:21: storage class specified for parameter `__FILE' In file included from /usr/include/stdio.h:25, from conftest.c:4: /usr/include/stdio_impl.h:22: storage class specified for parameter `ssize_t' /usr/include/stdio_impl.h:44: parse error before `ssize_t' /usr/include/stdio_impl.h:44: warning: no semicolon at end of struct or union /usr/include/stdio_impl.h:22: declaration for parameter `ssize_t' but no such pa rameter /usr/include/stdio_tag.h:21: parameter `__FILE' has incomplete type /usr/include/stdio_tag.h:21: declaration for parameter `__FILE' but no such para meter /usr/include/sys/va_list.h:26: declaration for parameter `__va_list' but no such parameter conftest.c:6: `FILE' undeclared (first use in this function) conftest.c:6: (Each undeclared identifier is reported only once conftest.c:6: for each function it appears in.) conftest.c:6: `f' undeclared (first use in this function) here is the relevant stdio_impl.h /* * Copyright (c) 1998 by Sun Microsystems, Inc. * All rights reserved. */ #ifndef _STDIO_IMPL_H #define _STDIO_IMPL_H #pragma ident @(#)stdio_impl.h 1.7 98/04/17 SMI #include sys/isa_defs.h #ifdef __cplusplus extern C { #endif #ifndef _SSIZE_T #define _SSIZE_T #if defined(_LP64) || defined(_I32LPx) typedef longssize_t;/* size of something in bytes or -1 */ #else typedef int ssize_t;/* (historical version) */ #endif #endif /* !_SSIZE_T */ #ifdef _LP64 #ifndef _FILE64_H struct __FILE_TAG { long__pad[16]; }; #endif /* _FILE64_H */ #else struct __FILE_TAG /* needs to be binary-compatible with old versions */ { #ifdef _STDIO_REVERSE unsigned char *_ptr; /* next character from/to here in buffer */ ssize_t _cnt; /* number of available characters in buffer */ #else ssize_t _cnt; /* number of available characters in buffer */ unsigned char *_ptr; /* next character from/to here in buffer */ #endif unsigned char *_base; /* the buffer */ unsigned char _flag; /* the state of the stream */ unsigned char _file; /* UNIX System file descriptor */ unsigned__orientation:2; /* the orientation of the stream */ unsigned__filler:6; }; #endif /* _LP64 */ #ifdef __cplusplus } #endif #endif /* _STDIO_IMPL_H */ -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris 2.7 issues
Hello, I have made several attempts at compiling and installing MySQL 3.23.36 and MySQL++ 1.7.8 on Solaris 2.7 Ultra Sparc. I have included the latest versions of GNU binutils, libtool, make, gcc as indicated in the documentation in the proper path. I have tried using environment variable settings CFLAGS=-O6 dhave_curses_h, CXXFLAGS=-O6 -felide-constructors -fno-exceptions -fno-rtti -dhave_curses_h, CC=gcc, CXX=gcc I continue to get ld fatal errors during the ./configure. I am running out of ideas. My questions are ... have these products ever been installed on this type of platform ? If so, what is recommended in terms of ./configure options, environment variable settings, tools/utilities, etc., or other prerequisites in order to install these products. Any assistance will be greatly appreciated. Cheers
directory confusion when installing mysql?
Hi everyone, I tried to install mysql (v3.23.30-gamma) on a SuSE Linux 7.1. Everything seems to work fine, but whenever I start the safe_mysqld, it ends after few seconds. I did install the databases, but there seems to be a problem with the directory-structure - however I have no idea how I ran into it and how to resolve it. Maybe that helps you understand my problem: I did: mysql_install_db that worked fine. I do: ./bin/safe_mysqld --user=mysql I get: Starting mysql daemon with databases from /var/lib/mysql mysqld ended. so its not running. I look in /var/lib/mysql/bioz3-visit1.err and it says: 010424 18:06:10 mysqld started /usr/sbin/mysqld: File './bioz3-visit1-bin.index' not found (Errcode: 13) 010424 18:06:11 Could not use bioz3-visit1-bin for logging (error 13) 010424 18:06:11 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010424 18:06:11 mysqld ended But host.frm exists, it is in /var/lib/mysql/host.frm _and_ in /var/lib/mysql/mysql/host.frm So, the problem is easy: Something is screwed with my directories. However I can not figure out 1) how this happened (I did a standart installation under YAST without any special wishes about directories or whatever) 2) more importantly, HOW DO I GET MYSQL RUNNING !!!??? Please, help me if you can. I really don't know what to do... Any idea what to do? Which information do you need to help me? I have close to zero experience with SQL, so any help is greatly appreciated! Many thanks for your time!! Clemens -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C++ API
I would like to know where I can find examples and documentations about C++ mysql API's, I want create a class for access to connection.
UPDATE :-(
database,sql,query Hi everybody, i have 2 tables 1) test - id_test - country_name - etc... 2) country - id_country - contry_name i want to join this 2 tables in case of deuce of the country_name and update test.id_test with the value of country.id_country i try tis syntax: update test,country set id = country.id_country where test.country_name = country.country_name but it doesn't works ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: directory confusion when installing mysql?
chown -R mysql /var/lib/mysql [EMAIL PROTECTED] wrote: Hi everyone, I tried to install mysql (v3.23.30-gamma) on a SuSE Linux 7.1. Everything seems to work fine, but whenever I start the safe_mysqld, it ends after few seconds. I did install the databases, but there seems to be a problem with the directory-structure - however I have no idea how I ran into it and how to resolve it. Maybe that helps you understand my problem: I did: mysql_install_db that worked fine. I do: ./bin/safe_mysqld --user=mysql I get: Starting mysql daemon with databases from /var/lib/mysql mysqld ended. so its not running. I look in /var/lib/mysql/bioz3-visit1.err and it says: 010424 18:06:10 mysqld started /usr/sbin/mysqld: File './bioz3-visit1-bin.index' not found (Errcode: 13) 010424 18:06:11 Could not use bioz3-visit1-bin for logging (error 13) 010424 18:06:11 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010424 18:06:11 mysqld ended But host.frm exists, it is in /var/lib/mysql/host.frm _and_ in /var/lib/mysql/mysql/host.frm So, the problem is easy: Something is screwed with my directories. However I can not figure out 1) how this happened (I did a standart installation under YAST without any special wishes about directories or whatever) 2) more importantly, HOW DO I GET MYSQL RUNNING !!!??? Please, help me if you can. I really don't know what to do... Any idea what to do? Which information do you need to help me? I have close to zero experience with SQL, so any help is greatly appreciated! Many thanks for your time!! Clemens -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C++ API
Hi! Take a look at MySQL++ page on www.mysql.com Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on linux redhat v.7
On Wed, 25 Apr 2001, george wrote: rpm -ivh mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.i386.rpm Better approach would be to use the update switch. rpm -Uvh the output says: file /usr/bin/safe_mysqld from install of mysql-3.23-36-1 conflicts with file from package mysql-server 3.23.22-6 Seems that you have an earlier version of mysql installed. This is telling you that you have mysql 3.23.22-6 installed, and that you're replacing files that it needs. Problem might be solved using the update switch as I listed above to do the update. i then did rpm -e mysql Redhat's packages are rarely named just the application name. You can see what the exact package name is by issuing the following command: rpm -qa|grep -i mysql This will report back to you any packages containing the word mysql (upper or lower case) in the package name. Then you rpm -e full-package-name to uninstall it. which produced the output: error. package mysql is not installed See above for more details. Hope this helps. Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash with signal 11.
Heikki, Mysql-3.23.36, Solaris 2.8. My mysqld crashes when I create a TEMPORARY InnoDB table from the console if I do a SELECT COUNT(*) before exiting from the console. No problem with MyISAM tables, no problem with no TEMPORARY table. mysql CREATE TEMPORARY TABLE mybuffer ( id int unsigned not null primary key, date datetime not null, data text, index id_date (date) ) TYPE=INNOBASE; Query OK, 0 rows affected (0.04 sec) mysql select count(*) from mybuffer; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) mysql Bye Then mysql crashes and from the error log : mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010425 18:28:29 mysqld restarted Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections === The signal 11 is received just after the Bye. mysqld crashes only if I do a SELECT count(*) FROM mybuffer before exiting from the console (closing the connection). If I just create the table and exit, no problem. If I create the table and do for example desc mybuffer before exiting, no problem. But if I create the table, do anything else, then do SELECT count(*) FROM mybuffer before exiting ... mysqld crashes with signal 11. Regards, 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
mysql on linux redhat v.7
My machine is intel 55mhz 256mb ram 2x 10gig HD on SCSI OS = linux 7 server installtion with database server support. i downloaded : mysql-3.23.36-1.i386.rpm AND mysql-client-3.23.36-1.i386.rpm and placed them in /home/george/rpm I did: rpm -ivh mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.i386.rpm the output says: file /usr/bin/safe_mysqld from install of mysql-3.23-36-1 conflicts with file from package mysql-server 3.23.22-6 (twice) i then did rpm -e mysql which produced the output: error. package mysql is not installed after i did a force on my rp command rpm -i --force mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.i386.rpm both packages did install. anybody any suggestions where the errors came from? regards george - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 :-(
Stephan, You can not join within an update clause - 'update' supports one table only. regards, P On Wed, 25 Apr 2001, Stéphane PRIN wrote: database,sql,query Hi everybody, i have 2 tables 1) test - id_test - country_name - etc... 2) country - id_country - contry_name i want to join this 2 tables in case of deuce of the country_name and update test.id_test with the value of country.id_country i try tis syntax: update test,country set id = country.id_country where test.country_name = country.country_name but it doesn't works ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERT PROBLEM
Hello all I am running linux mandrake with Mysql vers 3.23.23-beta, for pc-linux-gnu on i686 I've had a problem with recieving to many connections which i am working on but my MAIN problem currently is that it will not allow me to insert into tables. I cleared out all the connections and can query the database and recieve the answers.. but when i do a standard insert into one of the tables it just seems to hang there.. its like it catches a lock or something. This is an old table and these are the same query's its been using for over a year.. other then fixing the table with myisamchk nothing has changed. The table needed to be fixed due to the too many connections error which currupted it appearantly. Any idea's why it would be hanging on an insert statement? Ter -- Join the growing community of AngelHaven.com. Sign up for your free AngelHaven E-mail Today... Visit us at http://www.AngelHaven.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: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash with signal 11.
Alex, MySQL obviously tries to drop the table when you exit from the mysql client, since the table is temporary. I have not tested TEMPORARY tables. I just tried on prerelease .38 and it does not work in that version either. I will fix it in .38 if Monty has not yet put out it. Regards, Heikki At 06:40 PM 4/25/01 +0200, you wrote: Heikki, Mysql-3.23.36, Solaris 2.8. My mysqld crashes when I create a TEMPORARY InnoDB table from the console if I do a SELECT COUNT(*) before exiting from the console. No problem with MyISAM tables, no problem with no TEMPORARY table. mysql CREATE TEMPORARY TABLE mybuffer ( id int unsigned not null primary key, date datetime not null, data text, index id_date (date) ) TYPE=INNOBASE; Query OK, 0 rows affected (0.04 sec) mysql select count(*) from mybuffer; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) mysql Bye Then mysql crashes and from the error log : mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010425 18:28:29 mysqld restarted Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections === The signal 11 is received just after the Bye. mysqld crashes only if I do a SELECT count(*) FROM mybuffer before exiting from the console (closing the connection). If I just create the table and exit, no problem. If I create the table and do for example desc mybuffer before exiting, no problem. But if I create the table, do anything else, then do SELECT count(*) FROM mybuffer before exiting ... mysqld crashes with signal 11. Regards, 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
SHOW FIELDS using ADO/VB?
Hello Everyone, I'm trying write a small Dump application to Dump a MySQL DB similar to MySQLDump.exe because I don't like shelling out to the exe (DOS windows showing, etc.). However, on some tables, I get an EOF before it reached the end. Anyone ever do this? Thanks, Lee
Updating frequency.
I have a Java program accesing MySql using JDBC. In that program, I update very frequently the database. However, I'd like to know if there is some way to check the real update frequency in the MySQL database. Is there some application or mechanism to know that?. Thanks a lot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash
Heikki sent his response to the wrong address... -- Forwarded Message -- Subject: Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash Date: 25 Apr 2001 17:18:06 - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Alex, MySQL obviously tries to drop the table when you exit from the mysql client, since the table is temporary. I have not tested TEMPORARY tables. I just tried on prerelease .38 and it does not work in that version either. I will fix it in .38 if Monty has not yet put out it. Regards, Heikki At 06:40 PM 4/25/01 +0200, you wrote: Heikki, Mysql-3.23.36, Solaris 2.8. My mysqld crashes when I create a TEMPORARY InnoDB table from the console if I do a SELECT COUNT(*) before exiting from the console. No problem with MyISAM tables, no problem with no TEMPORARY table. mysql CREATE TEMPORARY TABLE mybuffer ( id int unsigned not null primary key, date datetime not null, data text, index id_date (date) ) TYPE=INNOBASE; Query OK, 0 rows affected (0.04 sec) mysql select count(*) from mybuffer; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) mysql Bye Then mysql crashes and from the error log : mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 010425 18:28:29 mysqld restarted Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections === The signal 11 is received just after the Bye. mysqld crashes only if I do a SELECT count(*) FROM mybuffer before exiting from the console (closing the connection). If I just create the table and exit, no problem. If I create the table and do for example desc mybuffer before exiting, no problem. But if I create the table, do anything else, then do SELECT count(*) FROM mybuffer before exiting ... mysqld crashes with signal 11. Regards, Alex. --- -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
starting mysqld failed
Description: mysqld daemon fails when starting with databases from /var/lib/mysql there's only the 'mysql' and 'test' database and it still fails. I used a previus database and it suddenly disapeared. It was deleted without reason. on a second try even the 'mysql' and 'test' databases were deleted. How-To-Repeat: I don't know how to repeat it. everything is installed and configured to run. Fix: Submitter-Id: submitter ID Originator:root Organization: Nred, Inc. MySQL support: none Synopsis: mysqld failed at startup and deleted databases Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.32 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu on i6 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.32-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 min 26 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.008 Environment: System: Linux server 2.4.0 #2 SMP Fri Apr 20 07:16:22 CDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O2 -m486' CXX='c++' CXXFLAGS='-O2 -m486' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1382179 Jan 19 00:14 /lib/libc.so.6 -rw-r--r--1 root root 2585872 Jan 19 00:14 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 19 00:14 /usr/lib/libc.so -rw-r--r--1 root root 851660 Jan 19 05:02 /usr/lib/libc-client.a lrwxrwxrwx1 root root 19 Apr 20 12:36 /usr/lib/libc-client.so - libc-client.so.2000 -rwxr-xr-x1 root root 714876 Jan 19 05:02 /usr/lib/libc-client.so.2000 Configure command: ./configure --enable-shared --enable-assembler --infodir=/usr/share/info --libdir=/usr/lib --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug --datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex --with-unix-socket-path=/var/lib/mysql/mysql.sock --without-berkeley-db - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug on web pages
I tried to add a comment to your web page. got error : Error: query insert into web.user(email,pass,firstname,lastname,address,city,state,zipcode,id,phone,cell,fax,company,show_email,created) values ('[EMAIL PROTECTED]','passwd','Yusuf ','Incekara','Omeraga Mah No : 87','zmit/KOCAEL','KO','41100','TR','+90 262 332 4530','+90 262 332 4530','+90 262 332 4530','Avukatpro Limited Sirketi','Y',now()) failed: Unknown column 'id' in 'field list'
Help modify existing column to be Primary Key
I used Access (sorry) to develop a db design. I then used ODBC to export it to MySQL. The tables all lost their primary key definitions. Now I need to set them back to be a primary key. I have tried: ALTER TABLE def_categories MODIFY ID PRIMARY KEY Any help is appreciated! Sean Tibbetts Web Technologies Group Step by step walk the thousand-mile road. Miyamoto Musashi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.36 STILL Having Major Problems
taken from the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO W_PROCESSLIST SHOW PROCESSLIST shows you which threads are running. You can also get this information using the mysqladmin processlist command. If you have the process privilege, you can see all threads. Otherwise, you can see only your own threads. See section 7.27 KILL Syntax. If you don't use the FULL option, then only the first 100 characters of each query will be shown. This command is very useful if you get the 'too many connections' error message and want to find out what's going on. MySQL reserves one extra connection for a client with the Process_priv privilege to ensure that you should always be able to login and check the system (assuming you are not giving this privilege to all your users). I believe you will want to do the second paragraph. regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 11:21 AM Subject: MySQL 3.23.36 STILL Having Major Problems OS: Red Hat Linux 6.0 / Intel 1GB RAM MySQL 3.23.36 PHP4.0.4PL1 Linux kernel 2.4.3 Using the my.cnf for medium sized sites mySQL starts with safe_mysqld and there are three threads running. Queries come in and out and it's quite fast. Using mysqladmin proc status shows no queries running. After about 12 hours, the number of mySQL threads visible in ps have shot to about 75. At this point the server reports No More Connections, both through PHP and from mysqladmin. What's going on here? I can't figure it out. I can't even get in to diagnose the problem, since the server is out of connections. 99% of my queries are SELECT's. It sounds like something is hanging on to connections and not returning them... I'm using mysql_connect() in the PHP scripts. Any ideas? This has taken my Web site out about 5 or 6 times in the last two weeks. It's no fun. Anything anyone could do to help would be great. Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.36 STILL Having Major Problems
Running mysqladmin -p proc reports: too many connections... That's why I can't diagnose it. I'm logging in as root. How else would I get process_priv? I haven't changed any parameters so I should be able to get in but I cannot. What am I doing wrong? Hunter From: Andrew Schmidt [EMAIL PROTECTED] Date: Wed, 25 Apr 2001 14:46:48 -0400 To: Hunter Hillegas [EMAIL PROTECTED], mySQL List [EMAIL PROTECTED] Subject: Re: MySQL 3.23.36 STILL Having Major Problems taken from the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO W_PROCESSLIST SHOW PROCESSLIST shows you which threads are running. You can also get this information using the mysqladmin processlist command. If you have the process privilege, you can see all threads. Otherwise, you can see only your own threads. See section 7.27 KILL Syntax. If you don't use the FULL option, then only the first 100 characters of each query will be shown. This command is very useful if you get the 'too many connections' error message and want to find out what's going on. MySQL reserves one extra connection for a client with the Process_priv privilege to ensure that you should always be able to login and check the system (assuming you are not giving this privilege to all your users). I believe you will want to do the second paragraph. regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 11:21 AM Subject: MySQL 3.23.36 STILL Having Major Problems OS: Red Hat Linux 6.0 / Intel 1GB RAM MySQL 3.23.36 PHP4.0.4PL1 Linux kernel 2.4.3 Using the my.cnf for medium sized sites mySQL starts with safe_mysqld and there are three threads running. Queries come in and out and it's quite fast. Using mysqladmin proc status shows no queries running. After about 12 hours, the number of mySQL threads visible in ps have shot to about 75. At this point the server reports No More Connections, both through PHP and from mysqladmin. What's going on here? I can't figure it out. I can't even get in to diagnose the problem, since the server is out of connections. 99% of my queries are SELECT's. It sounds like something is hanging on to connections and not returning them... I'm using mysql_connect() in the PHP scripts. Any ideas? This has taken my Web site out about 5 or 6 times in the last two weeks. It's no fun. Anything anyone could do to help would be great. Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.36 STILL Having Major Problems
Who are web users logging in as? Take away their process_priv if they have it (unless they need it). Also, what version of php are you running? As old versions contained leaks in connections In the change log for php 4.0.4 cut Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - they weren't properly closing the SQL connections (Zeev) cut regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL PROTECTED]; mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 3:04 PM Subject: Re: MySQL 3.23.36 STILL Having Major Problems Running mysqladmin -p proc reports: too many connections... That's why I can't diagnose it. I'm logging in as root. How else would I get process_priv? I haven't changed any parameters so I should be able to get in but I cannot. What am I doing wrong? Hunter From: Andrew Schmidt [EMAIL PROTECTED] Date: Wed, 25 Apr 2001 14:46:48 -0400 To: Hunter Hillegas [EMAIL PROTECTED], mySQL List [EMAIL PROTECTED] Subject: Re: MySQL 3.23.36 STILL Having Major Problems taken from the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO W_PROCESSLIST SHOW PROCESSLIST shows you which threads are running. You can also get this information using the mysqladmin processlist command. If you have the process privilege, you can see all threads. Otherwise, you can see only your own threads. See section 7.27 KILL Syntax. If you don't use the FULL option, then only the first 100 characters of each query will be shown. This command is very useful if you get the 'too many connections' error message and want to find out what's going on. MySQL reserves one extra connection for a client with the Process_priv privilege to ensure that you should always be able to login and check the system (assuming you are not giving this privilege to all your users). I believe you will want to do the second paragraph. regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 11:21 AM Subject: MySQL 3.23.36 STILL Having Major Problems OS: Red Hat Linux 6.0 / Intel 1GB RAM MySQL 3.23.36 PHP4.0.4PL1 Linux kernel 2.4.3 Using the my.cnf for medium sized sites mySQL starts with safe_mysqld and there are three threads running. Queries come in and out and it's quite fast. Using mysqladmin proc status shows no queries running. After about 12 hours, the number of mySQL threads visible in ps have shot to about 75. At this point the server reports No More Connections, both through PHP and from mysqladmin. What's going on here? I can't figure it out. I can't even get in to diagnose the problem, since the server is out of connections. 99% of my queries are SELECT's. It sounds like something is hanging on to connections and not returning them... I'm using mysql_connect() in the PHP scripts. Any ideas? This has taken my Web site out about 5 or 6 times in the last two weeks. It's no fun. Anything anyone could do to help would be great. Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.36 STILL Having Major Problems
I'm running PHP4.0.4pl1 - the latest version. Web users are logging in as a user called dummy. I guess I'll have to look in the manual to see how to remove the process_priv(). I don't think they need it... Thanks, Hunter From: Andrew Schmidt [EMAIL PROTECTED] Date: Wed, 25 Apr 2001 15:13:24 -0400 To: Hunter Hillegas [EMAIL PROTECTED], mySQL List [EMAIL PROTECTED] Subject: Re: MySQL 3.23.36 STILL Having Major Problems Who are web users logging in as? Take away their process_priv if they have it (unless they need it). Also, what version of php are you running? As old versions contained leaks in connections In the change log for php 4.0.4 cut Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - they weren't properly closing the SQL connections (Zeev) cut regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: Andrew Schmidt [EMAIL PROTECTED]; mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 3:04 PM Subject: Re: MySQL 3.23.36 STILL Having Major Problems Running mysqladmin -p proc reports: too many connections... That's why I can't diagnose it. I'm logging in as root. How else would I get process_priv? I haven't changed any parameters so I should be able to get in but I cannot. What am I doing wrong? Hunter From: Andrew Schmidt [EMAIL PROTECTED] Date: Wed, 25 Apr 2001 14:46:48 -0400 To: Hunter Hillegas [EMAIL PROTECTED], mySQL List [EMAIL PROTECTED] Subject: Re: MySQL 3.23.36 STILL Having Major Problems taken from the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO W_PROCESSLIST SHOW PROCESSLIST shows you which threads are running. You can also get this information using the mysqladmin processlist command. If you have the process privilege, you can see all threads. Otherwise, you can see only your own threads. See section 7.27 KILL Syntax. If you don't use the FULL option, then only the first 100 characters of each query will be shown. This command is very useful if you get the 'too many connections' error message and want to find out what's going on. MySQL reserves one extra connection for a client with the Process_priv privilege to ensure that you should always be able to login and check the system (assuming you are not giving this privilege to all your users). I believe you will want to do the second paragraph. regards, -- Andrew - Original Message - From: Hunter Hillegas [EMAIL PROTECTED] To: mySQL List [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 11:21 AM Subject: MySQL 3.23.36 STILL Having Major Problems OS: Red Hat Linux 6.0 / Intel 1GB RAM MySQL 3.23.36 PHP4.0.4PL1 Linux kernel 2.4.3 Using the my.cnf for medium sized sites mySQL starts with safe_mysqld and there are three threads running. Queries come in and out and it's quite fast. Using mysqladmin proc status shows no queries running. After about 12 hours, the number of mySQL threads visible in ps have shot to about 75. At this point the server reports No More Connections, both through PHP and from mysqladmin. What's going on here? I can't figure it out. I can't even get in to diagnose the problem, since the server is out of connections. 99% of my queries are SELECT's. It sounds like something is hanging on to connections and not returning them... I'm using mysql_connect() in the PHP scripts. Any ideas? This has taken my Web site out about 5 or 6 times in the last two weeks. It's no fun. Anything anyone could do to help would be great. Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
libm.a?
Hi there, I tried to build MySQL for my Sol. 2.7 for x86, and when I run the configure, I got error message says that the size of char is zero, and maybe because I don't have the libm.a installed. I checked my system, I have both libm.a and libm.so installed in both /usr/lib and /lib, so what's wrong here? How can I get this char size check passed? Thanks a lot! Yue - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to config the client installation
Hi, I installed the Win32 static binary of MySQL GUI 1.7.4-2. client version on one computer. I have also MySQL 3.23.37 mysqld-nt server installed on another computer. I can ping each other. I tried to connect from client to server, but failed. Error shows: Access denied for user: 'administrator@JOHND' (Using password: YES) Here is server side my.ini file: #This File was made using the WinMySQLadmin 1.1 Tool #4/24/2001 12:04:36 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=D:\MySQL #bind-address=208.199.176.191 datadir=D:\MySQL\data #language=D:\MySQL\share\your language directory #slow query log#= #tmpdir#= port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=D:/MySQL/bin/mysqld-nt.exe# I tried to replace the / instead of \, it can't do it. user=administrator@johnd # This is the computer that client software installed. password=password Could you tell me how to configue these on both side to get connect? Thank you very much. Regards, John Ding
PATH
Hi Everybody! I'm installing Mysql on a solaris 2.7 sparc machine. In the mysql manual is this passage: You will find several files and subdirectories in the mysql directory. The most important for installation purposes are the `bin' and `scripts' subdirectories. `bin' This directory contains client programs and the server You should add the full pathname of this directory to your PATH environment variable so that your shell finds the MySQL programs properly. Question: How do I add the full path name to my PATH environment variable? The url provided was of much help. Many thanks everybody! simon __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Can't Start Mysqld
Hey I installed the MySQL pkg from http://pkg.nl.cobalt.com a couple of weeks ago and I went through steps just like on the site. That all went ok but since then I have been busy and forgot what I changed the root pass to. Is there any way to recover this? If not what is the best thing to do to get mysql back up and running. Thanks for the help. Ok I have tried both things on this page and both don't work. I can't seem to get mysql to start. http://list.cobalt.com/pipermail/cobalt-users/2000-October/023700.html I have also tried other suggestions given to me by others (ie changing permissions) but still the same thing Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended I don't have any databases setup yet so I am not worried about loseing them. Juse worried about screwing Chiliasp up. Anything will help. Thanks again Todd Todd Woolums Wescris Solutions http://www.wescris.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mm.mysql-2.0.4 driver support for jdbc2.0 Optional package
Hello I am using mysql with jboss. Jboss server requires the db driver to support jdbc2.0 Optional package support, to facilitate transaction. Can you comment on this please? Thanks ramesh _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.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
user-table list with mySql
Hello! I am to do a tool working with different kind of database. Developping at first for Oracle this tool use the command: SELECT TABLE_NAME FROM USER_TABLES in order to get generically tables in the databse used by the user. Is there a way to do the same with mySql, and if yes, how? Thanx Archi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PATH
I find it humorous that you're Email address is perl_programmer2001, yet you don't know how to set your PATH variable... Type echo $PATH and see if /usr/local/bin is included in it. If so, you can do what I usually do, which is to add 'symbolic links' from there to programs that I want to be able to execute easily. cd /usr/local/bin ln -s /usr/local/mysql/bin/msyql OR you can use the 'standard' method of: PATH=$PATH:/usr/local/mysql/bin Simon Chan wrote: Hi Everybody! I'm installing Mysql on a solaris 2.7 sparc machine. In the mysql manual is this passage: You will find several files and subdirectories in the mysql directory. The most important for installation purposes are the `bin' and `scripts' subdirectories. `bin' This directory contains client programs and the server You should add the full pathname of this directory to your PATH environment variable so that your shell finds the MySQL programs properly. Question: How do I add the full path name to my PATH environment variable? The url provided was of much help. Many thanks everybody! simon __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
Fw: Solaris 2.7 issues
The error which occurs during ./configure is: ld: fatal: library -ldir: not found and ld: fatal: Symbol referencing errors By the way, what should the LD_RUN_PATH environment variable be set as. Signed, Still Clueless ;-{ - Original Message - From: James Bonham To: [EMAIL PROTECTED] Sent: Wednesday, April 25, 2001 9:06 AM Subject: Solaris 2.7 issues Hello, I have made several attempts at compiling and installing MySQL 3.23.36 and MySQL++ 1.7.8 on Solaris 2.7 Ultra Sparc. I have included the latest versions of GNU binutils, libtool, make, gcc as indicated in the documentation in the proper path. I have tried using environment variable settings CFLAGS=-O6 dhave_curses_h, CXXFLAGS=-O6 -felide-constructors -fno-exceptions -fno-rtti -dhave_curses_h, CC=gcc, CXX=gcc I continue to get ld fatal errors during the ./configure. I am running out of ideas. My questions are ... have these products ever been installed on this type of platform ? If so, what is recommended in terms of ./configure options, environment variable settings, tools/utilities, etc., or other prerequisites in order to install these products. Any assistance will be greatly appreciated. Cheers
How Stable is InnoDB / BDB
I am in the process of building a database/php app that is going to require transaction support. Which table type should I go with? BerkeleyDB or Innobase?? It looks like the InnoDB has some neat features like row-level locking, etc. but is it stable enough for a production system, or should it be considered Alpha?? Thanks! Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.27
On Wed, Apr 25, 2001 at 04:12:39PM -0600, Devin Atencio wrote: I was wondering where do I find out the changes that were made from release to release with MySQL such as changes made from 3.23.26 to 3.23.27? They are documented in the MySQL manual. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.27
I was wondering where do I find out the changes that were made from release to release with MySQL such as changes made from 3.23.26 to 3.23.27? /'^'\ ( o o ) --oOOO--(_)--OOOo Devin Atencio ArosNet Systems Administration .oooO EMail: [EMAIL PROTECTED] ( ) Oooo. \ (( )- \_)) / (_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New revision of MySQL Myths Debunked
Since the original posting on this list, I've received many useful submissions and commentary from a variety of sources. Fortunately, I've even been able to include some of it. :) Here's the latest version: http://netgraft.com/~mbac/research/mysqlmyths.html I appreciate all feedback. -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help modify existing column to be Primary Key
On 25-Apr-01 [EMAIL PROTECTED] wrote: I used Access (sorry) to develop a db design. I then used ODBC to export it to MySQL. The tables all lost their primary key definitions. Now I need to set them back to be a primary key. I have tried: ALTER TABLE def_categories MODIFY ID PRIMARY KEY ALTER TABLE def_categories add key PRIMARY KEY(ID) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
File Not Found Error
Sorry to be such an everything newbie. Perhaps this a unix error and not MySQL but a simple Describe statement reports that a *.frm file is missing, yet that file exists in the same folder. What could be wrong? Sorry about the long LS. TIA, John ... # mysql -p mysql Didn't find any fields in table 'adminedit' Didn't find any fields in table 'levelone' Didn't find any fields in table 'members' mysql show tables; +-+ | Tables_in_mysql | +-+ | adminedit | | columns_priv| | db | | func| | host| | levelone| | members | | tables_priv | | user| +-+ 9 rows in set (0.00 sec) mysql describe adminedit; ERROR 1017: Can't find file: './mysql/adminedit.frm' (errno: 13) mysql describe levelone; ERROR 1017: Can't find file: './mysql/levelone.frm' (errno: 13) mysql describe members; ERROR 1017: Can't find file: './mysql/members.frm' (errno: 13) - [root mysql]# pwd /var/lib/mysql/mysql [root mysql]# ls -la total 115 drwx--x--x 2 mysqlroot 1024 Apr 25 16:43 . drwxr-xr-x 4 mysqlroot 1024 Apr 25 13:15 .. -rw-rw 1 adminadmin 40 Mar 28 08:30 adminedit.ISD -rw-rw 1 adminadmin2048 Mar 28 08:30 adminedit.ISM -rw-rw 1 adminadmin8594 Dec 7 17:55 adminedit.frm ## I see it here -rw--- 1 adminadmin 0 Nov 8 05:25 columns_priv.ISD -rw--- 1 adminadmin1024 Nov 8 05:25 columns_priv.ISM -rw--- 1 adminroot0 Apr 25 13:15 columns_priv.MYD -rw--- 1 adminroot 1024 Apr 25 13:15 columns_priv.MYI -rw--- 1 adminadmin8778 Nov 8 05:25 columns_priv.frm -rw--- 1 adminadmin 238 Nov 8 05:25 db.ISD -rw--- 1 adminadmin3072 Nov 8 05:25 db.ISM -rw--- 1 adminroot 302 Apr 25 13:15 db.MYD -rw--- 1 adminroot 3072 Apr 25 13:15 db.MYI -rw--- 1 adminadmin8982 Nov 8 05:25 db.frm -rw--- 1 adminadmin 0 Nov 8 05:25 func.ISD -rw--- 1 adminadmin1024 Nov 8 05:25 func.ISM -rw--- 1 adminroot0 Apr 25 13:15 func.MYD -rw--- 1 adminroot 1024 Apr 25 13:15 func.MYI -rw--- 1 adminadmin8641 Nov 8 05:25 func.frm -rw--- 1 adminadmin 0 Nov 8 05:25 host.ISD -rw--- 1 adminadmin1024 Nov 8 05:25 host.ISM -rw--- 1 adminroot0 Apr 25 13:15 host.MYD -rw--- 1 adminroot 1024 Apr 25 13:15 host.MYI -rw--- 1 adminadmin8958 Nov 8 05:25 host.frm -rw-rw 1 adminadmin 219 Mar 27 10:27 levelone.ISD -rw-rw 1 adminadmin2048 Mar 27 10:27 levelone.ISM -rw-rw 1 adminadmin8687 Dec 19 12:48 levelone.frm ## And here -rw-rw 1 adminadmin 788 Mar 28 11:03 members.ISD -rw-rw 1 adminadmin2048 Mar 28 11:03 members.ISM -rw-rw 1 adminadmin 10043 Mar 22 10:21 members.frm ## and here. -rw--- 1 adminadmin 0 Nov 8 05:25 tables_priv.ISD -rw--- 1 adminadmin1024 Nov 8 05:25 tables_priv.ISM -rw--- 1 adminroot0 Apr 25 13:15 tables_priv.MYD -rw--- 1 adminroot 1024 Apr 25 13:15 tables_priv.MYI -rw--- 1 adminadmin8877 Nov 8 05:25 tables_priv.frm -rw--- 1 adminadmin 535 Nov 13 04:33 user.ISD -rw--- 1 adminadmin2048 Nov 13 04:33 user.ISM -rw--- 1 adminroot 428 Apr 25 13:15 user.MYD -rw--- 1 adminroot 2048 Apr 25 13:15 user.MYI -rw--- 1 adminadmin9148 Nov 8 05:25 user.frm - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
*-bin.* files??
I haven't installed mysql from the scratch, but used a precompiled version that comes with my distribution. Since I've updated it I see some *-bin.* files grow steadily very huge. What are these files in my /var/lib/mysql directory good for? Some kind of journalling for replication? Do I really need them? How can I turn of the creation of these files? Can I rm them safely? Thanks Robert
Install question and an ERROR 1064 question
Hello, I'm running mysql 3.23.37 on a Debian potato install. I ran through the install from the mysql.com web site. Everything seems to work ok but I do have one question. When I run mysqladmin or mysql I have to put a ./ in front. I get a command not found if I don't. Is this correct behavior? I'm trying to run through a mysql/perl tutorial I found on a web site that produces a guestbook. When I enter this line: mysql -uroot -einsert into user(Host,User,Password) values('localhost','guestbook',password('guestbook') mysql after entering the previous lines fine, I get the following error: ./mysql -uroot -einsert into user(Host,User,Password) values('localhost','guestbook',password('guestbook') mysql ERROR 1064 at line 1: You have an error in your SQL syntax near 'user(Host,User,Password) values('localhost','guestbook',password('guestbook')' at line 1 I also tried this on mysql 3.23.36 with the same result. Any thoughts would be appreciated. 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
Porting data from MS-Access 2000 to MySQL
Hi, I have a database created with all data stored in Microsoft Access 2000. Can someone tell me what would be the easiest and fastest way to port all the data from MS-Access 2000 to MySQL. Any help in this regard would be highly appreciated. Thanks in advance -Ramanbr clear=allhrGet your FREE download of MSN Explorer at a href=http://explorer.msn.com;http://explorer.msn.com/abr/p
From Source to RPMs...
As I'm having a lot of problems with the source distro, I'm considering moving to your RPMs. The manual suggests that there are a lot of problems with Linux and threads, etc... and to use the prebuilt binaries if you can... I've been using a source distro for awhile. What do I have to do to install the RPMs? Any kind of prep? Hunter database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Syntax question
I have two table I need to join in a query. The second table needs to be join twice (I think) to the first. Details as follows (tables pared down)... Table games gameid hometeamid guestteamid Table team teamid sponsor I want a query to return game.gamid, team.sponsor (hometeam), team.sponsor (guestteam). can someone point me in the right direction for this please? Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Syntax question
On 26-Apr-01 [EMAIL PROTECTED] wrote: I have two table I need to join in a query. The second table needs to be join twice (I think) to the first. Details as follows (tables pared down)... Table games gameid hometeamid guestteamid Table team teamid sponsor I want a query to return game.gamid, team.sponsor (hometeam), team.sponsor (guestteam). can someone point me in the right direction for this please? select gameid,home.sponsor,guest.sponsor from games,team as home,team as guest where hometeamid=home.teamid and guestteamid=guest.teamid; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php