ley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 July 2006 11:25 PM
To: [EMAIL PROTECTED]
Cc: Mark Dale; mysql@lists.mysql.com
Subject: Re: Returning results as a field name
Pardon me, too early & not enough coffee, that's not quite the
'max-concat trick', but it oughtta
lues to get the other questions and their answers into the table
greatly appreciated.
cheers
Mark Dale
***
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 26 July 2006 2:54 PM
To: Mark Dale
Subjec
???
++---+---+
|NAME|100|101|
++---+---+
|Mark|Yes|No |
|Leigh |No |Yes|
++---+---+
cheers
Mark Dale
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list
An update - it also occurs in 4.1.19
Bug filed here:
http://bugs.mysql.com/bug.php?id=19978
Cheers,
Richard.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
file a bug report.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]
what happens if the row is neither inserted nor updated? Right now it
appears to returns '2'. I think it should return '0'.
Cheers,
Richard.
-----Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 May 2006 11:23 a.m.
To: mysql@lists.mysql.com
Mysql 4.1.16 running on Fedora Core 4 (Linu) X86_64 with InnoDB tables
I have a table called which has a (combined) primary key of assetid and
date plus several data fields (open, high, low, close - all doubles, and
voume - a bigint). See the bottom of the email for the table definition.
INSERT
MySql v3.23 is part of the Fedore Core 3 distribution. MySQL v4.1 only
became standard in Fedora Core 4.
I suspect it's one of the non-Fedora repositories you're using. Check your
logs and also check /etc/yum.repos.d
grep enabled /etc/yum/repos.d/*
Best regards,
Richard Dal
OK.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
ting area. You will need to install a package
called mysqlclient10-3.23.58-6.x86_64.rpm - I found such a package at my
local mirror here:
http://mirror.pacific.net.au/linux/redhat/fedora/test/3.92/x86_64/os/Fedora/
RPMS/mysqlclient10-3.23.58-6.x86_64.rpm
Best regards,
Richard Dale.
Norgate Investor
tle=Opteron_HOWTO
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysq
Opteron (x86_64) HOWTO:
http://hashmysql.org/index.php?title=Opteron_HOWTO
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Ma
sing mytop to see if there are queries going on.
It's like the unix "top" command.
http://jeremy.zawodny.com/mysql/mytop/
Also try:
SHOW PROCESSLIST;
If you use InnoDB:
show innodb status;
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futur
://bugs.mysql.com/bug.php?id=10829
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: ht
d it took around 2 hours to load on an Opteron 250, 4GB
RAM, 8x15K RPM RAID 10 drive system.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
My
, and writeback
caching increased the speed by about 15% although I don't think I was really
able to max out the IO anyway.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe
e seems to be quite often NULL, so I
guess it's not implemented in InnoDB.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
-Origina
y and I'll do some performance testing
on RAID5 (8 disks) versus RAID 10 (8 disks, 2 channels). I'll also do some
performance tests with 128MB cache and 512MB cache on the SCSI card to let
you know if that makes a difference.
Best regards,
Richard Dale.
Norgate Investor Services
- Premiu
/meta.wikimedia.org/wiki/Hardware_order_May_2004
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives:
:
> X-Virus-Checked: Checked
> X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on c.spam
> X-Spam-Status: No, score=1.1 required=5.0 tests=DNS_FROM_AHBL_RHSBL,
> HTML_MESSAGE,HTML_TAG_EXIST_TBODY,NORMAL_HTTP_TO_IP,NO_REAL_NAME,
> WEIRD_PORT autolearn=disabled version
d Queueing) then I think we'll find SATA will take
a much bigger lead in database performance.
Really nice work from tweakers.net - would have been interesting to see the
Linux performance too though.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and F
Shawn-
Works like a champ! Thanks so much. If your ever in the Silicon
Valley area drop me a line, and I will be happy to pick up lunch or
cocktails.
It's great that you are so active on this list and are helping so many
folks on here (myself included).
-Dale
On Fri, 25 Feb 2005 10:
I am new to MySql. I have a query with a subselect that is running
very slow (28 seconds).
SELECT *,MATCH(title, descr_part) AGAINST ("Project Manager" IN
BOOLEAN MODE) AS score
FROM listings
WHERE MATCH(title, descr_part) AGAINST ("Project Manager" IN BOOLEAN MODE )
and zip in
(SELECT z
On Thu, 2004-12-30 at 16:19 -0700, Sasha Pachev wrote:
> Dale Blount wrote:
> > Hello,
> >
> > I've been fighting this problem for a while, and now it's time to ask
> > the experts. Please also CC me on this, I'm only on the list as a
> > digest
ver
(same software).
I've tried using the static mysqld binary from mysql.com with the same
results as the distro's binary. I've also tried different glibc
versions (although this shouldn't affect the static mysqld anyways) also
with no luck.
I'd be very interested in hearing
`id_token_data_02` (`innocent_hits`)
) TYPE=InnoDB |
Below is the my.cnf file, with comments removed.
Thanks,
Dale
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL
tabase on its own hard drive.
Swapping: WinXP reporting commit charge < 800MB
Note: I'll be moving to a Linux-based development server soon and will be
able to tell whether the above is specific to Windows or Linux.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality
service never starts. Red light always shows. I cannot see the default
databases : mysql and test.
How can I fix this. Should I try an upgrade from 4.0 to 4.1 and what are
the steps to do this?
I downloaded the mysql-4.1.1a-alpha-win zip file from mysql.com.
Thank you.
Dale Goolcharan
accept string
data up to 5000 characters.
I am new to mysql. Any help will be appreciated.
Thank you.
Dale Goolcharan.
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus&pgmarke
system.
What is the url I can use to allow me to dynamically retrieve a list of
mysql databases running
on a particular IP address and upon selecting one, the user can log into the
database.
If you require samples of code, or additional info. please let me know.
Thank you.
Dale Goolcharan
t like
this:
SELECT * FROM Inventory
WHERE stuff CONTAINS 'Books'
ORDER BY name
I appreciate any help.
Dale Hans
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not support TOP?
If it does, can somebody tell me what is wrong with that syntax?
If it doesn't, can someone please tell how I can do it without getting
ALL records and extracting the first 10 programmatically?
Thanks,
Dale Hans
--
MySQL General Mailing List
For list archives:
access, so I'd rather not try anything that would cause too
much downtime.
Any pointers and/or suggestions are appriciated.
TIA,
Dale
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sig
>
>FEE_PAYMENTS
>ID | MEMBER_ID | PRICE
>1 | 2 | 500
>2 | 4 | 750
>
>So as you can see, only "Torkil Johnsen" and "Madonna" has paid their fees, 500 and
>750 respectively.
>
>Now I want to list the people that have not paid their fees... How would y
Hi all
Thanks for your replies to my question about multiple updates in one query. I think
Kittiphum Worachat is right in that I have designed it wrong. I couldn't get it to do
what I wanted, so I reverted to single update queries.
cheers
Mark
---
Summary of replies
-- from Paul Wilso
select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.PAID = '0' and MEMBERS. MemberID
= FEE_PAYMENTS. MemberID;
assuming you have a field PAID, with values 0 or 1,or even YES or NO
cheers
Mark
>I am having a small problem with a small mysql query...
>
>I want to make a list of:
>"WHO HAS NO
Hi
insert into mytbl (a1) values (12),(13),(14);
cheers
Mark
---
On Mon, 15 Apr 2002, Bill Adair wrote:
> Hello all,
> I'm in a mysql client session and I want to do multiple inserts
> into a table (or run a multi-query script etc). Thi
en so that it updates each of the three records?
cheers
Mark
On Mon, 15 Apr 2002, Joseph Jude wrote:
> Are you sure job_number in your script equals to all the three records and not just
>one record?
>
>
> -----
> Joseph Jude
> - Origi
mber'";
$result = @mysql_query($sql, $connection) or die.;
and it only changes the last record. Could someone kindly tell me what I'm
doing wrong.
cheers
Mark
--
Mark Dale
phone/fax: 02 6247.6731
mobile: 0403.83
Many thanks for that.
cheers
Mark
On Mon, 15 Apr 2002, Kittiphum Worachat wrote:
> Hi.
>
> insert into mytable (id,name,job_number,job_date) values
> ('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark',
> 'AA3','2002-04-17'),
>
> Kittiphum Worachat,M.T.
> www.ha
alues
('2','Mark','AA2','2002-04-16')
insert into mytable (id,name,job_number,job_date) values
('3','Mark','AA3','2002-04-17')
- all at once if the data is the result of a form page.
cheers
Mark
These guys have written a PHP/MySQL counter script thats available for
download.
http://www.kastle.net/products/php/dbcounter/
I've used their old one thats writes to a text file rather than a MySQL db
and its very good also.
cheers
Mark Dale
On Sun, 14 Apr 2002, Colin Faber
Hi there,
I was following the instructions to compile the latest version of mysql
for Mac OS X, when I ran into a few errors.
I downloaded the source file as per the instructions from Apple
(http://developer.apple.com/internet/macosx/osdb.html), and then
followed the instructions on mysql
(h
On 1-Dec-2001 16:49 Sinisa Milivojevic wrote:
|
| Thank you for the repeatable test case.
I've just tested this with 3.23.46 and it still fails.
regards.
--
-Dale
-
Before posting, please check:
http://www.mysq
>Description:
It seems that that the use of LEFT JOIN when the joined table
uses multiple primary key conditions fails to include rows which
are clearly matching on those conditions.
>How-To-Repeat:
mysql> create table foo (fooID smallint unsigned auto_increment, p
some user has had this
problem before. Thank you.
Dale McDaniel
GeneralIT.com
__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo
their startup files there.
Dale
-
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]&
e database starts, but the terminal window
I used to startd it never finishes up. I have to open a new terminal window
up.
Has anyone experienced this?
Dale
-
Before posting, please check:
http://www.mysql.com/manual.php (
jdbc to make remote connections to the database, but
assume that I'll run into similar problems.
All/any help would be very much appreciated.
Sincerely,
John C. Dale
Lead Java Architect, Project Manager, Lead Software Engineer
Down in the Desert productions
[EMAIL PROTECTED]
www.downinthedesert.com
Using a Win2K server, with 3.23.34 of mySQL - get these messages
occassionally and have set the service to restart on a sudden stop.
Database error in vBulletin: Link-ID == false, connect failed
mysql error:
mysql error number:
Date: Friday 23rd of March 2001 02:06:06 PM
Script:
Is there anyway to do a query and search for the most frequent
word that appears in a particular field in a table?
ie:
ITEM DESCRIPTION
Blue Dog
Red Dog
Yellow Cat
I would want to spit out "Dog" as being the most reoccuring word.
Thanks
---
pecify a bigger buffer by
starting the client with mysql --set-variable=max_allowed_packet=8M.
>There is a limit to the size of a packet sent to mysqld, which is
>configurable. Check the manual for it, and see if you are hitting that.
>
>Regards
>
>Quentin
>
>>
-f in the query, but it didnt help
TIA
Mark Dale
-
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 <[EM
Hi Scott
-H outputs the file nicely as a HTML bordered table, but I was more looking for
a way to output the file as a "bordered" ASCII table (like a screen
print below)
any clues?
cheers
Mark Dale
-Previous Message-
>Have you tried the -H switch to output as HTML?
54 matches
Mail list logo