subquery fails when a NOT IN operator tests a subset with NULL valu

Hi. Here is a description of what looks like a serious bug. This is related to bugs #7294 and #6247 Tested against mysql 4.1.9 and 4.1.10. Cheers Giuseppe Maxia >Description: operator NOT IN fails when a subquery returns one or more NULL values. >How-To-Repeat: simple proof of conce

Re: lost connection DURING query?

I got the same error when my web server and mysql server were separate. And the error was caused bcoz of too many unauthenticated users. The reason behind it was that the reverse dns lookup for the webserver was failing. but as soon as i added the web server to /etc/hosts, the error went off. H

Hide password when running mysqldump from a batch

> --- > What you really want to avoid is having the password on the commandline. > File permissions won't matter at all if you end up running a command > that puts your password in the output of 'ps'! Command lines are always > public info

Re: Stuck with older version of MySQL on RH9, want to install latest, but cant

Thanks for helping brian, While I was going through some sites where people had posted some trouble, I found this guy who had successfully installed the server, client and dev package. All I had to do was rpm -Uvh --nodeps I am not sure of the --nodeps, but i think it was there, but in any event,

bulk download via php

I know phpmyadmin does this, but I can not find a reference to an example. I need to allow a client daily download of very large batches of mysql records, I would like to stream this data to a download file, perhaps even gzip it in the process, any links? -- ---

Q: Suggested reading

Hi list, I've been using MySQL for small databases for 6 - 7 years (if I recall correctly), from php/web-applications to ODBC-applications in various languages and the native C API from C and C++ applications. The databases so far has varied from a few hundreds kbytes to a few gigabytes. Now I'm

Re: Two columns query from a single column table?

Hi there! The SELECTs within the SELECT didn't work. : ( I'm looking to return from one table, half on the left side, and half on the right side. This is: from row 1 to row on the left, and from row to the end on the right. TIA Mensaje citado por Scott Klarenbach <[EMAIL PROTECTED]>: > SELEC

Re: Two columns query from a single column table?

On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] wrote: > > I need to do this: > From this table > +--+ > |id|Data | > |--|---| > | 1|Something 1| > | 2|Something 2| > | 3|Something 3| > | 4|Something 4| > | 5|Something 5| > | 6|Something 6| > +--+ > > G

Re: Two columns query from a single column table?

SELECT (SELECT id from data WHERE id=1), (SELECT id from data WHERE id=4); This willl return you the 2 columns in one row. Otherwise, if you're looking to return multiple queries into one result set, then UNION is what you're looking for. ie (select id from data) UNION (select id from data). O

Re: Two columns query from a single column table?

Oh, sorry, I didn't look close enough at your question...never mind :-) On Tue, 15 Mar 2005 16:02:59 -0800, Scott Klarenbach <[EMAIL PROTECTED]> wrote: > SELECT id, id FROM data should work just fine. > > > On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > wrote: > >

Re: Two columns query from a single column table?

SELECT id, id FROM data should work just fine. On Tue, 15 Mar 2005 17:43:29 -0600, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi there! > > I need to do this: > From this table > +--+ > |id|Data | > |--|---| > | 1|Something 1| > | 2|Something 2| > | 3|Something 3| >

Two columns query from a single column table?

Hi there! I need to do this: >From this table +--+ |id|Data | |--|---| | 1|Something 1| | 2|Something 2| | 3|Something 3| | 4|Something 4| | 5|Something 5| | 6|Something 6| +--+ Get this query +-+ |id|Data |id|Data | |-

Re: Query Problem

Xristos Karvouneas wrote: Dear All, I am faced with the following problem: I have got three tables - book,author and authorbook - containing information about books and authors (some books have multiple authors). I want to do a query that would print information like: Title 1 Author 1

Query Problem

Dear All, I am faced with the following problem: I have got three tables - book,author and authorbook - containing information about books and authors (some books have multiple authors). I want to do a query that would print information like: Title 1 Author 1 Author 2 Title 2

RE: Compressing after Deletion

David, According to the documentation, OPTIMIZE will also work on InnoDB tables. Will that produce the same result as your ALTER TABLE ? Cheers Terry - Original Message - > Hi Chris, > > For MyISAM/BDB tables use OPTIMIZE TABLE ; > For InnoDB tables try ALTER TABLE TYPE=InnoDB; > >

FW: SELECT assistance

-Original Message- From: Richard Whitney [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:54 AM To: Jay Blanchard Subject: RE: SELECT assistance Quoting Jay Blanchard <[EMAIL PROTECTED]>: > [snip] > I have a table containing three columns: > > Int intint > +--

RE: SELECT assistance

[snip] I have a table containing three columns: Int intint ++-++ | id | serialbegin | serialend | ++-++ | 1 | 10 | 20 | ++-++ And say we have serial number 11. Is there a way

SELECT assistance

I have a table containing three columns: Int intint ++-++ | id | serialbegin | serialend | ++-++ | 1 | 10 | 20 | ++-++ And say we have serial number 11. Is there a way to SELE

Re: lost connection DURING query?

Luke - Original Message - > This error message seems a bit different than others I have gotten. it > is from a ColdFusion server that uses an ODBC driver... > ODBC Error Code = S1000 (General error) Which version of CF are you using? If it is MX6.1, surely you can use a native MySQL

Re: MySQL vs PostgreSQL

On Tue, 15 Mar 2005 18:49:38 +0900 ninjajs <[EMAIL PROTECTED]> wrote: > What do you think about MySQL vs PostgreSQL ? Both are great products and have their ups and downs. On a MySQL list you will not get an un-biases answer to this question. If you really want to know what people on the MySQL

Stuck with older version of MySQL on RH9, want to install latest, but cant

Hi, I am trying to install the latest version of MySQL(i am not sure 4.0.23? currently in the office). The RH9 comes with some 3.2.xx version, I try to run rpm -U to upgrade but that doesnt work, I try to install it doesnt work and I try to remove mysql that doesnt work either. I went to Add and Re

Re: To extend InnoDB table size

Naveen C Joshi wrote: Hi, I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI". These are MyIsam, not InnoDB. Currently the table size is fixed 4GB and I want to extend it 10GB. Could you please give me perfe

RE: lost connection DURING query?

this query is "select * from ogcount" which is a table containing 1 record, so probably not the packet size, though that's very good info to know. I'm going to see if I get the same error if I use a JDBC driver instead of ODBC. -L Luke Crouch 918-461-5326 [EMAIL PROTECTED] -Original

Re: lost connection DURING query?

"Crouch, Luke H." <[EMAIL PROTECTED]> wrote on 03/14/2005 09:34:02 AM: > This error message seems a bit different than others I have gotten. > it is from a ColdFusion server that uses an ODBC driver... > ODBC Error Code = S1000 (General error) > > > [MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log

Re: Multi-Table Query Problem...

"Nick Zukin" <[EMAIL PROTECTED]> wrote on 03/14/2005 05:22:38 PM: > I'm trying to do a multitable query and am having problems. > > I have three tables: vendors, products, and vendorproducts. The > vendorproducts table creates a many to many relationship between the vendors > and the products. T

Re: Optimising COUNT()

"Stembridge, Michael" <[EMAIL PROTECTED]> wrote on 03/14/2005 02:18:25 PM: > I noticed another listmember used COUNT(fieldname) instead of COUNT(*). > > Is there a noticeable performance increase with COUNTing a column name > instead of all columns? (ie, like SELECTing specific columns instea

To extend InnoDB table size

Hi, I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI". Currently the table size is fixed 4GB and I want to extend it 10GB. Could you please give me perfect command to extend my table size. The is my produ

Re: temporary tables

Hello. A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. So, I think, they won't solve your task. Ted Toporkov <[EMAIL PROTECTED]> wrote: > List, > > I'm trying to create tables that will store data temporarily, i

date of end support (security update)

Hi i am searching the date of the end of support for the different versions of mysql where can i find them? thx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: character encoding problem-have read docs and search mailing list -but..

in addition i also need to save and load korean, simplified chinese, traditional chinese, japanese and english in the same record. have any suggestion ? __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.y

Re: temporary tables

Ted Toporkov <[EMAIL PROTECTED]> wrote on 15/03/2005 11:04:09: > List, > > I'm trying to create tables that will store data temporarily, if a php > page generates data to fill the table, then any number of queries could > be run on the table, and then be automatically be deleted if it's not >

character encoding problem-have read docs and search mailing list -but..

hi, i am migrating a legacy java application. so i am not suppose to change too much things. the problem is that the app store in multiple language such as korean and english. if i load again the new saved data, then korean language will only be like ',???' old data are ok. displayed in

temporary tables

List, I'm trying to create tables that will store data temporarily, if a php page generates data to fill the table, then any number of queries could be run on the table, and then be automatically be deleted if it's not queries for let's say an hour or something like that. Can this be accomplish

SQL-Syntax Check

Hello Users does anyone know a tool or a way for validation sqlcode on the command_line??? For example ./sqlsyntaxchecker < "select * f test" --> Error not valid sql syntax thx christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Re: How to add 2 columns to a table with "After ColName"???

mos wrote: I've tried just about every syntax combination to try and add columns to a table using Alter Table and I keep running into syntax errors. Alter table MyTable add (newcol1 float after col3, newcol2 float after col3); or Alter table MyTable add (newcol1 float, newcol2 float) after col3

RE: MySQL vs PostgreSQL

Perhaps a quick search at a list archive will give you the answers you are looking for. This was discussed at length about 6 months ago and the messages are still at gmane. Just page through and you will find many messages with just this subject. http://search.gmane.org/search.php?group=gmane.comp

MySQL vs PostgreSQL

Hi, What do you think about MySQL vs PostgreSQL ? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reg creating log

Hello. You should also redirect stderr to the output file. The way it's done depends on the used shell. But usually you should use '2>' instead of '>'. [EMAIL PROTECTED] wrote: > > Hi, > Thank you for your reply. I tried even with --tee option with > mysql as follows > > Mysq

Re: Wrong bytesec nightmare!

Hello. You may use --extend-check option with myisamchk, but usually it finds a lot of garbage, and should be used as a last resort. Francisco Lopez <[EMAIL PROTECTED]> wrote: > Hello all, > I am getting quite desperate on this, since I've been trying to recover > my diary of a who

Re: Problems with a full backup

Hello. You may use --default-character-set=charset command line option for mysqldump. Without this option mysqldump uses UTF8 encoding, which can cause a problem. See: http://dev.mysql.com/doc/mysql/en/mysqldump.html Javier Ballesteros Correa <[EMAIL PROTECTED]> wrote: > Hi! I'm le

Re: Access Denied

Hello. Using the general-log you could find if something changes the grant tables. See: http://dev.mysql.com/doc/mysql/en/query-log.html Also I strongly recommend you to upgrade to the latest release, if you don't use it already. >so whats the final solution to my problem ? :( >

Re: mysql-query-browser-bin: error while loading shared libraries: libtiff.so.3

Hello. >libtiff.so.3: cannot open shared object file: No such file or >directory I think, you should get the version of library which mysql-query-browser wants. Billy Pilgrim <[EMAIL PROTECTED]> wrote: > Hello, I am trying to run mysql query browser on debian, but... > > # ./mysql-

Re: Delays in replication and internet latency

Hello. I think that the speed of every single update which slave get from the master will grow, and slave could receive updates more frequently. But only practical usage will show the influence of this option in your case. "Andrew Braithwaite" <[EMAIL PROTECTED]> wrote: > Hi, > >

Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box

Hello. >050314 1:31:06 /usr/sbin/mysqld-max: Shutdown Complete Your error file has this record. And you said that you'd installed only: > - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm > - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm There are no mysqld-max in listed rpms

Re: Auto loading a table

Hello. >still stop at the 10M limit on memory tables anyway. What's the value of max_heap_table_size? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html [EMAIL PROTECTED] wrote: > Thanks that gives me options, yes table was already created what I wanted > was f

Re: query

Hello. > the following query causes the mysqld server to close Yes. MySQL 5.0.2 not yet stable as we want. You may look in the error log to find the clues of shutdowns. See: http://dev.mysql.com/doc/mysql/en/error-log.html But I recommend you to upgrade to the latest bk source, which

Re: Alter statement doesn't work in 5.0.2

Hello. Use such alter statement: alter table mytable change a a int default '1'; Every thing works fine on the MySQL 5.0.3 (from the latest bk source): mysql> CREATE TABLE `mytable` ( -> -> `a` int(11) NOT NULL, -> -> `b` int(11) NOT NULL, -> -> `c` int(11) default NULL

QUOTE() function, what happens here?

Dear list, I don't understand what happens here: shell> mysql -N -e "SHOW VARIABLES LIKE 'version';" test +-++ | version | 4.0.14-log | +-++ shell> mysql -e "CREATE TABLE foo (sometext VARCHAR(255));" test shell> mysql -e "INSERT INTO foo VALUES('Pitt\\'s

Re: compilation problems with 4.1.10a on Tru64 5.1

Hi! Am Di, den 15.03.2005 schrieb Heikki Tuuri um 8:21: > Douglas, > > - Original Message - > From: ""Douglas B. Jones"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, March 14, 2005 11:19 PM > Subject: compilation problems with 4.1.10a on Tru64 5.1 > > > >