Two questions
Hi Q1: I've upgraded our mysql db from 3.23.43-1 to 3.23.46-1 on our Red Hat Linux 7.2 I used the binary rpm distribution. I had to keep our database up and running while I upgrading so I used the --force switch to upgrade the server (the old client always complained for dependecies problem). The database has been working well since then, but I can't complie the PHP because it sends a lot of error messages complaining to the libmysqlclient.a: /usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file': dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file' /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(.data+0x1701): first defined here /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o): In function `my_strnncoll_tis620': ctype-tis620.o(.text+0x244): multiple definition of `my_strnncoll_tis620' and so on. How can I query the version number of the libmysqlclient.a? I think something went wrong under the upgrading process. Q2: Because I used rpm to install the server I don't have mysql log. I found some great examples in the /usr/share/mysql/ but as I see it doesn't contain entries for logging. What should I write into the my.cnf to be able to see what's happen in our db? Thanks in advance! Regards Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using ActiveX on Delphi
Hello, Does MySQL handles the ActiveX controls on Delphi? I have an web page and I would like that the client's request that will come to the MySQL server to open the ActiveX control in Delphi and then the results to be returned back to the client. Thank you. Kind Regards, Marian Strejac, CRS Analyst - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Complient Certification
Hi all, I want to know is there any certification saying that a particular package/program is MySQL complient...? Thank You in advance. Yasela - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: READ LOCK Question.
Hi. On Thu, Dec 13, 2001 at 11:57:35AM +, [EMAIL PROTECTED] wrote: Hi all, This is in regard to setting up replication, I do not wish to shut down the master so I noticed I can do FLUSH TABLES WITH READ LOCK and then tar up the databases. I tried this on a non-critical machine and while the READ LOCK is on it does not deny operations on the database, just seems to cache them until I run UNLOCK TABLES. Correct. There is no timeout related to LOCKs. My worry is, how many commands can it spool like that? As much as your max_connection variable allows. I have to copy across a snapshot database to a slave that is about 700M and tarring is it up my take a while, You could copy it to another disk, which should be quite fast, release the lock and then tar the copied files. so I am worried about all those database operations queing up, should I be? Yes. Will mysql handle the waiting queries well? Not really. If you get a fair amount of traffic, max_connection will be reached soon. Bye, Benjamin. I include details on my setup at end. Regards, Fred. System Info: MySQL version - 3.23.40 OS - Linux 2.2.14 CPU - P3 550Mhz Memory - 128M [...] -- [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
query
Hello Sir, I am using mysql version 3.22(windows based). I wanted to know whether there is any tool to convert database of above version to the linux based mysql database. If so plz tell me where should I find such a tool. Thanking you waiting for reply Yogesh Deshmukh __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at 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
Re: Binary data with embedded nulls (mysql_real_escape_string problem).
On Fri, 14 Dec 2001, Ian Collins wrote: I am having difficulties with entering binary data from a c program. I have passed the string through mysql_real_escape_string. Post the C data then. However read on. . . . drop table if exists junk5; create table junk5 ( id int not null, primary key(id), s1 char(10) not null, i1 smallint not null ); insert junk5 values(1,'abc\0def\0gh', 2); insert junk5 values(2,'abc\\0def\\0gh', 3); insert junk5 values(3,'abc\\0def\0gh', 4); select * from junk5; By running this snippet, you will see that you need to double escape the null to get it in the database. No. What you are putting in the database is (character by character): 1 = 'a', 'b', 'c', 0, 'd' ... 2 = 'a', 'b', 'c', '\', '0', 'd' ... Proof: mysql select id, substring(s1, 1, 3) as first3, ascii(substring(s1, 4, 1)) as fourth, substring(s1, 5, 5) as remainder from junk5; ++++---+ | id | first3 | fourth | remainder | ++++---+ | 1 | abc| 0 | def | | 2 | abc| 92 | 0def\ | | 3 | abc| 92 | 0def | ++++---+ The 'problem' is in the output from the mysql program: it does not have a literal for null (in text); instead it seems to interpret it as end of text; this is probably because it is bound to the C zero-terminated strings model. Using the API you can get it right. -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Heap Tables
Hi. On Thu, Dec 13, 2001 at 03:50:01PM +0200, [EMAIL PROTECTED] wrote: is it possible to insert many rows into a heap table? Yes. By the way, why didn't you simply try out yourself? I'm not sure how from the documentation. The same way as with other table types. If not, are there other kinds of temporary tables that can be used? temporary tables are a special table property, which several table types can have (ISAM, MyISAM, HEAP). HEAP tables reside purely in memory (as long as the server runs or they are explicitly deleted), whereas TEMPORARY table are only visible for the current connection and will be dropped automatically when the connection is closed. http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/H/E/HEAP.html http://www.mysql.com/doc/T/e/Temporary_table_problems.html I need to enter 100 rows into a table and then select them with order by. do I need to create a table, select the records I want, insert them with (INSERT INTO) to the temp table and then select with ORDER BY? I'm pretty sure there is a simpler way. Sorry, I wasn't able to discern what you want to accomplish, so I cannot say if there is an easier way. Bye, Benjamin. P.S. the records I need to enter the tem table are from a script so I can't do it all at once in the DB, I have to create a temp table. thanks berber [...] -- [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
Transaction Safe Tables
Hi We want to create Transaction Safe tables in order to use the commit roolback options in MySql. How do I crate a Trasaction Safe table in MySql Thanks in Advance Ananth __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at 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
UNIQUE in InnoDB
I have found a problem with UNIQUE in InnoDB. Example: mysql CREATE TABLE b ( - idB int(11) NOT NULL auto_increment, - valor int(11) default NULL, - PRIMARY KEY (idB), - UNIQUE KEY valor (valor) - ) TYPE=MyISAM; Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO b (idB, valor) VALUES (1,1),(2,2),(3,NULL),(4,NULL); Query OK, 4 rows affected (0.01 sec) Registros: 4 Duplicados: 0 Peligros: 0 mysql select * from b; +-+---+ | idB | valor | +-+---+ | 1 | 1 | | 2 | 2 | | 3 | NULL | | 4 | NULL | +-+---+ 4 rows in set (0.00 sec) mysql alter table b type=InnoDB; ERROR 1062: Entrada duplicada 'NULL' para la clave 2 Why? I know that NULL != NULL, then behaviour in MyISAM is correct but in InnoDB in not. With foreign key constraints, I have found the same problem: I can't insert a NULL in a column that references other. Thanks, José Ceferino Ortega - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication
Hi. On Thu, Dec 13, 2001 at 09:05:46AM -0500, [EMAIL PROTECTED] wrote: [...] I have read the Replication section of the MySQL manual and I think I have a basic understanding of how the replication is being handled, but one thing I am a bit concerned about on the two local servers is latency. [...] However, we would have no way of knowing if the slaves have been updated if my thinking is clear; would this be correct? Yes. If so, we would just have to write the server objects to query the master rather than a slave from interactive objects. Looks like a good solution to me. The latency of directly querying the server or waiting for the slave to update and querying it should be about the same (in the ideal case that you know when the slave has updated). You could know whether the client is up to date or not, by checking for a timestamp to change. But that's not pretty. But, is there any guideline for how long it may take for the local slaves to be updated? No. In my experience, it depends mostly on your connection latency. On the other hand, you can simply stop replication and restart it the other day, so pending updates would need a day... ;-) Bye, Benjamin. -- [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: Why MySQL GUI download don't work?
Are you trying to use a download manager?. If so .. it didnt work for me. Disable it, and it will work. vicente -Mensaje original- De: Alex Shi [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 12 de diciembre de 2001 23:46 Para: [EMAIL PROTECTED] Asunto: Why MySQL GUI download don't work? I tried to download MySQL GUI from these links: http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip and http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz But all these don't work. Alex - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 9:22 AM Subject: RE: I must be mental but. I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Searching for the configuration file
Hi. Depending on from what source you installed MySQL, there may be none yet and you have to create it (I think this is the case for the RPMs). The places where MySQL looks for the file are listed here: http://www.mysql.com/doc/O/p/Option_files.html Bye, Benjamin. On Thu, Dec 13, 2001 at 10:16:58PM -, [EMAIL PROTECTED] wrote: I've just changed over to Linux instead of running on windows and I'm looking for the configuration file so I can change the default location of the databases and I can't find the file. Can anyone tell me where it is please? The installation was a straight install from the rpms. [...] -- [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: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Trond Eivind Glomsrød writes: Robert Alexander [EMAIL PROTECTED] writes: I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. Yes, it should be one of our mirrors. I truly do not know whether files are exact copy. But, this is not important now, as user's problems were solved. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql server not starting!
Dipali Chittar writes: InnoDB: Operating system error no 13 is a file operation perror 13 will tell you that it's a permission problem. Check your file permissions and ownership, as indicated by the installation notes. BTW, your time seems to be off by 12 hours. Unless I'm mistaken you're located in India or somewhere around there, and it's evening rather than early morning right now. //C - has a computer that drifted 23 minutes in a few weeks when ntpd was not running. Has anyone else noticed that setting the default rule to 'ignore' screws up the rules for all IPs? -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. MYSQL MYSQL MYSQL - I hate that bloody 'spam filter'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Order By number of rows returned ?
Hi I'm trying to do some sorting by relevance on a query. Essentially, i'd like to know if there is way to order the results by number of rows returned or if this is the best i can get and do the rest within PHP? mysql SELECT web_account, code_short FROM lookup WHERE code_short IN ('U', 'S', 'G'); +-++ | web_account | code_short | +-++ | A007| U | | A007| S | | J009| G | | J009| U | | J009| S | | B001| U | +-++ 6 rows in set (0.00 sec) I'd like to order these so that J009 would be grouped at the top of the set because it was found in 3 rows, A007 would be placed after J009 with B001 last. Any ideas :) ? Thanks for your time. Girish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Troubles with Mysql + InnoDB
Hi! At run of a script there is an error and the server falls. The script, the log file and my configuration follow. Client output: #mysql -p USTAT test.sql Password: ERROR 2013 at line 22: Lost connection to MySQL server during query -- begin script -- drop table if exists CARDS; create table CARDS ( NUM SMALLINT unsigned not null, FIRM VARCHAR(132) not null default '', NAME VARCHAR(80) not null default '', CEMAILVARCHAR(80) not null default '', NOTES VARCHAR(255) not null default '', primary key (NUM) ) TYPE = InnoDB; drop table if exists DOMAINS; create table DOMAINS ( IDMEDIUMINTunsigned not null, NUM SMALLINT unsigned not null, index DOMAINS_NUM (NUM), DOMAINVARCHAR(80) not null, foreign key (NUM) references CARDS(NUM), primary key (ID) ) TYPE = InnoDB; drop table if exists LOGINS; create table LOGINS ( IDMEDIUMINTunsigned not null, NUM SMALLINT unsigned not null, index LOGINS_NUM(NUM), LOGIN CHAR(33) not null, index LOGINS_LOGIN(LOGIN), MAXSESTINYINT unsigned not null default 0, MAXDAYMEDIUMINTunsigned not null default 0, MAXWEEK MEDIUMINTunsigned not null default 0, MAXMONMEDIUMINTunsigned not null default 0, MAXTOTAL INT unsigned not null default 0, foreign key (NUM) references CARDS(NUM), primary key (ID) ) TYPE = InnoDB; -- end script -- -- begin error log -- 011214 14:28:38 mysqld restarted 011214 14:28:39 InnoDB: Started /usr/libexec/mysqld: ready for connections InnoDB: Assertion failure in thread 12299 in file dict0crea.c line 1237 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=16773120 record_buffer=131072 sort_buffer=524280 max_used_connections=1 max_connections=100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80b5694 0x40039eb4 0x8125c77 0x8128c8e 0x8139ffb 0x80ff8a2 0x80fa33d 0x80efb02 0x81043a0 0x80bc7dc 0x80bffd0 0x80bb3d1 0x80ba7d7 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instrstack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x835c168 = create table LOGINS ( IDMEDIUMINTunsigned not null, NUM SMALLINT unsigned not null, index LOGINS_NUM (NUM), LOGIN CHAR(33) not null, index LOGINS_LOGIN (LOGIN), MAXSESTINYINT unsigned not null default 0, MAXDAYMEDIUMINTunsigned not null default 0, MAXWEEK MEDIUMINTunsigned not null default 0, MAXMONMEDIUMINTunsigned not null default 0, MAXTOTAL INT unsigned not null default 0, foreign key (NUM) references CARDS(NUM), primary key (ID) ) TYPE = InnoDB thd-thread_id=4 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 4 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 011214 14:45:23 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 193409 InnoDB: Doing recovery: scanned up to log sequence number 0 198497 InnoDB: Starting an apply batch of log records to the database... InnoDB: Apply batch completed 011214 14:45:23 InnoDB: Started /usr/libexec/mysqld: ready for connections -- end error log -- -- begin my.cfn --
Re: Very Important!!
Hello Eric, it seems you have a little misconception here. But, due to the kind of the topic, let me first clarify that I am just a member of this mailing list and in no way affiliated with MySQL AB (your salutation lets assume that you were not aware that you wrote to a public mailing list). On Thu, Dec 13, 2001 at 11:51:23PM -0500, [EMAIL PROTECTED] wrote: Dear MySQL, Hi, My Name is Eric Martin. I would like to tell you that you are supporting a web site that is trying to hack other servers. That is not quite correct. The site in question seems to use MySQL as database backend and has chosen to place an powered by MySQL image on their page. You see? No supporting action from MYSQL AB until now. This web site consists of hackers. They openly admit to cheating and hacking servers. I don't know how you all would allow this to happen. How do you think MYSQL AB could disallow this to happen? MySQL is free software and there is no legal way to stop them using MySQL for their web appearance, except for going against the illegal action (hacking servers) itself. The only measure I could think of would be to forbid the use of the trademark on the website. But this is to the official people to speak about. And I dare to doubt that this would stop these people. I Believe that this group is taking advantage of you. There Web Address is WWW.BLTCLAN.COM. They must be stopped. They are ruining the web and gaming for everyone. So please stop them. I believe that you did not understand in which way the MySQL software is (not!) involved here. For example, would you care to write to Microsoft to complain that some cracker used MS Word to write up a list? Regards, Benjamin. -- [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: query
I posted this in a previous mail, but one method would be to use phpmyadmin (web based). Download it at http://www.phpwizard.net Another method would be mysqldump. Cheers Ed -Original Message- From: yogesh deshmukh [mailto:[EMAIL PROTECTED]] Sent: December 14, 2001 5:48 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: query Hello Sir, I am using mysql version 3.22(windows based). I wanted to know whether there is any tool to convert database of above version to the linux based mysql database. If so plz tell me where should I find such a tool. Thanking you waiting for reply Yogesh Deshmukh __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Complient Certification
Hi. On Fri, Dec 14, 2001 at 02:57:52PM +0600, [EMAIL PROTECTED] wrote: I want to know is there any certification saying that a particular package/program is MySQL complient...? I don't think so. Bye, Benjamin. -- [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
Join Problem
I am struggling with a join query using MySQL 3.23.31 under AIX 4.3.3. Here are the tables involved: CREATE TABLE sched_acct_cat ( sched_acct varchar(8) NOT NULL default '', linenum int(11) unsigned NOT NULL default '0', acct varchar(8) default NULL, label varchar(40) default NULL, indent smallint(11) unsigned default NULL, linetype varchar(8) default NULL, pageafter tinyint(3) unsigned default NULL, PRIMARY KEY (sched_acct,linenum) ) TYPE=MyISAM; CREATE TABLE fd ( acct varchar(8) NOT NULL default '', entity varchar(8) NOT NULL default '', month varchar(8) NOT NULL default '', dataview varchar(8) NOT NULL default '', amount double(14,2) default NULL, PRIMARY KEY (acct,entity,month,dataview), KEY acct(acct,entity,month,dataview) ) TYPE=MyISAM; The first table is the structure I am trying to achieve in the problem query. Note line 5 has a NULL where there is no Account. Here is sample output from the first table: select CAT.linenum, CAT.acct from sched_acct_cat CAT where CAT.sched_acct = 'INC_STMT' order by CAT.linenum; 1,A8010 2,A8020 3,A8100 4,A8200 5, 6,AT135 7,A8385 ... etc Here is the problem query. It is pulling in a column of FD data. select CAT.linenum, CAT.acct, FD.amount from sched_acct_cat CAT LEFT JOIN fd FD ON CAT.acct = FD.acct where CAT.sched_acct = 'INC_STMT' AND FD.entity='FMCI' AND FD.dataview='ACTUAL.Y' AND FD.month='OCT01' order by CAT.linenum; Here is the output. Line 5 is missing because of the NULL. Line 4 is missing because Account A8200 is 0 for FMCI because it is missing from the fd table. 1,A8010,9 2,A8020, 9 3,A8100, 9 6,AT135, 9 7,A8385, 9 8,A8600, 9 9,A8800, 9 10,A8900, 9 12,AT140, 9 ... etc. I thought the 'LEFT JOIN' clause would keep all the lines and simply leave NULLs where it could not provide data. The books I looked at seem to imply this. Thanks for any help on this. Dave _ Join the worlds largest e-mail service with MSN Hotmail. 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
Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Trond Eivind =?iso-8859-1?Q?Glomsr=F8d?= writes: Robert Alexander [EMAIL PROTECTED] writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ I know that, but I'm pretty sure sourceforge is one of their mirrors. Yes, SourceForge has our *official* binaries... the same as MySQL.com. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join Problem
Dave Butler wrote: I am struggling with a join query using MySQL 3.23.31 under AIX 4.3.3. Here are the tables involved: select CAT.linenum, CAT.acct, FD.amount from sched_acct_cat CAT LEFT JOIN fd FD ON CAT.acct = FD.acct where CAT.sched_acct = 'INC_STMT' AND FD.entity='FMCI' AND FD.dataview='ACTUAL.Y' AND FD.month='OCT01' order by CAT.linenum; Here is the output. Line 5 is missing because of the NULL. Line 4 is missing because Account A8200 is 0 for FMCI because it is missing from the fd table. 1,A8010,9 2,A8020, 9 3,A8100, 9 6,AT135, 9 7,A8385, 9 8,A8600, 9 9,A8800, 9 10,A8900, 9 12,AT140, 9 etc. I thought the 'LEFT JOIN' clause would keep all the lines and simply leave NULLs where it could not provide data. The books I looked at seem to imply this. Thanks for any help on this. Dave Except, FD.entity will also be NULL, which will cause the AND to fail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installing solaris binary
Hi, I am delighted with the fact there is a mysql GUI for solaris, BUT I cannot get it installed, I downloaded the binaries from the mysql site Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 , and got a .gz file, which is perfectly unzippable. But then I have one file, that is not executable, is not a tar archive. What do I do next with this file to install the GUI thanks Kristof
Re: installing solaris binary
Kristof Cossement writes: Hi, I am delighted with the fact there is a mysql GUI for solaris, BUT I cannot get it installed, I downloaded the binaries from the mysql site Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 , and got a .gz file, which is perfectly unzippable. But then I have one file, that is not executable, is not a tar archive. What do I do next with this file to install the GUI thanks Kristof Do chmod a+x on the file and : file ... It should be SPARC executable ... Very soon there will be a new executable available. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Order By number of rows returned ?
I'm not sure if you can do this all in one query.. I tried a few JOINs, and nothing seemed to work. However, I'm not up to speed on how to join things together to get the best results. However, you can do it by creating a temp table: create table tmp01( web_account char(4) not null default '', count_wa int unsigned not null default 0 ); INSERT INTO tmp01(web_account,count_wa) SELECT web_account,count(web_account) AS count_wa FROM lookup GROUP BY web_account ORDER BY count_wa DESC; SELECT lookup.web_account,lookup.code_short FROM lookup,tmp01 WHERE (lookup.web_account=tmp01.web_account) ORDER BY tmp01.count_wa DESC; DROP table tmp01; This is probably not the best solution to your problem. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Girish Nath [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 7:13 AM To: [EMAIL PROTECTED] Subject: Order By number of rows returned ? Hi I'm trying to do some sorting by relevance on a query. Essentially, i'd like to know if there is way to order the results by number of rows returned or if this is the best i can get and do the rest within PHP? mysql SELECT web_account, code_short FROM lookup WHERE code_short IN ('U', 'S', 'G'); +-++ | web_account | code_short | +-++ | A007| U | | A007| S | | J009| G | | J009| U | | J009| S | | B001| U | +-++ 6 rows in set (0.00 sec) I'd like to order these so that J009 would be grouped at the top of the set because it was found in 3 rows, A007 would be placed after J009 with B001 last. Any ideas :) ? Thanks for your time. Girish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql forum or newsgroup
Hi, I willing to build and host a free mySQL discussion forum/newsgroup for the mySQL community. I have web space available and can easily build a discussion forum using vbulletin and mySQL in a couple of days. Does the mySQL community think that we need a discussion forum where all the mysql messages are archived and offer superor search options ? Any comments and feedback is appreciated. Thanks Jason [EMAIL PROTECTED] --- John Meyer [EMAIL PROTECTED] wrote: Would it be too much to suggest that mysql.com host its own news server or is that too pricey? __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at 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
Re: MySql forum or newsgroup
If benjamin and all other gurus read/post on the webforum, sure I'd like it, since it's not easy to manage hundreds of emails a day... Etienne Jason Rowski wrote: Hi, I willing to build and host a free mySQL discussion forum/newsgroup for the mySQL community. I have web space available and can easily build a discussion forum using vbulletin and mySQL in a couple of days. Does the mySQL community think that we need a discussion forum where all the mysql messages are archived and offer superor search options ? Any comments and feedback is appreciated. Thanks Jason [EMAIL PROTECTED] --- John Meyer [EMAIL PROTECTED] wrote: Would it be too much to suggest that mysql.com host its own news server or is that too pricey? __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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?
anti spam words: database,sql,query,table you can first put it here to be sure it's a bug be specific, showing table definitions, query that is not working please provide OS, mySQL version, any relevant information Etienne Karl J. Stubsjoen wrote: database,sql,query,table Hello, Where is the correct place/procedure to report a possible bug? I think I found one. Karl Karl Stubsjoen excelbus.com/info-m - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coredump when running scripts/mysql_install_db
Hi! Michael A couple of others have reported this in the last month. I reported what Michael I believe to be the same problem on Mon, 29 Oct 2001 with mysql 3.23.43 Michael built from source with gcc 2.95.3 according to the instructions in the Michael manual. I believe the problem is that enabling largefile support, as is Michael done in the official binaries, breaks getrlimit/setrlimit in HPUX 10.20, Michael at least for us. It seems that when you enable largefiles (define Michael _FILE64), rlim_t changes from uint32_t to uint64_t, and something goes Michael horribly wrong. Actually everything works perfectly :) Michael Try this simple c program (based on set_maximum_open_files in mysqld.cc): Michael === Michael #include sys/resource.h Michael #include errno.h Michael #include stdio.h Michael int main() Michael { Michael struct rlimit rl; Michael uint x; Michael x = 100; Michael if (!getrlimit(RLIMIT_NOFILE,rl)) Michael { Michael printf(getrlimit: cur=%ld max=%ld\n, rl.rlim_cur, rl.rlim_max); Michael } Michael rl.rlim_cur = x; Michael rl.rlim_max = x; Michael printf(assign: cur=%ld max=%ld\n, rl.rlim_cur, rl.rlim_max); Michael if (setrlimit(RLIMIT_NOFILE,rl)) Michael { Michael printf(Err: errno=%ld cur=%ld max=%ld\n,errno,rl.rlim_cur,rl.rlim_max); Michael } Michael printf(setrlimit: cur=%ld max=%ld\n, rl.rlim_cur, rl.rlim_max); Michael 0; Michael } Michael === Michael I named this rlimtest.c. Here's what I get: cut Michael $ gcc -D_FILE64 rlimtest.c Michael $ ./a.out Michael getrlimit: cur=137119232 max=60 Michael assign: cur=2063670312 max=100 Michael setrlimit: cur=137119232 max=100 Michael As you can see, I get nonsense with _FILE64. This is becasue rl.rlimit_cur and rl.rlim_max are 64 bit integers, but you are using printf() on 32 bit integers! Fix: cast all integer arguments to printf to (long) or print the integers are high-byte / low-byte. I did the casts to long and the above worked perfectly for me. Michael Strictly speaking, then, this is a bug in either HPUX or gcc (probably Michael HPUX), not in mysql. On the other hand, those of us who have this problem Michael cannot use the precompiled binary. The precompiled binary should work ok. Michael My workaround is to compile mysql from source, adding --disable-largefile Michael to the options recommended in the manual. Perhaps there is a better way Michael -- maybe a fix for HPUX? What kind of errors do you get if you don't use --disable-largefile ? Michael I also note that every post I could find on Google on the subject of Michael building mysql from source on HPUX 10.20 recommended --disable-largefile Michael (though none I saw actually said why). I haven't seen this before. Michael Michael Michael On Tue, 4 Dec 2001, Hans-Joerg Puch wrote: Hello, I was trying a normal installation on a HP UX 10.20 based HP 9000/712. The log looks like this: ___ Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 011204 15:37:50 Warning: setrlimit couldn't increase number of open files to more than 60 011204 15:37:50 Warning: Changed limits: max_connections: 50 table_cache: 64 scripts/mysql_install_db[292]: 3477 Memory fault(coredump) Installation of grant tables failed! This could happen if the above machine's libraries are somehow not compatible with ours. It would be nice to know why... Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Order By number of rows returned ?
Hi Thanks for that, it works really well :) Best Regards Girish - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: 'Girish Nath' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, December 14, 2001 3:03 PM Subject: RE: Order By number of rows returned ? I'm not sure if you can do this all in one query.. I tried a few JOINs, and nothing seemed to work. However, I'm not up to speed on how to join things together to get the best results. However, you can do it by creating a temp table: create table tmp01( web_account char(4) not null default '', count_wa int unsigned not null default 0 ); INSERT INTO tmp01(web_account,count_wa) SELECT web_account,count(web_account) AS count_wa FROM lookup GROUP BY web_account ORDER BY count_wa DESC; SELECT lookup.web_account,lookup.code_short FROM lookup,tmp01 WHERE (lookup.web_account=tmp01.web_account) ORDER BY tmp01.count_wa DESC; DROP table tmp01; This is probably not the best solution to your problem. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Girish Nath [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 7:13 AM To: [EMAIL PROTECTED] Subject: Order By number of rows returned ? Hi I'm trying to do some sorting by relevance on a query. Essentially, i'd like to know if there is way to order the results by number of rows returned or if this is the best i can get and do the rest within PHP? mysql SELECT web_account, code_short FROM lookup WHERE code_short IN ('U', 'S', 'G'); +-++ | web_account | code_short | +-++ | A007| U | | A007| S | | J009| G | | J009| U | | J009| S | | B001| U | +-++ 6 rows in set (0.00 sec) I'd like to order these so that J009 would be grouped at the top of the set because it was found in 3 rows, A007 would be placed after J009 with B001 last. Any ideas :) ? Thanks for your time. Girish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on OpenBSD 3.0 - got signal 14
Hi - I have MySQL 3.23.42 running on OpenBSD 3.0, Pentium III, 256mb ram. MySQL was installed with the following commands: pkg_add mysql-client-3.23.42.tgz pkg_add mysql-server-3.23.42.tgz mysqladmin reports the following: -- mysqladmin Ver 8.21 Distrib 3.23.42, for unknown-openbsd3.0 on i386 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.42-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/mysql/mysql.sock Uptime: 18 hours 21 min 49 sec Threads: 2 Questions: 1800 Slow queries: 11 Opens: 15 Flush tables: 1 Open tables: 9 Queries per second avg: 0.027 --- I have a table that contains about 500,000 rows. I am connecting to it with Microsoft Access 97 via MyODBC 2.50.39. If I click the key field of the table (defined as an auto_increment integer) and then click the 'Sort A-Z' or 'Sort Z-A' buttons, the table is displayed in the desired sorted order, usually within 10-15 seconds. 5 other columns in the table (all varchar) have indexes. If I click 'Sort A-Z' or 'Sort Z-A' buttons, MS Access usually freezes up. If I tail /var/mysql/myhost.err, I see the following: warning: got signal 14 from thread 18 Any ideas / suggestions? Many thanks - Jim __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at 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
Re: MySql forum or newsgroup
I also think it would be a great idea, my mail box is filling up even with filtering!! Jo - Original Message - From: Jason Rowski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 7:16 AM Subject: MySql forum or newsgroup Hi, I willing to build and host a free mySQL discussion forum/newsgroup for the mySQL community. I have web space available and can easily build a discussion forum using vbulletin and mySQL in a couple of days. Does the mySQL community think that we need a discussion forum where all the mysql messages are archived and offer superor search options ? Any comments and feedback is appreciated. Thanks Jason [EMAIL PROTECTED] --- John Meyer [EMAIL PROTECTED] wrote: Would it be too much to suggest that mysql.com host its own news server or is that too pricey? __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 forum or newsgroup
On Fri, Dec 14, 2001 at 07:16:40AM -0800, Jason Rowski wrote: : Hi, : : I willing to build and host a free mySQL discussion : forum/newsgroup for the mySQL community. I have web : space available and can easily build a discussion : forum using vbulletin and mySQL in a couple of days. : : Does the mySQL community think that we need a : discussion forum where all the mysql messages are : archived and offer superor search options ? Any : comments and feedback is appreciated. Why not just stick a web-frontend on to the mailing list? That way, there aren't two separate areas of MySQL support. There's already archives of the mailing list, and it sounds like what people want is the functionality of the mailing list without the inbox clutter. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
DISTINCT problem
Hello, i've the db of CD Titles which among others contains tables: Titles Songs SongAuthors SongIntereprets Persons I need to perform queries which outputs a set of Titles matching the criteria which restrict either or all of the tables. If I make a join of the tables with restrictions on each table, the query is quite fast unless I use DISTINCT to exclude duplicite titles. When I use distinct, it creates disk-temp tables and the query is 12sec. Is there any solution without distinct? I thought of: using temporary HEAP table for collecting title IDs and somehow forsing MySQL to insert only UNIQUE IDs from the JOIN and than joining this with titles. But how to forse MySQL to do this? or Creating a procedure which would cycle through Joined set of Songs, Authors, Interprets, Persons and put in the temp HEAP only the one record which does not the same ID as the previous one. But I'm neither sure if this is possible in mySQL nor if this is faster then the DISTINCT. Thanx for any help. Miroslav Renda http://www.m7m.cz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 forum or newsgroup
Sorry but I've never seen a mailing list archive really working.. No good search feature, hard to follow a thread (next by thread, next by date, etc) Plus to post you need to be member of the mailing list, therefore receive 400 emails a day... On a forum you register, you post only when you have question, you have separate areas (installation, query problem, design problems, innoDB problem, let's say) and you can do specific searches. You can also have email notice when a reply is made to a thread you started asking a question. my 2 cents... Etienne Philip Molter wrote: On Fri, Dec 14, 2001 at 07:16:40AM -0800, Jason Rowski wrote: : Hi, : : I willing to build and host a free mySQL discussion : forum/newsgroup for the mySQL community. I have web : space available and can easily build a discussion : forum using vbulletin and mySQL in a couple of days. : : Does the mySQL community think that we need a : discussion forum where all the mysql messages are : archived and offer superor search options ? Any : comments and feedback is appreciated. Why not just stick a web-frontend on to the mailing list? That way, there aren't two separate areas of MySQL support. There's already archives of the mailing list, and it sounds like what people want is the functionality of the mailing list without the inbox clutter. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 forum or newsgroup
I agree. I think the forum is a great idea. - Richard - Original Message - From: Etienne Marcotte [EMAIL PROTECTED] To: Philip Molter [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 11:14 AM Subject: Re: MySql forum or newsgroup Sorry but I've never seen a mailing list archive really working.. No good search feature, hard to follow a thread (next by thread, next by date, etc) Plus to post you need to be member of the mailing list, therefore receive 400 emails a day... On a forum you register, you post only when you have question, you have separate areas (installation, query problem, design problems, innoDB problem, let's say) and you can do specific searches. You can also have email notice when a reply is made to a thread you started asking a question. my 2 cents... Etienne Philip Molter wrote: On Fri, Dec 14, 2001 at 07:16:40AM -0800, Jason Rowski wrote: : Hi, : : I willing to build and host a free mySQL discussion : forum/newsgroup for the mySQL community. I have web : space available and can easily build a discussion : forum using vbulletin and mySQL in a couple of days. : : Does the mySQL community think that we need a : discussion forum where all the mysql messages are : archived and offer superor search options ? Any : comments and feedback is appreciated. Why not just stick a web-frontend on to the mailing list? That way, there aren't two separate areas of MySQL support. There's already archives of the mailing list, and it sounds like what people want is the functionality of the mailing list without the inbox clutter. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Order By number of rows returned ?
Create temporary files instead, in that case you don't have to worry about DROPing the tables, they will get dropped as soon as the mysql session is closed. Girish Nath wrote: GN: Date: Fri, 14 Dec 2001 15:29:38 - GN: From: Girish Nath [EMAIL PROTECTED] GN: To: Johnny Withers [EMAIL PROTECTED], [EMAIL PROTECTED] GN: Subject: Re: Order By number of rows returned ? GN: GN: Hi GN: GN: Thanks for that, it works really well :) GN: GN: Best Regards GN: GN: GN: Girish GN: GN: GN: - Original Message - GN: From: Johnny Withers [EMAIL PROTECTED] GN: To: 'Girish Nath' [EMAIL PROTECTED]; [EMAIL PROTECTED] GN: Sent: Friday, December 14, 2001 3:03 PM GN: Subject: RE: Order By number of rows returned ? GN: GN: GN: I'm not sure if you can do this all in one query.. GN: I tried a few JOINs, and nothing seemed to work. GN: However, I'm not up to speed on how to join things GN: together to get the best results. GN: GN: However, you can do it by creating a temp table: GN: GN: create table tmp01( GN: web_account char(4) not null default '', GN: count_wa int unsigned not null default 0 GN: ); GN: GN: INSERT INTO tmp01(web_account,count_wa) GN: SELECT web_account,count(web_account) AS count_wa GN: FROM lookup GN: GROUP BY web_account GN: ORDER BY count_wa DESC; GN: GN: SELECT lookup.web_account,lookup.code_short GN: FROM lookup,tmp01 GN: WHERE (lookup.web_account=tmp01.web_account) GN: ORDER BY tmp01.count_wa DESC; GN: GN: DROP table tmp01; GN: GN: GN: This is probably not the best solution to your problem. GN: GN: - GN: Johnny Withers GN: [EMAIL PROTECTED] GN: p. 601.853.0211 GN: c. 601.209.4985 GN: GN: -Original Message- GN: From: Girish Nath [mailto:[EMAIL PROTECTED]] GN: Sent: Friday, December 14, 2001 7:13 AM GN: To: [EMAIL PROTECTED] GN: Subject: Order By number of rows returned ? GN: GN: GN: Hi GN: GN: I'm trying to do some sorting by relevance on a query. Essentially, i'd GN: like GN: to know if there is way to order the results by number of rows returned GN: or GN: if this is the best i can get and do the rest within PHP? GN: GN: mysql SELECT web_account, code_short FROM lookup WHERE code_short IN GN: ('U', GN: 'S', 'G'); GN: GN: +-++ GN: | web_account | code_short | GN: +-++ GN: | A007| U | GN: | A007| S | GN: | J009| G | GN: | J009| U | GN: | J009| S | GN: | B001| U | GN: +-++ GN: 6 rows in set (0.00 sec) GN: GN: I'd like to order these so that J009 would be grouped at the top of GN: the GN: set because it was found in 3 rows, A007 would be placed after J009 GN: with GN: B001 last. GN: GN: Any ideas :) ? GN: GN: Thanks for your time. GN: GN: GN: GN: Girish GN: GN: GN: - GN: Before posting, please check: GN: http://www.mysql.com/manual.php (the manual) GN: http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail GN: [EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: GN: GN: GN: - GN: Before posting, please check: GN: http://www.mysql.com/manual.php (the manual) GN: http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: GN: GN: GN: GN: - GN: Before posting, please check: GN:http://www.mysql.com/manual.php (the manual) GN:http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 ++ | There is nothing wrong with your tools.| | But we can make a better one. |
Changing location of database files
I've tried searching for the file that gives the location of the database directory, but am unable to find it. Without physically altering that directory is there any other way of changing the location of the database directory? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 forum or newsgroup
On Fri, Dec 14, 2001 at 11:14:00AM -0500, Etienne Marcotte wrote: : Sorry but I've never seen a mailing list archive really working.. That's a fault of mailing list archive designers, not mailing list archives. : No good search feature, hard to follow a thread (next by thread, next by : date, etc) Searching is easy for an archive. Several archives already have this functionality (MARC, eGroups, etc.). As for 'hard to follow a thread', if the display is threaded, and you get an opportunity to click on a thread and read the whole thing, what more can you ask for? If anything, forums often oversimplify this feature or reduce the ease of use of threaded designs. : Plus to post you need to be member of the mailing list, therefore : receive 400 emails a day... There are already other list-joining methods, like digest, that prevent the 400-email-a-day problem. I'm sure another registration method could be setup for a mailing-list front-end, to not send e-mails to people but allow them to post (hell, there may already be one). : On a forum you register, you post only when you have question, you have : separate areas (installation, query problem, design problems, innoDB : problem, let's say) and you can do specific searches. You can also have : email notice when a reply is made to a thread you started asking a : question. On mailing lists, you register, and you typically only post when you have a question. If someone replies to your post, a mailing-list archive frontend can easily detect that that reply was to you, and send you a message (if the original replier didn't already do it from his e-mail program or from the same frontend). As for separate areas, a front-end could easily manage that through an X-Header for messages posted from it and some creative processing (keywords, etc.) to handle messages to the mailing list that didn't come through the front-end (of course, once a thread is started, it falls into it's original area, so you'd only have to do this processing for the initial message in a thread). I mean, in essence, a forum is a prettified mailing list. The thing is, there's already a great mailing list that exists, and splitting off a forum means dividiing that knowledge so that people on the list don't know what's going on on the forum and vice versa (unless they follow both, which is even more time-consuming). Is that a *better* form of support? I would argue no, and since a solution is easily envisioned, why wouldn't one choose to go with it? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: [PHP] Performance
My first guess is that you have a problem with MySQL restarting frequently. If you have a bunch of problems, it might restart in the middle of a script... Try turning on logging on the MySQL server and see if it's restarting frequently. Second guess would be that there was a problem with either the MySQL version or the PHP version or perhaps both. Perhaps PHP tried to optimize performance by sharing MySQL connections or something... Either way - make sure you have the latest and greatest versions of both. - Jonathan -Original Message- From: Ron Jamison [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 3:00 PM To: markus|lervik Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Performance When working with normal connections i.e. non-persistent months ago, using what must've been PHP 4.0.1 or .2, I had some similar experiences. In a number of my more lengthy scripts I was seeing MySQL connections closing on me before the script was done executing. Thus PHP would spit out errors about not having a connection and to ensure it worked I was having to repeatedly call mysql_connect(). I wouldn't doubt the same thing is what Markus is seeing. In these cases, using persistent connections solved the problem for me. -Original Message- From: markus|lervik [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 2:16 PM To: Fournier Jocelyn [Presence-PC] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Performance On Thu, 2001-12-13 at 23:56, Fournier Jocelyn [Presence-PC] wrote: Hi, You absolutely don't have to reconnect to the database each time a PHP-block ends ! (it would be completely awfull !!). Don't you forget to specify the mysql link in you 'mysql_query' ?? Nope, I always specify the mysql link in my queries. But the problem remains. As I'm at home for the moment, I can't try out all the suggestions, but I have tried the p_connect, and it most certanly didn't work. I'll have to try to pinpoint the problem more closely tomorrow at work. It just might be (came to think of it now), that php closes the connection every time I use a submit-button and it reloads the page. Technically speaking, that would be ending a script, right? -Markus -- Markus Lervik Linux administrator with a kungfoo grip Vasa City Library - Public Library - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table Exists
What is the easiest way to check if a table exists in the current database? I checked the documentation, and couldn't find anything (but maybe I missed it). Glen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
locking with BDB tables
I am trying mysql-max 4 with BDB table types and transaction-isolation-level=READ-COMMITTED. When I do an update/delete in one session the table row is locked until rollback or commit for all other sessions. Should this be the case, and if not how do I get round this? Regards, Simon Simon Bury Senior Application Developer T: 0113 367 4522 http://www.ananova.com Ananova Limited Marshall Mill Marshall Street Leeds LS11 9YJ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer. Registered Office: St James Court, Great Park Road, Almondsbury Park, Bradley Stoke. Bristol BS32 4QJ. Registered in England No.2858918 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Table Exists
Mysqlshow tables; Would be the easy way Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 10:34 AM To: [EMAIL PROTECTED] Subject: Table Exists What is the easiest way to check if a table exists in the current database? I checked the documentation, and couldn't find anything (but maybe I missed it). Glen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Changing location of database files
You should be able to change the data-dir variable in your /etc/my.cnf file. If the file isn't there, you can either create it or use a premade one and fine-tune it. If the datadir variable isn't in the my.cnf, you can add it. Read the first two parts of this chapter (they're short) for a few more details: http://www.mysql.com/doc/C/o/Configuring_MySQL.html - Jonathan -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 8:29 AM To: MySQL List Subject: Changing location of database files I've tried searching for the file that gives the location of the database directory, but am unable to find it. Without physically altering that directory is there any other way of changing the location of the database directory? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Table Exists
If you're using PHP, there should be a function for it. You can also use IF NOT EXISTS in your table commands like: CREATE TABLE IF NOT EXISTS, so that you don't overwrite anything. What also might come in handy here is either SHOW TABLES (provided you're in the right database), or DESCRIBE tablename - Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 8:34 AM To: [EMAIL PROTECTED] Subject: Table Exists What is the easiest way to check if a table exists in the current database? I checked the documentation, and couldn't find anything (but maybe I missed it). Glen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table Exists
If you want to check before creating a table: CREATE TABLE IF NOT EXISTS table_name; If you want to do it before deleting: DELETE TABLE IF EXISTS table_name; [EMAIL PROTECTED] wrote: : Date: Fri, 14 Dec 2001 11:34:26 -0500 : From: [EMAIL PROTECTED] : To: [EMAIL PROTECTED] : Subject: Table Exists : : What is the easiest way to check if a table exists in the current : database? I checked the documentation, and couldn't find anything (but : maybe I missed it). : : Glen : : - : Before posting, please check: :http://www.mysql.com/manual.php (the manual) :http://lists.mysql.com/ (the list archive) : : To request this thread, e-mail [EMAIL PROTECTED] : To unsubscribe, e-mail [EMAIL PROTECTED] : Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php : -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Changing location of database files
Jonathon wrote: You should be able to change the data-dir variable in your /etc/my.cnf file. If the file isn't there, you can either create it or use a premade one and fine-tune it. If the datadir variable isn't in the my.cnf, you can add it. Only problem is that the server is up and running perfectly but there is no sign of a my.cnf file anywhere. Will just adding one into /etc cause problems? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 forum or newsgroup
At 10:30 2001-12-14 -0600, Philip Molter wrote: On Fri, Dec 14, 2001 at 11:14:00AM -0500, Etienne Marcotte wrote: : Sorry but I've never seen a mailing list archive really working.. That's a fault of mailing list archive designers, not mailing list archives. [snip] I agree. Besides, and more importantly, I much prefer a mailing list. HD space is cheap, I keep everything, just subdivide into different folders. The result is that I can *always* search everything - even off-line. The biggest disadvantage of a forum is that you have to on-line to be able to do anything, and every new action is a new connect and a new wait. That ends up being more expensive than receiving all posts in your mailbox in one burst, especially when you have to pay per minute for the phone connection (as most people in the world have to do). Cost of using a newsgroup is somewhere in-between as some readers are able to download everything and then let you read and prepare responses off-line. A web front end for the mailing list would be fine - but I would never use it! [anti-filter kluge: mysql, database, grrr] Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.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: installing solaris binary
Re: MySQLGUI At 17:05 +0200 2001/12/14, Sinisa Milivojevic wrote: Very soon there will be a new executable available. Great news! Thanks very much, Sinisa. /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Changing location of database files
If you use a premade one - maybe... but if you create one from scratch with only the datadir variable, then it shouldn't. But if you create one from scratch, at least print out a premade one and make sure you create it correctly. You may also want to examine the command you use to start MySQL. It might have the data-dir variable already set. Most people start it with either safe_mysqld or by using a startup script like mysql-server.sh. You might try modifying those... - Jonathan -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 9:03 AM To: MySQL List Subject: RE: Changing location of database files Jonathon wrote: You should be able to change the data-dir variable in your /etc/my.cnf file. If the file isn't there, you can either create it or use a premade one and fine-tune it. If the datadir variable isn't in the my.cnf, you can add it. Only problem is that the server is up and running perfectly but there is no sign of a my.cnf file anywhere. Will just adding one into /etc cause problems? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.306 / Virus Database: 166 - Release Date: 04/12/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Troubles with Mysql + InnoDB
Hi! I tried with 3.23.47, and the script did not fail. The assertion failure means that adding of a foreign key constraint fails because of some error number which should not happen. You could modify and recompile MySQL so that mysql/innobase/dict0crea.c, line 1237, would print the error code: printf(Error code %lu\n, error); But this may also be a compiler bug. Please try with a binary from www.mysql.com and with a freshly created empty database. Does it still fail? Regards, Heikki Innobase Oy --- See http://www.innodb.com for the latest news about InnoDB Order commercial MySQL/InnoDB support at https://order.mysql.com/ Hi! At run of a script there is an error and the server falls. The script, the log file and my configuration follow.Client output: #mysql -p USTAT test.sqlPassword: ERROR 2013 at line 22: Lost connection to MySQL server during query -- begin script -- drop table if exists CARDS;create table CARDS ( NUM SMALLINT unsigned not null, FIRM VARCHAR(132) not null default '', NAME VARCHAR(80) not null default '', CEMAILVARCHAR(80) not null default '', NOTES VARCHAR(255) not null default '', primary key (NUM) ) TYPE = InnoDB;drop table if exists DOMAINS;create table DOMAINS( IDMEDIUMINTunsigned not null, NUM SMALLINT unsigned not null, index DOMAINS_NUM (NUM), DOMAINVARCHAR(80) not null, foreign key (NUM) references CARDS(NUM), primary key (ID) ) TYPE = InnoDB;drop table if exists LOGINS;create table LOGINS( IDMEDIUMINTunsigned not null, NUM SMALLINT unsigned not null, index LOGINS_NUM(NUM), LOGIN CHAR(33) not null, index LOGINS_LOGIN(LOGIN), MAXSESTINYINT unsigned not null default 0, MAXDAYMEDIUMINTunsigned not null default 0, MAXWEEK MEDIUMINTunsigned not null default 0, MAXMONMEDIUMINTunsigned not null default 0, MAXTOTAL INT unsigned not null default 0, foreign key (NUM) references CARDS(NUM), primary key (ID) ) TYPE = InnoDB; -- end script -- -- begin error log -- 011214 14:28:38 mysqld restarted011214 14:28:39 InnoDB: Started /usr/libexec/mysqld: ready for connections InnoDB: Assertion failure in thread 12299 in file dict0crea.c line 1237 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] got signal 11; mysql drop table if exists CARDS; Query OK, 0 rows affected (0.00 sec) mysql mysql create table CARDS ( - NUM SMALLINT unsigned not null, - FIRM VARCHAR(132) not null default '', - NAME VARCHAR(80) not null default '', - CEMAILVARCHAR(80) not null default '', - NOTES VARCHAR(255) not null default '', primary key (NUM) - ) TYPE = InnoDB; Query OK, 0 rows affected (0.01 sec) mysql mysql drop table if exists DOMAINS; Query OK, 0 rows affected (0.00 sec) mysql mysql create table DOMAINS( - IDMEDIUMINTunsigned not null, - NUM SMALLINT unsigned not null, index DOMAINS_NUM (NUM), - DOMAINVARCHAR(80) not null, - foreign key (NUM) references CARDS(NUM), primary key (ID) - ) TYPE = InnoDB; Query OK, 0 rows affected (0.04 sec) mysql mysql drop table if exists LOGINS; Query OK, 0 rows affected (0.00 sec) mysql mysql create table LOGINS( - IDMEDIUMINTunsigned not null, - NUM SMALLINT unsigned not null, index LOGINS_NUM(NUM), - LOGIN CHAR(33) not null, index LOGINS_LOGIN(LOGIN), - MAXSESTINYINT unsigned not null default 0, - MAXDAYMEDIUMINTunsigned not null default 0, - MAXWEEK MEDIUMINTunsigned not null default 0, - MAXMONMEDIUMINTunsigned not null default 0, - MAXTOTAL INT unsigned not null default 0, - foreign key (NUM) references CARDS(NUM), primary key (ID) - ) TYPE = InnoDB; Query OK, 0 rows affected (0.05 sec) mysql mysql show table status from test like 'DOMAINS'; +-+++--++-+- +--+---++-+- +++- + | Name| Type | Row_format | Rows | Avg_row_length | Data_length | Max_data _length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-+++--++-+-
timestamp
Is there a way that will allow a mysql database automatically add the current timestamp to a record when the record is added to the database? Would formatting it through php be useful, and if so, does anyone know how? Thanks, Steve Osborne Database Programmer Chinook Multimedia Inc. [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: timestamp
You've answered your own question. Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 12:48 PM To: MySQL (E-mail) Subject: timestamp Is there a way that will allow a mysql database automatically add the current timestamp to a record when the record is added to the database? Would formatting it through php be useful, and if so, does anyone know how? Thanks, Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sub selects
can you perform sub selects in mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timestamp
Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this? Steve mysql (filter filter) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sub selects
no, but you can acheive the same results please consult the manual http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Etienne Joel Wickard wrote: can you perform sub selects in mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sub selects
no -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 2:51 PM To: [EMAIL PROTECTED] Subject: sub selects can you perform sub selects in mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: timestamp
Steve Osborne wrote: Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this? Steve mysql (filter filter) Yes, you are putting something there, and it is not a valid datetime, so Mysql substitutes 0s. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sub selects
As far as I know, not yet Joel Wickard wrote: JW: Date: Fri, 14 Dec 2001 12:50:39 -0800 JW: From: Joel Wickard [EMAIL PROTECTED] JW: To: [EMAIL PROTECTED] JW: Subject: sub selects JW: JW: can you perform sub selects in mysql? JW: JW: JW: - JW: Before posting, please check: JW:http://www.mysql.com/manual.php (the manual) JW:http://lists.mysql.com/ (the list archive) JW: JW: To request this thread, e-mail [EMAIL PROTECTED] JW: To unsubscribe, e-mail [EMAIL PROTECTED] JW: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php JW: -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timestamp
How are you storing data to the record? It should be: CREATE TABLE mytable ( mydata int NOT NULL, timestamp timestamp ); INSERT INTO mytable VALUES(123,NULL); UPDATE mytable SET mydata=456; -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 1:56 PM To: MySQL (E-mail) Subject: Fw: timestamp Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this? Steve mysql (filter filter) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: timestamp
I've tried passing nothing '' and NULL and 'NULL', and still the zero's. In response to Mikel, the field is declared as NULL and default is NULL. I've experimented with changing the Null and Default columns in phpMyAdmin, but it stays as NULL and default as NULL. Steve. Steve Osborne wrote: Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this? Steve mysql (filter filter) Yes, you are putting something there, and it is not a valid datetime, so Mysql substitutes 0s. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
timestamp additional info
Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [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: sub selects
At 12:50 -0800 2001/12/14, Joel Wickard wrote: can you perform sub selects in mysql? The quick answer is coming soon. Please see: http://www.mysql.com/doc/D/i/Differences_from_ANSI.html and http://www.mysql.com/doc/T/O/TODO_future.html HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timestamp additional info
mysql (filter) Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v.s. Oracle
On Thu, 2001-12-13 at 03:54, Robert Sundström wrote: queries, with medium sized transactions (3-5 statements per transaction, where transactions was supported). On my regular desktop box I was able to get about 700 statements per second using MyISAM and about two thirds of that using InnoDB. Already at 2 simultaneous users (doing the same transactions) total throughput was less than for the single user case. Look and see what your innodb_buffer_pool_size setting is. The thing I keep running into when helping people make use of Innodb is that they either don't understand it or they think it is similair to the record_buffer setting (which is just wrong). If you are from an Oracle world think of it as your SGA. If you tune it as you tune your SGA you will see a dramatic increase in performance. One of the great things about MySQL is it installs so easily. If you have ever been through an Oracle install (or hell DB2) you realize how much easier it is to install MySQL. Problem is, the default install is probably not going to be very tuned for your environment most likely. Most stable commercial products exposes the opposite behavior. It may be the case that MySQL performs pretty well in single (or few) user cases, but the commercial alternatives will, in my experience, in most cases beat MySQL on 3-5 users and above. I have worked in a shop where we replaced MySQL with Oracle. What was running at the time on a 6 processor ALR box needed 3 Sun 4500's to run nearly as well. This was also 3 years ago. Today there wouldn't have been the need to do conversion. It is also the case that most commercial products supports better optimization methods than MySQL. Two important things are caching statement compilations at the server and stored procedures. If I have a performance Stored procedures just add more load to your database. Assuming you are in a production environment where you are paying for each processor your database has, stored procedures are very costly compared to just adding a farm of frontend servers to do the labor. The one instance where this can make a lot of difference is if moving the data is highly expensive. In that case if you don't want to shover several gigs of data across your pipe a stored procedure works quite well. The two cases where I currently need to keep from doing this I just use myperl() in MySQL and let it do the work (and even if you hate perl you have to admit it is a lot prettier then PL/SQL). -Brian -- ___ Brian Aker, [EMAIL PROTECTED] Slashdot Senior Developer Seattle, Washington http://tangent.org/~brian/ Email/Jabber [EMAIL PROTECTED] ___ You can't grep a dead tree. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coredump when running scripts/mysql_install_db
On Fri, 14 Dec 2001, Michael Widenius wrote: Hi! Michael A couple of others have reported this in the last month. I reported what Michael I believe to be the same problem on Mon, 29 Oct 2001 with mysql 3.23.43 Michael built from source with gcc 2.95.3 according to the instructions in the Michael manual. I believe the problem is that enabling largefile support, as is Michael done in the official binaries, breaks getrlimit/setrlimit in HPUX 10.20, Michael at least for us. It seems that when you enable largefiles (define Michael _FILE64), rlim_t changes from uint32_t to uint64_t, and something goes Michael horribly wrong. Actually everything works perfectly :) Michael Try this simple c program (based on set_maximum_open_files in mysqld.cc): [snip] Michael I named this rlimtest.c. Here's what I get: cut Michael $ gcc -D_FILE64 rlimtest.c Michael $ ./a.out Michael getrlimit: cur=137119232 max=60 Michael assign: cur=2063670312 max=100 Michael setrlimit: cur=137119232 max=100 Michael As you can see, I get nonsense with _FILE64. This is becasue rl.rlimit_cur and rl.rlim_max are 64 bit integers, but you are using printf() on 32 bit integers! Fix: cast all integer arguments to printf to (long) or print the integers are high-byte / low-byte. I did the casts to long and the above worked perfectly for me. Of course, you are right. As I said, I took this code from set_maximum_open_files in mysqld.cc: simply turning the 1st sql_print_error line into the printf lines. I should have looked more carefully, but I thought I had something here, as I'll explain below. (Strange, though, that rl.rlimit_max printed fine without the cast to long.) Michael Strictly speaking, then, this is a bug in either HPUX or gcc (probably Michael HPUX), not in mysql. On the other hand, those of us who have this problem Michael cannot use the precompiled binary. The precompiled binary should work ok. I tried the precompiled binary (3.23.43) and got the same error. Michael My workaround is to compile mysql from source, adding --disable-largefile Michael to the options recommended in the manual. Perhaps there is a better way Michael -- maybe a fix for HPUX? What kind of errors do you get if you don't use --disable-largefile ? As I reported in my earlier email on Oct. 29, I get essentially the same error as was reported here, namely, setrlimit fails. I configured as you recommend, run make, then make test. I get: === $make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases 011214 21:50:26 Warning: setrlimit couldn't increase number of open files to more than 60 011214 21:50:26 Warning: Changed limits: max_connections: 50 table_cache: 64 011214 21:50:26 ../sql/mysqld: Shutdown Complete Installing Slave Databases 011214 21:50:26 Warning: setrlimit couldn't increase number of open files to more than 60 011214 21:50:26 Warning: Changed limits: max_connections: 50 table_cache: 64 011214 21:50:27 ../sql/mysqld: Shutdown Complete [snip] isam 0.0 0.0 4.6 [ pass ] isolation [ skipped ] join [ fail ] Aborting. To continue, re-run with '--force'. As you can see, setrlimit fails to increase the allowed number of open files, then the join test fails because it wants to open more than 60, the default on my system. The ouput quoted here is from 3.23.46 built today, but it's the same as I got in October with 3.23.43. Michael I also note that every post I could find on Google on the subject of Michael building mysql from source on HPUX 10.20 recommended --disable-largefile Michael (though none I saw actually said why). I haven't seen this before. I should clarify: None of these said you need --disable-largefile. When I ran into the problem above, I went looking for solutions. I found several threads in which someone said it didn't work on HPUX 10.20, then someone else replied with I built it this way and it worked. I noticed that each of these replies differed from the recommended build mainly by adding --disable-largefile to configure. None of them pointed to that explicitly, but I added --disable-largefile and rebuilt and it worked. No more rlimit warning and join test passed. This led me to look at mysqld.cc where setrlimit is called, which led me to my test program, which led me down the wrong path, apparently, as you've pointed out. Still, adding --disable-largefile fixes the problem with setrlimit for me. Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual)
Re: timestamp additional info
Don't reference the timestamp column at all in your INSERT (or future UPDATE) statements and the timestamp should update just fine on its own. i.e. INSERT INTO Owners (NameID,ProductsKey,RegNum) VALUES ('$NameID','1','$RegNumc'); BTW, you cannot change the default for a timestamp column - it is always NULL (which displays as '00'). HTH, -- coop On Fri, 2001-12-14 at 15:16, Steve Osborne wrote: Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [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: Fw: timestamp
You have not shown us what you are doing, only described it. Write a test case that creates a table with a timestamp field, populates the table, and does a select on it. Show us what you are doing, and the results. Steve Osborne wrote: I've tried passing nothing '' and NULL and 'NULL', and still the zero's. In response to Mikel, the field is declared as NULL and default is NULL. I've experimented with changing the Null and Default columns in phpMyAdmin, but it stays as NULL and default as NULL. Steve. Steve Osborne wrote: Rick, snip Just add a field of type TIMESTAMP to your record. Whenever the field is added or updated, this field will be updated as well. /snip The field is already a 'timestamp(14)' type field, but all that is being stored in the fields are zero's. Do you know what could be causing this? Steve mysql (filter filter) Yes, you are putting something there, and it is not a valid datetime, so Mysql substitutes 0s. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timestamp additional info
You are inserting the string 'NULL' Don't include it at all in the insert. Steve Osborne wrote: Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timestamp additional info
mysql CREATE TABLE tblTEST ( - KeyValue int(10) NOT NULL default 0, - DataValue varchar(255) default NULL, - LastEdited timestamp(14) NOT NULL, - PRIMARY KEY (KeyValue) - ); mysql insert into tblTEST (KeyValue, DataValue) values( 1, 'Hello'); Query OK, 1 row affected (0.00 sec) mysql select * from tblTEST; +--+---++ | KeyValue | DataValue | LastEdited | +--+---++ |1 | Hello | 20011214194514 | +--+---++ 1 row in set (0.00 sec) mysql UPDATE tblTEST SET DataValue='World' WHERE KeyValue=1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from tblTEST; +--+---++ | KeyValue | DataValue | LastEdited | +--+---++ |1 | World | 20011214194555 | +--+---++ 1 row in set (0.00 sec) mysql Regards M -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: 14 December 2001 20:16 To: MySQL (E-mail) Subject: timestamp additional info Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: timestamp additional info-SOLVED
Thanks, it is working perfectly as described Steve Don't reference the timestamp column at all in your INSERT (or future UPDATE) statements and the timestamp should update just fine on its own. i.e. INSERT INTO Owners (NameID,ProductsKey,RegNum) VALUES ('$NameID','1','$RegNumc'); BTW, you cannot change the default for a timestamp column - it is always NULL (which displays as '00'). HTH, -- coop INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Osborne Database Programmer Chinook Multimedia Inc. [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
dbi accessor for mysql_insertid
Statement handles appear to have an accessor method to return the last insert id: $new_id = $sth-insertid; But I cannot seem to locate one for the database handle. The closest I have found is the $new_id = $dbh-{'mysql_insertid'}; In the case of a $dbh-do(...) where there is no statement handle, I have been using the above. I'm concerned about writing code for the long term that references the internals of an object. Is this guaranteed to stay this way forever? Or, is there an accessor method on the database handle that I am not aware of? Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: timestamp additional info
At 12:18 -0800 2001/12/14, Steve Osborne wrote: Timestamp additional info: INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate) VALUES ('$NameID','1','$RegNumc','NULL'); ProdRegDate is the field that I want to timestamp. (Again, I've tried passing '', NULL, and 'NULL'). Steve Hi Steve, You don't need to (and shouldn't) specify the timestamp field in your query at all. If it's defined in the table, it'll update automatically when you insert or update the record. In the example above, you're specifically setting it to NULL or an empty string -- it's taking it's best shot, and filling the column with '0's. : HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
row count for multiple tables.
How do I retrieve the count for multiple tables with one sql command? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Smalltalk and mySQL
Anyone have any experience of using mySQL within Smalltalk servers on a unix/linux platform? Any decent links? I am just exploring this now as I have heard there is now a Smalltalk mod for Apache. This sounds like a fun combination to play with! thanks, Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Distribute MySQL with VB App
Hello, Is it possible to distribute a MySQL db with a visual basic application - in other words, use MySQL as the backend DB for a Visual Basic app? Karl Stubsjoen www.excelbus.com/info-m - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Searchable Mailing List Archive now up.
Hi everyone, Just want to make a very brief announcement. I've seen a few mentions in the recent past of the desire for a searchable archive of the MySQL list. I've wanted one, too. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive It's still in BETA, so this is a test release to see how it holds up. It's fully searchable on Subject or Body, on the From address, and by date range. It's running on a reasonably decent box (a Sun Ultra 1), but on a fairly slow connection (for now). The pages are quite compact, though, so as long as not everybody hits it at once, it should give pretty decent performance. : Written in Perl with MySQL as the backend, of course. : The archive is updated in real-time as the mails arrive, so it should always be up-to-the-minute. Take a minute and let me know what you think -- it's a work in progress, and feedback is appreciated. Thanks, all! /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui
hi in the help file of mysqlgui we find that it has the functions for: - Generating a menu with table fields based on tables that the user has choosen - Parametrized queries, where the user can put any number of ?var? strings and getting a dialog with all ?var? specified, so that inputed values replace ?var? s before execution How these 2 functions work? I try Commands --- Table Choose table next Commands Table - Edit Table But nothing happen Thanks for your help Jean Maupertuis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dbi accessor for mysql_insertid
$dbh-mysql_insertid() Rich Duzenbury wrote: RD: Date: Fri, 14 Dec 2001 14:15:36 -0600 RD: From: Rich Duzenbury [EMAIL PROTECTED] RD: To: [EMAIL PROTECTED] RD: Subject: dbi accessor for mysql_insertid RD: RD: Statement handles appear to have an accessor method to return the last RD: insert id: RD: $new_id = $sth-insertid; RD: RD: But I cannot seem to locate one for the database handle. The closest I RD: have found is the RD: $new_id = $dbh-{'mysql_insertid'}; RD: RD: In the case of a $dbh-do(...) where there is no statement handle, I have RD: been using the above. RD: RD: I'm concerned about writing code for the long term that references the RD: internals of an object. Is this guaranteed to stay this way forever? Or, RD: is there an accessor method on the database handle that I am not aware of? RD: RD: Regards, RD: Rich RD: RD: RD: - RD: Before posting, please check: RD:http://www.mysql.com/manual.php (the manual) RD:http://lists.mysql.com/ (the list archive) RD: RD: To request this thread, e-mail [EMAIL PROTECTED] RD: To unsubscribe, e-mail [EMAIL PROTECTED] RD: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php RD: -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: row count for multiple tables.
* Nissim Lugasy How do I retrieve the count for multiple tables with one sql command? describe select * from t1,t2,t3,t4,t5 where t1.id=t1.id; You will get the table names in the 'names' column and the row counts in the 'rows' column. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
importing from text base file with | delimiters
Hi, How can I import a text file database in which delimiters are | character field separated into mysql database? -- *** Phillip B. Bruce *** *** http://pbbruce.home.mindspring.com *** *** [EMAIL PROTECTED] *** *** *** *** Have you ever noticed? Anybody going slower than*** *** you is an idiot, and anyone going faster than you*** *** is a maniac. - George Carlin*** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question on mySQL replication
Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? If the server the master was on went down unexpectedly, how much data would still be on the master that the slave(s) may not have picked up? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Searchable Mailing List Archive now up.
- Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive Simply fabulous! Thanks! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Searchable Mailing List Archive now up.
Hi guys, I think i've already pointed this out but im also archiving ALL of the mailing lists from mysql at http://www.mysqldeveloper.com/lists/ Tony Buckley wrote: - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive Simply fabulous! Thanks! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
many aborted connections, errors reading communication packets
I'm receiving many aborted connections, errors reading communication packets. I've read many of the posts from people with this same problem, but have not found an answer. One addition detail that was not mentioned in any of the other threads is that The problem started when I added a secure certificate to Apache. I'm using MySQL 3.23.29 with Apache 1.3.19 and PHP 4.04 Thanks, Kipp - 011209 03:26:17 mysqld started /usr/libexec/mysqld: ready for connections 011209 3:29:31 /usr/libexec/mysqld: Normal shutdown 011209 3:29:31 /usr/libexec/mysqld: Shutdown Complete 011209 03:29:31 mysqld ended 011209 03:30:56 mysqld started /usr/libexec/mysqld: ready for connections 011209 3:38:22 /usr/libexec/mysqld: Normal shutdown 011209 3:38:22 /usr/libexec/mysqld: Shutdown Complete 011209 03:38:22 mysqld ended 011209 03:40:24 mysqld started /usr/libexec/mysqld: ready for connections 011209 3:56:29 /usr/libexec/mysqld: Normal shutdown 011209 3:56:29 /usr/libexec/mysqld: Shutdown Complete 011209 03:56:29 mysqld ended 011209 03:57:53 mysqld started /usr/libexec/mysqld: ready for connections 011209 10:32:47 Aborted connection 13 to db: 'driveins' user: 'driveins' host: `localhost' (Got an error reading communication packets) 011209 10:32:49 Aborted connection 15 to db: 'driveins' user: 'driveins' host: `localhost' (Got an error reading communication packets) 011209 10:32:53 Aborted connection 14 to db: 'driveins' user: 'driveins' host: `localhost' (Got an error reading communication packets) 011209 11:34:30 /usr/libexec/mysqld: Normal shutdown 011209 11:34:30 Aborted connection 7 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 3 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 11 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 6 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 4 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 10 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 5 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 8 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 16 to db: 'driveins' user: 'ksherer' host: `192.168.2.2' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 2 to db: 'driveins' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 Aborted connection 1 to db: 'products' user: 'driveins' host: `localhost' (Got timeout reading communication packets) 011209 11:34:30 /usr/libexec/mysqld: Shutdown Complete 011209 11:34:30 mysqld ended 011209 11:41:15 mysqld started /usr/libexec/mysqld: ready for connections 011209 13:06:06 Aborted connection 16 to db: 'products' user: 'driveins' host: `localhost' (Got an error reading communication packets) 011209 13:06:28 Aborted connection 15 to db: 'driveins' user: 'driveins' host: `localhost' (Got an error reading communication packets) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Default 1 == Default 16777216?
For those that silently follow these more unusual threads, what was the cause? Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 December 2001 8:07 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Default 1 == Default 16777216? Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Philip Molter writes: Yeah, let me amend this. It's not happening with MyISAM tables, only with InnoDB tables, and it is happening with the pre-compiled binaries from the web site. It's definitely an endian issue. cut Sinisa Thanks for your bug report. Sinisa Now that you have cleared out that this is not happening with MyISAM, Sinisa it will be easier for us to fix it. I have now fixed this; It will be in MySQL 3.23.47 and 4.0.1. Thanks! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I can't see the error in my code ):
Hi! The set: I have a variable in my table with ONE of the following as blob: 1.0 1.5 ... 12.5 The search the user does with a htlm-select (arrayvar[]) with multipe-selections where possible selectabe values could be: 1.0','1.5 2.0','2.5 3.0','3.5 4.0','4.5 5.0','5.5 6.0','6.5 7.0','7.5','8.0','8.5','9.0','9.5','10.0','10.5','11.0','11.5','12.0','12.5 Then on the server I do for the mysql-search out of php: $result = MysqlQuery( SELECT * FROM $db_mytable WHERE $db_mytable.field IN (' . implode(', ' , $zimmermulreg) . ') ); If for example the user selects 1.0','1.5 and 4.0','4.5 the term (' . implode(', ' , $zimmermulreg) should cause this: $result = MysqlQuery( SELECT * FROM $db_mytable WHERE $db_mytable.field IN ('1.0','1.5','4.0','4.5') ); so result would get all rows of the table where field is 1.0 or 1.5 or 4.0 or 4.5. But it doesn't work ): I hope i described it well and someone could give me a hint. Thanks Dieter Hansen [EMAIL PROTECTED] Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Order By number of rows returned ?
Creating temporary _fileS_ will create a lot of disk unnecessary disk i/o. depending on how busy your DB is, I would use tables in memory vs. files on disk... just my .02c -CB -Original Message- From: sherzodR [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 11:25 AM To: Girish Nath Cc: Johnny Withers; [EMAIL PROTECTED] Subject: Re: Order By number of rows returned ? Create temporary files instead, in that case you don't have to worry about DROPing the tables, they will get dropped as soon as the mysql session is closed. Girish Nath wrote: GN: Date: Fri, 14 Dec 2001 15:29:38 - GN: From: Girish Nath [EMAIL PROTECTED] GN: To: Johnny Withers [EMAIL PROTECTED], [EMAIL PROTECTED] GN: Subject: Re: Order By number of rows returned ? GN: GN: Hi GN: GN: Thanks for that, it works really well :) GN: GN: Best Regards GN: GN: GN: Girish GN: GN: GN: - Original Message - GN: From: Johnny Withers [EMAIL PROTECTED] GN: To: 'Girish Nath' [EMAIL PROTECTED]; [EMAIL PROTECTED] GN: Sent: Friday, December 14, 2001 3:03 PM GN: Subject: RE: Order By number of rows returned ? GN: GN: GN: I'm not sure if you can do this all in one query.. GN: I tried a few JOINs, and nothing seemed to work. GN: However, I'm not up to speed on how to join things GN: together to get the best results. GN: GN: However, you can do it by creating a temp table: GN: GN: create table tmp01( GN: web_account char(4) not null default '', GN: count_wa int unsigned not null default 0 GN: ); GN: GN: INSERT INTO tmp01(web_account,count_wa) GN: SELECT web_account,count(web_account) AS count_wa GN: FROM lookup GN: GROUP BY web_account GN: ORDER BY count_wa DESC; GN: GN: SELECT lookup.web_account,lookup.code_short GN: FROM lookup,tmp01 GN: WHERE (lookup.web_account=tmp01.web_account) GN: ORDER BY tmp01.count_wa DESC; GN: GN: DROP table tmp01; GN: GN: GN: This is probably not the best solution to your problem. GN: GN: - GN: Johnny Withers GN: [EMAIL PROTECTED] GN: p. 601.853.0211 GN: c. 601.209.4985 GN: GN: -Original Message- GN: From: Girish Nath [mailto:[EMAIL PROTECTED]] GN: Sent: Friday, December 14, 2001 7:13 AM GN: To: [EMAIL PROTECTED] GN: Subject: Order By number of rows returned ? GN: GN: GN: Hi GN: GN: I'm trying to do some sorting by relevance on a query. Essentially, i'd GN: like GN: to know if there is way to order the results by number of rows returned GN: or GN: if this is the best i can get and do the rest within PHP? GN: GN: mysql SELECT web_account, code_short FROM lookup WHERE code_short IN GN: ('U', GN: 'S', 'G'); GN: GN: +-++ GN: | web_account | code_short | GN: +-++ GN: | A007| U | GN: | A007| S | GN: | J009| G | GN: | J009| U | GN: | J009| S | GN: | B001| U | GN: +-++ GN: 6 rows in set (0.00 sec) GN: GN: I'd like to order these so that J009 would be grouped at the top of GN: the GN: set because it was found in 3 rows, A007 would be placed after J009 GN: with GN: B001 last. GN: GN: Any ideas :) ? GN: GN: Thanks for your time. GN: GN: GN: GN: Girish GN: GN: GN: - GN: Before posting, please check: GN: http://www.mysql.com/manual.php (the manual) GN: http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail GN: [EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: GN: GN: GN: - GN: Before posting, please check: GN: http://www.mysql.com/manual.php (the manual) GN: http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: GN: GN: GN: GN: - GN: Before posting, please check: GN:http://www.mysql.com/manual.php (the manual) GN:http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To
mysqlclient.lib compiling problem
I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlclient.lib compiling problem
I've run into the same problem with mysql++'s msvc++ port mysql++.lib. Devore, Jacob wrote: I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlclient.lib compiling problem
How did you fix it, just use the dll? Thanks, jake -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:07 PM To: Devore, Jacob Cc: '[EMAIL PROTECTED]' Subject: Re: mysqlclient.lib compiling problem I've run into the same problem with mysql++'s msvc++ port mysql++.lib. Devore, Jacob wrote: I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Order By number of rows returned ?
Hmmmrunning MySQL 3.22.32 on actual server :( No temporary heap tables :( Girish - Original Message - From: Christopher Bergeron [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Saturday, December 15, 2001 12:49 AM Subject: RE: Order By number of rows returned ? Creating temporary _fileS_ will create a lot of disk unnecessary disk i/o. depending on how busy your DB is, I would use tables in memory vs. files on disk... just my .02c -CB -Original Message- From: sherzodR [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 11:25 AM To: Girish Nath Cc: Johnny Withers; [EMAIL PROTECTED] Subject: Re: Order By number of rows returned ? Create temporary files instead, in that case you don't have to worry about DROPing the tables, they will get dropped as soon as the mysql session is closed. Girish Nath wrote: GN: Date: Fri, 14 Dec 2001 15:29:38 - GN: From: Girish Nath [EMAIL PROTECTED] GN: To: Johnny Withers [EMAIL PROTECTED], [EMAIL PROTECTED] GN: Subject: Re: Order By number of rows returned ? GN: GN: Hi GN: GN: Thanks for that, it works really well :) GN: GN: Best Regards GN: GN: GN: Girish GN: GN: GN: - Original Message - GN: From: Johnny Withers [EMAIL PROTECTED] GN: To: 'Girish Nath' [EMAIL PROTECTED]; [EMAIL PROTECTED] GN: Sent: Friday, December 14, 2001 3:03 PM GN: Subject: RE: Order By number of rows returned ? GN: GN: GN: I'm not sure if you can do this all in one query.. GN: I tried a few JOINs, and nothing seemed to work. GN: However, I'm not up to speed on how to join things GN: together to get the best results. GN: GN: However, you can do it by creating a temp table: GN: GN: create table tmp01( GN: web_account char(4) not null default '', GN: count_wa int unsigned not null default 0 GN: ); GN: GN: INSERT INTO tmp01(web_account,count_wa) GN: SELECT web_account,count(web_account) AS count_wa GN: FROM lookup GN: GROUP BY web_account GN: ORDER BY count_wa DESC; GN: GN: SELECT lookup.web_account,lookup.code_short GN: FROM lookup,tmp01 GN: WHERE (lookup.web_account=tmp01.web_account) GN: ORDER BY tmp01.count_wa DESC; GN: GN: DROP table tmp01; GN: GN: GN: This is probably not the best solution to your problem. GN: GN: - GN: Johnny Withers GN: [EMAIL PROTECTED] GN: p. 601.853.0211 GN: c. 601.209.4985 GN: GN: -Original Message- GN: From: Girish Nath [mailto:[EMAIL PROTECTED]] GN: Sent: Friday, December 14, 2001 7:13 AM GN: To: [EMAIL PROTECTED] GN: Subject: Order By number of rows returned ? GN: GN: GN: Hi GN: GN: I'm trying to do some sorting by relevance on a query. Essentially, i'd GN: like GN: to know if there is way to order the results by number of rows returned GN: or GN: if this is the best i can get and do the rest within PHP? GN: GN: mysql SELECT web_account, code_short FROM lookup WHERE code_short IN GN: ('U', GN: 'S', 'G'); GN: GN: +-++ GN: | web_account | code_short | GN: +-++ GN: | A007| U | GN: | A007| S | GN: | J009| G | GN: | J009| U | GN: | J009| S | GN: | B001| U | GN: +-++ GN: 6 rows in set (0.00 sec) GN: GN: I'd like to order these so that J009 would be grouped at the top of GN: the GN: set because it was found in 3 rows, A007 would be placed after J009 GN: with GN: B001 last. GN: GN: Any ideas :) ? GN: GN: Thanks for your time. GN: GN: GN: GN: Girish GN: GN: GN: - GN: Before posting, please check: GN: http://www.mysql.com/manual.php (the manual) GN: http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail GN: [EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: GN: GN: GN: - GN: Before posting, please check: GN: http://www.mysql.com/manual.php (the manual) GN: http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Re: dbi accessor for mysql_insertid
DBI version 1.15 DBD::mysql version 2.0416 Blows up on trying to use $dbh-mysql_insertid(): Can't locate object method mysql_insertid via package DBI::db (perhaps you forgot to load DBI::db? Would you mind telling me what version you are running? Thank you. Regards, Rich At 03:36 PM 12/14/01, sherzodR wrote: $dbh-mysql_insertid() Rich Duzenbury wrote: RD: Date: Fri, 14 Dec 2001 14:15:36 -0600 RD: From: Rich Duzenbury [EMAIL PROTECTED] RD: To: [EMAIL PROTECTED] RD: Subject: dbi accessor for mysql_insertid RD: RD: Statement handles appear to have an accessor method to return the last RD: insert id: RD: $new_id = $sth-insertid; RD: RD: But I cannot seem to locate one for the database handle. The closest I RD: have found is the RD: $new_id = $dbh-{'mysql_insertid'}; RD: RD: In the case of a $dbh-do(...) where there is no statement handle, I have RD: been using the above. RD: RD: I'm concerned about writing code for the long term that references the RD: internals of an object. Is this guaranteed to stay this way forever? Or, RD: is there an accessor method on the database handle that I am not aware of? RD: RD: Regards, RD: Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlclient.lib compiling problem
no, I haven't fixed it yet ;-) Devore, Jacob wrote: How did you fix it, just use the dll? Thanks, jake -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:07 PM To: Devore, Jacob Cc: '[EMAIL PROTECTED]' Subject: Re: mysqlclient.lib compiling problem I've run into the same problem with mysql++'s msvc++ port mysql++.lib. Devore, Jacob wrote: I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dbi accessor for mysql_insertid
DBI Version: 1.19 DBD::mysql Version: 2.0416 Rich Duzenbury wrote: RD: Date: Fri, 14 Dec 2001 19:45:02 -0600 RD: From: Rich Duzenbury [EMAIL PROTECTED] RD: To: sherzodR [EMAIL PROTECTED] RD: Cc: [EMAIL PROTECTED] RD: Subject: Re: dbi accessor for mysql_insertid RD: RD: DBI version 1.15 RD: DBD::mysql version 2.0416 RD: RD: Blows up on trying to use $dbh-mysql_insertid(): RD: Can't locate object method mysql_insertid via package DBI::db (perhaps RD: you forgot to load DBI::db? RD: RD: Would you mind telling me what version you are running? Thank you. RD: RD: Regards, RD: Rich RD: RD: RD: At 03:36 PM 12/14/01, sherzodR wrote: RD: RD: $dbh-mysql_insertid() RD: RD: RD: RD: Rich Duzenbury wrote: RD: RD: RD: Date: Fri, 14 Dec 2001 14:15:36 -0600 RD: RD: From: Rich Duzenbury [EMAIL PROTECTED] RD: RD: To: [EMAIL PROTECTED] RD: RD: Subject: dbi accessor for mysql_insertid RD: RD: RD: RD: Statement handles appear to have an accessor method to return the RD: last RD: RD: insert id: RD: RD: $new_id = $sth-insertid; RD: RD: RD: RD: But I cannot seem to locate one for the database handle. The RD: closest I RD: RD: have found is the RD: RD: $new_id = $dbh-{'mysql_insertid'}; RD: RD: RD: RD: In the case of a $dbh-do(...) where there is no statement RD: handle, I have RD: RD: been using the above. RD: RD: RD: RD: I'm concerned about writing code for the long term that RD: references the RD: RD: internals of an object. Is this guaranteed to stay this way RD: forever? Or, RD: RD: is there an accessor method on the database handle that I am not RD: aware of? RD: RD: RD: RD: Regards, RD: RD: Rich RD: -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dbi accessor for mysql_insertid
That should be: $dbh-{mysql_insertid}; if retrieving from a database handle, otherwise use $sth-{mysql_insertid}; if from a statement handle. On Fri, 14 Dec 2001 19:45:02 -0600, Rich Duzenbury [EMAIL PROTECTED] wrote: DBI version 1.15 DBD::mysql version 2.0416 Blows up on trying to use $dbh-mysql_insertid(): Can't locate object method mysql_insertid via package DBI::db (perhaps you forgot to load DBI::db? Would you mind telling me what version you are running? Thank you. Regards, Rich Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question on mySQL replication
Hi Peter We use the mysql replication stuff here. Its very reliable, and the synchronization between master slave is pretty much instant. There does seem to be one problem when the master rotates its transaction logs, the slave does not pick it up and you need to manually issue reset slave to get it to go to the start of the first transaction log Tim - Original Message - From: Peter M. Perchansky [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 15, 2001 10:36 AM Subject: Question on mySQL replication Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? If the server the master was on went down unexpectedly, how much data would still be on the master that the slave(s) may not have picked up? Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlclient.lib compiling problem
At 16:52 14/12/2001 -0800, Devore, Jacob wrote: Hi, You need to specify the winsock.h header in your code and the wsock32.lib in the link libraries. Regards, Miguel I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqlclient.lib compiling problem
All is well now. Thank you for you help Miquel. jake -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:51 PM To: Devore, Jacob; '[EMAIL PROTECTED]' Subject: Re: mysqlclient.lib compiling problem At 16:52 14/12/2001 -0800, Devore, Jacob wrote: Hi, You need to specify the winsock.h header in your code and the wsock32.lib in the link libraries. Regards, Miguel I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stupid join question
i'm trying to join 3 tables. tables 1 and 2 contain information about a person, table 3 contains reviews of that person and may not have any data. outer join, right? i can't get it to work though. the tricky part is i don't want to return the actual data from the 3rd table, i just want the number of matching rows. is it possible to do in one query? here's what i have now: SELECT ad.id, name, age, audiogallery, DATE_FORMAT(ad.mtime,%m/%d), commentary1, count(review.id) FROM ad LEFT OUTER JOIN review ON ad.id=review.id, person, category, city WHERE cat = 'Singer' AND city = 38 AND adtype in (2,4,6) AND ad.id=person.id AND ad.id=category.id AND ad.id=city.id GROUP BY review.id ORDER BY age the part that's messing me up is the count(review.id) -- what am i doing wrong? -jsd- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php