Thanks for the suggestion.
This is not ideal for a couple of reasons: I'm using an object-relational
layer that would have to be hacked up something fierce, and my actual
query would be pretty hairy:
(select * from t1 where a=x
union select t1.* from t1,t2 where t1.b=t2.b and t2.c=y
union select
Even though we don't know what exact query produces this, is there a way to
raise it up to the MySQL team to take a look at? It seems to be more than a
random occurrence. Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "[EM
Hello-
I just installed mySql 4.0.14-0 onto my redhat 9.0 based laptop. Everything works
fine except that there are ten copies of mysqld running. I have removed the
/etc/my.cnf file, changed the file, restored the file and nothing changes the number
of daemons running. Another guy I worked w
Jeff, thanks for our ".02".
I'm about done with my second SQL book so after reading your words the
company just bought mePauls Mysql book.
Thanks for your opinion.
SJohnson
On Mon, 4 Aug 2003 12:14:29 -0400 "Jeffery C. Baldwin" wrote:
> Just to drop my $.02 in on this.. I started reading the 1s
Have you tried using the UNION statement? That worked great for me.
So, something like:
(select * from sometable where f1 = 123)
UNION
(select * from sometable where f2 = 123)
?
--
Rudi Benkovic [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql
Forgive me, that example is no good.
Oddly, it works, but the following does not:
mysql> create temporary table x (y int, z int, q int, index (y, z)); insert into x
values (1,2,3), (3,4,5), (5,6,7); explain select * from x where y = 1 or z = 1;
Query OK, 0 rows affected (0.00 sec)
Query OK, 3 ro
That doesn't seem to work (and not with bigger table either):
mysql> create temporary table x (y int, z int, index (y), index(z)); insert into
x values (1,2), (3,4), (5,6); explain select * from x where y = 1 or z = 1;
Query OK, 0 rows affected (0.00 sec)
Query OK, 3 rows affected (0.00 sec)
Rec
I am just learning mysql and I'm trying to write a cgi to update the
database from a form. Also just learning Perl. I have the following script
started that is called by an HTML form. I get the follwing message when I
execute it. Where can I find the message descriptions.
DBI::st=HASH(0x1b31f28)
I am fairly much a beginner and have probably done something
wrong but version 4.0.12 will not let me in.
I have been using MySQL (via MySQL Front and PHPMyAdmin as
interfaces usually) on a
Windows ME PC with Apache, all just for learning databases, SQL
and PHP. I learn slowly since I have to do a
At 16:57 -0400 8/4/03, walt wrote:
Jean Hagen wrote:
Hey,
having trouble running mysqlcheck from a script. Running 4.0.13 on
Linux. I can run the following command:
/usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair >
/var/log/mysql/check_tables.log
from the command line,
At 15:14 -0500 8/4/03, Jean Hagen wrote:
Hey,
having trouble running mysqlcheck from a script. Running 4.0.13 on
Linux. I can run the following command:
/usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v
--auto-repair > /var/log/mysql/check_tables.log
from the command line, plug in the p
Jean Hagen wrote:
>
> Hey,
>
> having trouble running mysqlcheck from a script. Running 4.0.13 on
> Linux. I can run the following command:
>
> /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair >
> /var/log/mysql/check_tables.log
>
> from the command line, plug in the passw
At 21:47 +0100 8/4/03, Fawad Siddiqui wrote:
Dear all,
Thank you very much for all your responses.
I have settled on the at least one book, SQL Queries for Mere
Mortals: A Hands-On Guide to Data Manipulation in
SQL by Michael J. Hernandez, John L. Viescas.
I would, however, ask Paul to recommen
Gary Broughton wrote:
Hi all
I've just recoded a website in PHP from ASP, running off IIS 5. It has
been tested by a dozen users over the weekend, but now I have put it
live the CPU utilisation is up at 100%, mainly swallowed up by
mysql-nt.exe. I wondered if anyone could offer any advice as to
Dear all,
Thank you very much for all your responses.
I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On
Guide to Data Manipulation in
SQL by Michael J. Hernandez, John L. Viescas.
I would, however, ask Paul to recommend one from his list of numerous titles, that
At the conference a few months ago, the mysql team said that the
benchmarks they where running would be published
here
http://www.mysql.com/benchmarks but it doesn't look like this is the
link.
Basically I'm trying to figure out what a saturation level is for mysql
when it has 2 2.4Ghz Intel XE
Hey,
having trouble running mysqlcheck from a script. Running 4.0.13 on
Linux. I can run the following command:
/usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair >
/var/log/mysql/check_tables.log
from the command line, plug in the password at the prompt, and everything
wo
Joshua,
Joshua Spoerri wrote:
Which version is targetted for optimization of OR searching on two keys,
that is, "select * from sometable where f1 = 123 or f2 = 123",
as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html
?
As described there MySQL can use only one index per table.
Thank you Gerald.
That was the problem. I thought I read that FILE permission could not
be set to a specific table so I was using somedatabase.*.
David Scott
On Monday, August 4, 2003, at 11:42 AM, gerald_clark wrote:
Since you don't show your grant statement, it is difficult tell
Thanks, that did it!
Jeff
> -Original Message-
> From: Kevin Fries [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 04, 2003 3:05 PM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: RE: Query Help
>
>
> So you want to group by the customer, but only show those
> gorupings with a count
Hey There,
Our MySQL database server is:
1. Sun Ultra Enterprise 4500 System Chassis with SBus I/O
4. 6 System Boards, each with 2 UltraSPARC II 400 mhz CPU's and 2 GB's
of memory (12 CPU, 12 GB memory)
2. 1 SBus I/O board, with SCSI-2 and dual fibre channel interfaces on
it.
3. The SCSI-2 inte
So you want to group by the customer, but only show those gorupings with
a count > 5.
That means you want to apply your restriction after the GROUP BY. Thus,
the clause goes into the HAVING area.
Try:
Select count(*), cust.id
from cust
where cust.time > UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1 HO
Thanks walt. Actually I use "mysqlcheck" to check the databases. This can
be safely run while the server is in use.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Richard Gabriel" <[EMAIL PROTECTED]
I have a table that records connections from customers to our server.
When there is a software problem with our customer's that have older
versions of our software, it will dial our server constantly over and
over again.
I want to be able to detect this by having a query that does something
like
Since you don't show your grant statement, it is difficult tell you what
the problem is.
Since FILE is a global permission you need to grant it on *.* not
somedatabase.*
David Scott wrote:
Greetings all
I am not able to GRANT file permission to users. All permissions end
up being issued with
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
Sir,
My name is Reji.Iam studying for a master degree in computer applications.Iam new
to mySQL.I don'
Greetings all
I am not able to GRANT file permission to users. All permissions end up
being issued with FILE being left out. What could I be missing? I
running 3.23.53 on Mac OS 10.2.
Thank you.
-
David Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Mark,
I agree there is no reason for the sub-select. I'd make one change in
response to the original request - asking for the most recent item.
Take Mark's statement and suffix "AND m.KeyDate = MAX(m.KeyDate);" to
the last "WHERE" statement (see example).
UPDATE main m, sub s
SET m.Value = s.
On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote:
> I have been getting this type of error ever since I upgraded from MySQL 3
> to 4. I actually have set up a cron to check/repair tables hourly because
> of this. The following diagnoses have been suggested, but I would bet it's
> an obscu
I have been getting this type of error ever since I upgraded from MySQL 3 to
4. I actually have set up a cron to check/repair tables hourly because of
this. The following diagnoses have been suggested, but I would bet it's an
obscure MySQL bug:
1. Kernel 2.4.18 IO problem
2. Another shared libra
Hey Kevin,
Ya I know thousands of items in the IN clause is not a good way, and it
takes a while but from all the other process I've tried it has been
actually the quickest (join for instance takes longer on my tests). Like
yourself though I'm quiet clueless on what another way to do this might
be
Paul's book is long, but like good code, it's modular, so the length isn't an issue.
> From: "Jeffery C. Baldwin" <[EMAIL PROTECTED]>
> Date: 2003/08/04 Mon AM 11:14:29 CDT
> To: "'Paul DuBois'" <[EMAIL PROTECTED]>, "'Asif Iqbal'" <[EMAIL PROTECTED]>,
> "'Ralph Guzman'" <[EMAIL PROTECTED]>
>
what is so bad at seeing the table structure?
i mean to work with the table, you need to know the fields and their types to avoid
syntax errors.
and what should happen on a SELECT * FROM...? do you want to see nothing, because it
would let the user know about the structure, or all fields, as norm
Yes, indeed! Sorry for mistake.
I'd like to know functions in MySQL I can use for replacing.
For example: in the docs it's writing about xxx_reset "This function is
called when MySQL finds the first row in a new group. ".
I need the description of such kind of the functions which can be wrapped
and
- Original Message -
From: "Andy Jackman" <[EMAIL PROTECTED]>
To: "Mattias Larsson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 02, 2003 4:23 PM
Subject: Re: Adv. Mysql query
> Mattias,
> It may not be such a good idea to store the 6 items in 1 record. An
> altern
On 4 Aug 2003 at 12:06, Jeffery C. Baldwin wrote:
> Anyone notice the problem? Even though I get no error.. the sampdb is
> not being greated.
When are you attempting to create it? All you've shown is a GRANT
statement, which creates *permissions* for the database (and works
even if the datab
At 12:14 -0400 8/4/03, Jeffery C. Baldwin wrote:
Just to drop my $.02 in on this.. I started reading the 1st version of
Pauls' MySQL book online a week or so back using my account over at
'Safari', once I read a little and decided that I was genuinely
interested in this MySQL 'thing', I went over t
A GEEZ! I apologize to all, I did not take the time to 'think'
before I wrote.
Sorry for the waste of bandwidth :-)
And thank you to Leonardo for the reply.
Jeff
-Original Message-
From: Leonardo Rodrigues Magalhães [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 12:21 PM
"Jeffery C. Baldwin" wrote:
>
> Hello All -
>
> I'm just started the process of learning MySQL and databases in general.
> I just bought the book 'MySQL' written by Paul DuBois, who I gather is
> really active in this community.
>
> Anyhow.. Here's the problem that I'm having.
>
> mysql> GRANT
Just to drop my $.02 in on this.. I started reading the 1st version of
Pauls' MySQL book online a week or so back using my account over at
'Safari', once I read a little and decided that I was genuinely
interested in this MySQL 'thing', I went over to Barnes and Noble with
intentions of getting a h
Jonathan Patton wrote:
>
> I have mysql setup on two computers with identical databases. When I run a group of
> queries on the one computer I get back an error 127 which I checked on an it appears
> to be a table corruption error. On the other computer, the queries run fine. Since
> I had all
Hello All -
I'm just started the process of learning MySQL and databases in general.
I just bought the book 'MySQL' written by Paul DuBois, who I gather is
really active in this community.
Anyhow.. Here's the problem that I'm having.
mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDEN
At 16:40 +0300 8/4/03, Primaria Falticeni wrote:
Hello,
I want to make some extensions for MySQL in C/C++.
Please give me some samples. I read the documentation but I didn't find
anything about this.
Thanks Anticipated,
Iulian
What do you mean by "extension"?
If you mean user-defined function, th
At 21:04 -0400 7/31/03, Asif Iqbal wrote:
I just ordered this book
MySQL
The definitive guide to using, programming,
and administering MySQL 4
by Paul Dubois
I found it more technical than MySQL cook book by Paul Dubois
Comparison information:
http://www.kitebird.com/mysql-book-comparison.php
Th
Your primary query has no where clause, so you are setting all Value to
a value from a random record for the most recent date.
Hardly looks like a 'bug' to me.
And why the cross post?
Daniel Kiss wrote:
Hi all,
I have two tables
CREATE TABLE main (
ID int not null,
Value int
);
CREATE TAB
Hello,
Would you help me with some samples for making a MySQL extension in C/C++?
Please!
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Surely this will just work?
update main,sub set main.Value = sub.subValue where main.id=sub.mainid;
Or have I misunderstood what you are wanting?
--
Mark
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 04, 20
Daniel Kiss writes:
> Hi all,
>
> I have two tables
>
>
> CREATE TABLE main (
>ID int not null,
>Value int
> );
>
> CREATE TABLE sub (
>mainID int not null,
>KeyDate date not null,
>SubValue int not null
> );
>
>
> I want the Value field in the main table to be set to the
Hi all,
I have two tables
CREATE TABLE main (
ID int not null,
Value int
);
CREATE TABLE sub (
mainID int not null,
KeyDate date not null,
SubValue int not null
);
I want the Value field in the main table to be set to the latest SubValue
in the sub table.
I suppose this syntax should w
Dear MySQL Contributors,
I am studying for a Master's degree with Henley Management College in
the UK, and in the past have used a variety of Open Source Software.
As part of my course I am conducting a survey in an attempt to identify
the critical success factors for Open Source projects. If you
I have mysql setup on two computers with identical databases. When I run a group of
queries on the one computer I get back an error 127 which I checked on an it appears
to be a table corruption error. On the other computer, the queries run fine. Since I
had all the data for the table in questio
Hi all
I've just recoded a website in PHP from ASP, running off IIS 5. It has
been tested by a dozen users over the weekend, but now I have put it
live the CPU utilisation is up at 100%, mainly swallowed up by
mysql-nt.exe. I wondered if anyone could offer any advice as to why
this could be (the
Hello,
After recently replicating using the stop databases and copy innodb and
mysql files method, things were fine...
Until the slave thread stopped complaining about duplicate rows after
one of our developers did a LOAD DATA INFILE operation on the master.
Unfortunately the insert's are into
At 16:06 4/8/2003 +0200, Morten Gulbrandsen wrote:
Hi,
Just copy c:\mysql\lib\opt\libmysql.dll into
the c:\mysql\bin directory.
When is final release of 4.1.0 scheduled please ?
I highly appreciate and thank you all eternally for
Enabling nested selects like
SELECT article, dealer, price
FROM
Hello programmers
this is my path,
C:\mysql\bin>path
PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\mysql\bin
After installing 4.1.0-alpha-max-debug
I try to start winmysqladmin.exe
Then I get this error,
===
Die dynamic link library libmysql.dll wurde nicht im angegebenen Pfad
Jan Josefowicz <[EMAIL PROTECTED]> wrote:
> I'm trying to change the value of max_connections variable but mysqld
> doesn't accept that.
> I use mysql 3.23.54 and my config file /etc/my.cnf looks like:
>
> [mysql.server]
> ...
> ...
> set-variable max_connections=200
>
> After a newstart of mysq
Hello,
I want to make some extensions for MySQL in C/C++.
Please give me some samples. I read the documentation but I didn't find
anything about this.
Thanks Anticipated,
Iulian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
"Miroslav I." <[EMAIL PROTECTED]> wrote:
>
> suppose you have a table with great number of columns (20 or 30),
> and you would like to specify every one but two or tree columns in a SELECT
> statement.
>
> Is there a way to specify only those two or tree columns for omission (which would
> be t
[EMAIL PROTECTED] wrote:
>
> I've installed 4.0.13 on a WinXP system. The service starts and stops just fine,
> but I cannot connect to the server, nor can I ping the 3306 port. I think the
> problem may be failure to complete the post-installation processing. The doc says
> to run installd
If you give access rights to a user on a DB, he will always be able to
see the table structure. This is how it is implemented in MySQL (which
does not mean that I like this).
Cheers
/rudy
-Original Message-
From: QWERTY [mailto:[EMAIL PROTECTED]
Sent: maandag 4 augustus 2003 14:47
Hello,
Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4
You want to give a specific permission to a user named USER1
For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1.
Or load the date into a column date_str and then convert and copy the
date into a column date AFTER loading.
Cheers
/rudy
ps: I already posted a function of how to convert this date format into
a MySQL date format somewhere on this list (prev month I think)
-Original Message-
From: Jay
[snip]
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
[/snip]
LOAD DATA INFILE cannot do the conversion "on-the-fly". You could use a
scripting language (sed, awk,etc.) to read and convert the dates.
HTH!
--
MySQL General Mailing List
How do you convert a date dd/mm/ from a .txt file
into mysql date
format when using LOAD DATA INFILE ?
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archiv
Replication just executes the commands in the binary log (i.e INSERT,
UPDATE, DELETE, ...). So if you make sure that you do not issue a DDL
for creation/altering in the master DB, everything should work fine.
However, I would advice against it (it is not a supported feature, but a
"trick")
Cheers
HI all,
Is it possible to perform replication as follow? HOW?
master (innodb) ---replication---> slave (myisam)
Rgds,
Ringo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Try to quote the password:
password= 'test#istest$'
or
password= "test#istest$"
Not sure if MySQL is doing command expansion. If yous, use the first
example, if not, it should not matter.
Cheers
/rudy
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: maandag
Ganbold
Because the bug that did not recognise the comment character in the password
line has been fixed?
Andy
> -Original Message-
> From: Ganbold [mailto:[EMAIL PROTECTED]
> Sent: 04 August 2003 09:51
> To: Primaria Falticeni
> Cc: [EMAIL PROTECTED]
> Subject: Re: Problem reading my.cn
Hi,
It was Ok in previous version of mysql. Why they changed ?
Thanks anyway.
Ganbold
At 11:21 AM 8/4/2003 +0300, you wrote:
Try to not use "#" if you want the password to be in my.cnf file.
The "#" is for comments if my.cnf file.
- Original Message -
From: "Ganbold" <[EMAIL PROTECTED]>
Ralph,
Yes, indeed. It's a good idea to read this book.
Iulian
- Original Message -
From: "Ralph Guzman" <[EMAIL PROTECTED]>
To: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, August 04, 2003 11:13 AM
Subject: How to Ask Questions the Smart Way...
> Maybe the weed has got me hig
Try to not use "#" if you want the password to be in my.cnf file.
The "#" is for comments if my.cnf file.
- Original Message -
From: "Ganbold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 04, 2003 11:08 AM
Subject: Problem reading my.cnf
> Hi,
>
> I have just upgraded
Maybe the weed has got me high right now, but here is something some of
you on this list may find funny, others may find this useful. This is
not spam, this is actually a good manual you should all read:
http://catb.org/~esr/faqs/smart-questions.html
Good Reading.
--
MySQL General Mailing Li
Hi,
I have just upgraded mysql server version from 4.0.13 to 4.0.14, from
FreeBSD 5.1 ports collection.
Before upgrade mysql command line client could read password from
/etc/my.cnf file and I could use mysql without supplying -p option.
But after upgrade it could read password only up to # sig
Hallo
suppose you have a table with great number of columns (20 or 30),
and you would like to specify every one but two or tree columns in a SELECT statement.
Is there a way to specify only those two or tree columns for omission (which would be
the 'short' way to do the job) instead of specifyin
Hello,
I read in the docs about the extensions but I didn't met any example.
Please, if you could, give me a link or a site with extensions in C/C++ for
MySQL.
Best Regards,
Iulian Teodosiu
Economist/software developer
Falticeni Municipality
--
MySQL General Mailing List
For list archives: ht
75 matches
Mail list logo
