In the last episode (Mar 16), Giuseppe Maxia said:
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.
Description:
operator NOT IN fails when a subquery returns one or more NULL
values.
Dan Nelson wrote:
In the last episode (Mar 16), Giuseppe Maxia said:
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.
Description:
operator NOT IN fails when a subquery returns one or more NULL
values.
Hi,
I have a column 'id' within a table :
CREATE TABLE `reference` (
*`*id*`* smallint(5) unsigned NOT NULL auto_increment,
`study_name` text,
`author` text NOT NULL,
`date` date NOT NULL default '-00-00',
`reference` varchar(250) NOT NULL default '',
`title` varchar(250) NOT NULL
Many many thanks... I was in confusion. But how can I exten the table
size.
Regards
Naveen
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Naveen C Joshi [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, March 15, 2005 7:52 PM
Subject: Re: To extend InnoDB table
Hi,
Is there any equivalent of set head off, set pause on in
mysql 4.0.21. set head off, set pause on work fine in oracle.
Please help me in this.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to
this
It looks from googling as though I need to drop all foreign key
constraints on this column, perform the change and then reestablish the
foreign keys. Could anyone confirm or advise of a better solution?
That is the way ! :)
You need to drop the constrains...
Alter `reference` and make `id` INT
Consider this:
v_age, v_name, v_eno are 3 variables.
Exec sql Select age into :v_age from temp where name = :v_name and eno
= :v_eno;
Suppose:
v_name =rama
v_eno = NULL
Table: temp
Suppose the values in my table are,
Name = rama
Eno = NULL
Age = 23
The
Hi
I was installing MySQL on Linux. At that time it was giving some problem
when I did ./configure.
Your libc libraries are not 100% compatible with MySQL version.
Mysqld should work normally with the exception that hostname resolving will
not work. This means that you should use IP address
Suc COUNT() only counts non-null values.
Suc More on topic...if you say COUNT(fieldname), you say that you want to
Suc count all of the non-null values in that column.
COUNT(1) or COUNT(2) or COUNT(any_constant) should count all records (this is
how it works for example in oracle)
--
Best
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT statement on server5
The code for generating the tables is shown below:
create table book
(
bookid char(12) not null,
dimensions char(15),
availability char(30),
booktype char(20),
publisher char(20),
isbn char(20),
itemsinstock int(3),
price float(5,2),
title char(50),
toc char(24),
picture char(36),
primary key
The code for generating the tables is shown below:
create table book
(
bookid char(12) not null,
dimensions char(15),
availability char(30),
booktype char(20),
publisher char(20),
isbn char(20),
itemsinstock int(3),
price float(5,2),
title char(50),
toc char(24),
picture char(36),
primary key
I want to upgrade mysql client 3.23. to mysql 4.1.10
But when I type rpm -Uvh mysql-client-4.1...rpm
It's says that some file from install mysqlrpm conflict with file from
package mysql3.23
I try to uninstall package mysql3.23 with the rpm on the cd, but it's doesn't
work
I
Gabriel PREDA [EMAIL PROTECTED] wrote on 03/16/2005 06:12:14 AM:
It looks from googling as though I need to drop all foreign key
constraints on this column, perform the change and then reestablish the
foreign keys. Could anyone confirm or advise of a better solution?
That is the way ! :)
Chris Mason wrote:
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT
You are confusing data retrieval with data presentation. Sure, SQL can do
many things to format data but some data formats are better achieved
through the programming language you are using to present this data for
viewing. In my opinion, the type of formatting you want to do is one of
those
oix ppl,
sorry for the question, but I looked in the Manual online and didn't find
nothing that do this that I'm looking for, so I'm hopping someone can help
me.
I'm looking for some way to know the size each row of a table uses in my
database (phisical - real disk space allocated or
You may be able to get something like what you describe using
GROUP_CONCAT(), if you have mysql 4.1, though it would be easier to get a
comma separated list of authors than separate lines. See the manual for
details http://dev.mysql.com/doc/mysql/en/group-by-functions.html.
In my opinion,
What are the implications of setting the --bdb-no-sync flag when
using the BDB storage engine. There isn't alot of documentation on
this.
Does this mean that after every transaction, sync will not be called?
When will sync be called then?
Will setting this flag lead to ACI semantics, ie no
Hi folks!
(I hope this is the right list ... if not please tell me where I can submit
this post)
I would like to create a MySQL UDF (i.e. User Defined Function) that embeds
a query; for instance, suppose the UDF is named foobar:
mysql SELECT foobar();
When foobar function receives the control
On Wednesday, March 16, 2005 09:30, sguazt sguazt wrote:
Hi folks!
(I hope this is the right list ... if not please tell me where I can
submit this post)
I would like to create a MySQL UDF (i.e. User Defined Function) that
embeds a query; for instance, suppose the UDF is named foobar:
Giuseppe,
mysql select 2 not in (1,null,3);
+-+
| 2 not in (1,null,3) |
+-+
|NULL |
+-+
1 row in set (0.00 sec)
# NOT OK
Isn't that standard SQL behaviour? NULL is not a value. NOT IN compares
the values using '=' and
Hi!
From: Tom Crimmins [EMAIL PROTECTED]
To: sguazt sguazt [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 10:09:16 -0600
...
Can you explain exactly what you are using this for? What benefit does this
provide over just executing the query?
You
Peter Brawley wrote:
Giuseppe,
mysql select 2 not in (1,null,3);
+-+
| 2 not in (1,null,3) |
+-+
|NULL |
+-+
1 row in set (0.00 sec)
# NOT OK
Isn't that standard SQL behaviour?
Yes, it is. As I said before, I was
sguazt sguazt [EMAIL PROTECTED] wrote on 03/16/2005 11:54:26 AM:
Hi!
From: Tom Crimmins [EMAIL PROTECTED]
To: sguazt sguazt [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 10:09:16 -0600
...
Can you explain exactly what you are
Hi,
A friend of mine asked me to have a look at one of his query, and I'm
stuck
Here was his query:
SELECT drugID, protID, COUNT(DISTINCT pmid),
MAX(s1.syn) AS o1, MAX(s2.syn) AS o2
FROM matches
INNER JOIN synonyms AS s1 ON drugID=s1.nameID AND s1.syn LIKE 'a%'
INNER JOIN synonyms AS s2
Hello,
I have released dataKiosk version 0.6.
DataKiosk is a JuK-like database interface tool for generic SQL databases.
What does that mean? Essentially, DataKiosk provides a series of wizards
(anyone familiar with Qt Designer's database wizards will find them familiar)
that allow you to
Dear MySQL Developers and Enthusiasts,
when I run these lines of code :
my $T_NO = 12569;
use DBI;
my $dbh =
DBI-connect(DBI:mysql:database=carr_search;192.168.0.1,user,password);
my $q = CREATE TABLE IF NOT EXISTS CS_? (
ID_NO MEDIUMINT,
NAME VARCHAR(30),
TYPE CHAR(1)
);
my $sth =
From: [EMAIL PROTECTED]
To: sguazt sguazt [EMAIL PROTECTED]
CC: mysql@lists.mysql.com,[EMAIL PROTECTED]
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 12:37:59 -0500
I can almost follow the logic of your pseudocode. Can you explain what
it is you are trying to compute? It seems as though
Hey,
The placeholders (?) are safely escaped by the DBI library -- your
query that gets submitted to the server actually looks like:
CREATE TABLE IF NOT EXISTS CS_ 12569 (
ID_NO MEDIUMINT,
NAME VARCHAR(30),
TYPE CHAR(1)
)
I think it puts the space in, but it might actually be quoting it.
I
I have a favorite technique for improving the results of queries , like
this, which involve fairly large JOINed tables. It's a form of
divide-and-conquer in that you pre-compute what you can then make the
JOINS you need to finish up the results.
I agree that the AND s2.syn LIKE '%' in the ON
Hi all,
I am using MySQL Command Line and have created a table called dtd_test. It
has two varchar fields at the moment. How can I add more fields? I want to add
a primary key column which autoincrements, how can I do that? Thanks a lot
Check out the alter table syntax in the manual at:
http://dev.mysql.com/doc/mysql/en/alter-table.html
On Wed, 16 Mar 2005 14:56:59 -0500, Ed [EMAIL PROTECTED] wrote:
Hi all,
I am using MySQL Command Line and have created a table called dtd_test. It
has two varchar fields at the moment.
http://dev.mysql.com/doc/mysql/en/alter-table.html
ALTER TABLE dtd_test ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD
PRIMARY KEY (id);
On Wed, 16 Mar 2005 14:56:59 -0500, Ed [EMAIL PROTECTED] wrote:
Hi all,
I am using MySQL Command Line and have created a table called dtd_test. It
has
Hi,
i'm using the 4.1.10 version of mysql.
If I do :
select max(timestamp + 0 ) as timestamp from news;
++
| timestamp |
++
| 20050314194920 |
++
so i got the full timestamp(14), but if I do :
select max(timestamp) + 0 as timestamp from news;
Marco,
I think I understand why you might want the end date of your projects to
be dynamically calculated (assuming that's why you want this calculation
to be a UDF?). You would be able to change a starting date, the project's
duration, or add or delete a holiday and your ending dates would
I am trying to update a link table (table with two primary keys) where I
want to update all rows where the first primary key is a set value (for
example, change key1 from 10 to 20), but I only want to update these
where the resulting primary key does not already exist in the table
(otherwise an
Mister Jack wrote:
Hi,
i'm using the 4.1.10 version of mysql.
If I do :
select max(timestamp + 0 ) as timestamp from news;
++
| timestamp |
++
| 20050314194920 |
++
so i got the full timestamp(14), but if I do :
select max(timestamp) + 0 as
I need to modify the value of file names in a table. The strings represent
an image file path and are stored in a char column in the table. Here is a
sample of the values:
\products\1_TH.JPG
\products\2_TH.JPG
I would like to perform the following
UPDATE test.Items SET Desc='New'+Desc
I've
It returns :
select max(timestamp) as timestamp from news;
+-+
| timestamp |
+-+
| 2005-03-14 19:49:20 |
+-+
and also :
select timestamp as timestamp from news limit 1;
+-+
| timestamp |
You can do left joins in an update.
mysql show create table t;
+---+---
--
| Table | Create Table
+---+---
--
| t | CREATE TABLE `t` (
`key1`
Look for concat :
http://dev.mysql.com/doc/mysql/en/string-functions.html
On Wed, 16 Mar 2005 15:51:34 -0500, David DeSana
[EMAIL PROTECTED] wrote:
I need to modify the value of file names in a table. The strings represent
an image file path and are stored in a char column in the table. Here
I just downloaded the 4.1.10a release for Solaris 8 and 9 (32bit). It
seems that it is no longer in a tar archive. Was this change
intentional?
I cant find any mention of it on the web site. How do I unpack the new
format into a given directory?
Thanks,
Jo
Mister Jack wrote:
It returns :
select max(timestamp) as timestamp from news;
+-+
| timestamp |
+-+
| 2005-03-14 19:49:20 |
+-+
The string shown above converted into a number is 2005.
( Unless you think ist should be 1988 )
From the manual :
MIN() and MAX() may take a string argument; in such cases they return
the minimum or maximum string value.
so I understand that for a timestamp column, values are converted and
then compared as strings, then the function return a string, so adding
+ 0 convert it to a number
Thanks for the replies, works fine, I checked out the alter table syntax and
added a new field. How can you add two new fields I tried with
ALTER TABLE DTD_Test add template_header varchar(255), template_footer
varchar(255);
but i get an error. Cheers
See my original post:
ALTER TABLE dtd_test ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD
PRIMARY KEY (id);
Primary key could've just as easily been another column. You have to
include another ADD command after the comma.
On Wed, 16 Mar 2005 15:25:14 -0800, Scott Klarenbach
[EMAIL
I know the password for MySQL Command line client so I can login and create and
modify dbs etc. I am trying to create a MySQL datasource in coldfusion with the
MySQL (3.x) driver. It is asking me for the username, is there any way to find
that out from MySQL Command line client or is there a
Thanks Kristen I am root
- Original Message -
From: Kristen G. Thorson [EMAIL PROTECTED]
To: Ed [EMAIL PROTECTED]
Sent: Wednesday, March 16, 2005 6:49 PM
Subject: Re: Where do I get the Username?
If you do not supply a username at the command line, MySQL will assume you
are logging in
Using the OSX MySQL Administrator, when Stop Server is clicked under
the Service tab, the server doesn't stop. In fact, the only way I
have been able to quit the MySQL process is through the Activity
Monitor, and a force quit at that. What's up with that?
Jeff
--
MySQL General Mailing List
Have you tried
mysqladmin -u root -p shutdown
in Terminal?
Michael
Jeff Justice wrote:
Using the OSX MySQL Administrator, when Stop Server is clicked under
the Service tab, the server doesn't stop. In fact, the only way I
have been able to quit the MySQL process is through the Activity
Hello Ed,
I am nost sure what you are trying to say, but is it possible that you
login as user root ?
I assumed that you probably just installed mysql and are new to mysql.
Best regards
Nils Valentin
I know the password for MySQL Command line client so I can login and
create and modify
I have this table:
mysql select historyvlan_time, historyvlan_vlan, v.clienthistory_id from
pe_historyvlan as v join pe_clienthistory using (clienthistory_id) order by
historyvlan_vlan, historyvlan_time desc;
+--+--+--+
| historyvlan_time |
It should be in mysql's bin directory, typically /usr/local/mysql/bin. You
either need to add that to your PATH,
export PATH=$PATH:/usr/local/mysql/bin
or use the full path when executing the command
/usr/local/mysql/bin/mysqladmin -u root -p shutdown
I'd recommend the former, and I'd
You've misunderstood how GROUP BY and MAX() work. GROUP BY divides your
data into groups, and aggregate functions such as MAX() tell you something
about each group, but they *do not* return *rows* from your table. Consider
the following example rows in a larger table:
cat val1 val2
Thanks for answering!
Your solution would be right if I can modify the database (and I have no
control on software that populate tables).
Unfortunately I can do only queries on that db; so the due date has to be
recalculated every time I want to perform the main report (that use the
ending
In article [EMAIL PROTECTED],
Giuseppe Maxia [EMAIL PROTECTED] writes:
The whole point is actually in subqueries, not when using IN or NOT IN in a
normal query.
The bug occurs when a NOT IN is used in a subquery as a LEFT JOIN replacement.
SELECT something from t1 where column1 NOT IN
57 matches
Mail list logo