Hi Luke..
Try this
SELECT ObjectId FROM
(SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId,
f15.Form15PatientID AS PtId FROM form15 f15
WHERE f15.Form15SampleTube1RnaBarcode IN ('01D2V','01DH6')
UNION
SELECT f15.Form15SampleTube6RnaBarcode AS ObjectId,
f15.Form15PatientID AS PtId
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id = page.id
AND page.category_id =
1 - while your current select query is reasonably fast, it likely could
be faster. It may be that it's taking 0.9 seconds and feels fast, but
perhaps it could be 0.09 seconds instead - and that's not something a
human can really tell the difference on. It's using an indexed column
(status),
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE
It was just to copy the files from the DATA folder in the installation
directory. That was easier then I thought.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 6:52 AM
To: mysql@lists.mysql.com
Subject: Urgent problem
Best group member,
My
Hi!
We have that huge query against a mysql 4.1 (myisam) to retrieve rows.
The query is built dynamically using a loop, as we are searching in an
external database built to store a tree with the nested tree model.
When we do this search with a normal world, it's fine: the query is around
4
Hi!
Peter == Peter Lauri [EMAIL PROTECTED] writes:
Peter Best group member,
Peter My computer stopped working. And I was able to install Windows on another
Peter partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter I have all C: working, and can access all files.
There is no reason why you cannot use diffeent package
managers for your system. The only thing is do not run two
managers at the same time, as they require exclusive access
to the rpm database.
Trying to use more than one package manager, or multiple
instances of the same one is not a good
Seems like someone has got their hand of my e-mail alias which I use for this
list only. It started last friday and I get about 10-15 messages every day.
Does someone else has this problem?
What's the procedure to change my subscribtion e-mail addresse?
--
Jørn Dahl-Stamnes
homepage:
Hi Jørn,
I myself haven't had too many spams, I get a few anyway from various places my
email address is placed. I would suggest try unsubscribing using this alias and
just re-subscribe with your new (known only to you) alias.
Regards
On Wednesday 24 May 2006 13:36, Logan, David (SST - Adelaide) wrote:
Hi Jørn,
I myself haven't had too many spams, I get a few anyway from various places
my email address is placed. I would suggest try unsubscribing using this
alias and just re-subscribe with your new (known only to you)
Hello everyone,
Today a script killed a few InnoDB tables in my database. Although I have
backups (2 days old) I want to recover - if possible - a more current state of
my database. Is it possible to recover tables via the ib_logfileX files?
If i simply open the files with VIm I can see that
Thanks everybody for attention!
I make some changes in hardare and in my table, and obtain a average response
times of 0.09 second.
Now i have a good time ! :-)
Show you my changes:
1-Update MySql 4.1.18 - 5.0.21.
2-Upgrade my memory to 3 Gb.
3-Severance of temporary/logs files and data
more than likely someone is harvesting emails off groups.google.com
http://groups.google.com/group/mailing.database.myodbc
Your posting shows top of the list :)
George Law
-Original Message-
From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 7:38 AM
战芳 wrote:
Hi! gerald_clark,
But when I call mysql_pconnect(localhost:3306,root,root_password),it
return the same error. How can I get the permission to open
/var/mysql/lib/mysql.sock?
Fang
what do you get when you do
ls -l /var/mysql/lib/mysql.sock?
On Wednesday 24 May 2006 14:48, George Law wrote:
more than likely someone is harvesting emails off groups.google.com
http://groups.google.com/group/mailing.database.myodbc
Your posting shows top of the list :)
Yet another reason for not using google. It seems like they help the spammers
by
Check this out, it works a treat for me:
http://www.tmda.net
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Wed, 24 May 2006, Jørn Dahl-Stamnes wrote:
To: mysql@lists.mysql.com
From: Jørn Dahl-Stamnes [EMAIL PROTECTED]
Subject: Re: SPAMs
On
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I played around with
many thanks Chris :)
g
On May 24, 2006, at 1:19 AM, Chris Sansom wrote:
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below
to use INNER JOIN ?
If so, what would the correct syntax be ?
Many thanks
SELECT category.name,
On 5/24/06, Christopher Korn [EMAIL PROTECTED] wrote:
Hello everyone,
Today a script killed a few InnoDB tables in my database. Although I have backups (2 days
old) I want to recover - if possible - a more current state of my database. Is it
possible to recover tables via the ib_logfileX
I'm hoping for some general advice on an approach for the following
scenario:
I have a customer who wants to put an incentive program in place for
students taking learning modules and then completing tests. The concept is
simple. Award the first 10 people who complete a test with a score of
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id = page.id
AND page.category_id = category.id
AND
At 23:17 -0700 23/5/06, Graham Anderson wrote:
Are there any advantages to converting this 'working' query below to
use INNER JOIN ?
If so, what would the correct syntax be ?
SELECT category.name, page.name, content.title, content.body
FROM category, page, content
WHERE content.page_id =
Brian,
Just my 2 cents :)
I always try to use an epoch time stamp for anything time related. its
easier to compare times and all the functions are built into mysql to
convert to/from a unix epoch timestamp
select unix_timestamp(NOW());
+---+
| unix_timestamp(NOW()) |
Hi -
It's been a short while since I've seen any discussion on this subject,
and I'm wondering what's happened in this arena since then.
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a fancy new server,
compared to
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able to fine-tune the
Bgs wrote:
No ideas?
I tried playing around with read/write timeouts (even thought the
replication is fast), all size limits are greater than the whole
replicated db. The last table with accesses MYD and zero size is a small
one (a couple of dozens kBs).
Bgs wrote:
Greetings,
I
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server. I think that by doing something like
this, I would be able
I want to do something like this:
if not exists `hotel_page_templates`.`hpt_custom_fields`
alter table `hotel_page_templates` add column `hpt_custom_fields` text after
`hpt_alternate_username`;
ÐÆ5ÏÐ
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was thinking about this
Hi, I'm having problems with a trigger that I'm working on, I want to create
a trigger that after inserting a row in table A will copy the row to table B
and once there will delete the row from table A.
I'm using two triggers for this one goes on table A and does the copy of the
information to
nigel wood wrote:
Dan Trainor wrote:
Dan Trainor wrote:
Hi -
I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.
The reason for doing this is to test load under [semi]real-world
conditions with the new server.
Hi -
So I was
Surely the column name has to exist in both tables?
Indeed.
Graham is using page.category_id and category.id, content.page_id and
page.id
His column specs weren't complete. If you're right on this, though...
, so I think ON (as I posted earlier) is the only way to do this.
...you're right on
I think doing a sort by date with limit 10 should get you the first
ten. I believe the now() function uses the server time, so no need to
do date/time calcs really.
Good luck,
Jason
Brian Menke wrote:
I'm hoping for some general advice on an approach for the following
scenario:
I have
Brian
Re your schema,
--it's redundant to define PRIMARY and UNIQUE keys on the same column,
--why not an INT student id?
--what if two (eg married) students share an email account?
--comparing datetimes across multiple time zones will be simpler if
you
set
Hi folks,
Brand new Fedora Core 5 box running MySQL 5. I can get into the monitor
and connect, work with databases, etc. I can't get the MySQL
Administrator to run - get lots of errors:
1. I downloaded mysql-administrator-1.1.10-1.i386.rpm.
2. As root, in /usr/bin, did
rpm -Uivh
Peter, thanks for the detailed info. I will figure out how to get rid of the
UNIQUE key. Somehow that got added. Thanks for the catch. As far as INT for
student id goes, I'm using email because it will be unique, and offers an
easy way to track a user through the app I'm building (user name,
Hi list,
we're running some large high-traffic mysql servers, and are currently
reaching the limit of our machines.
We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is
quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is
CPU.
The queries run very fast
Semi related to this, as it appears in my searching that this is
unfortunately not a supported feature. Is there a flag or something that I
can put in my .sql file that will turn OFF any error checking, execute my
statements (so that even if one fails, the next one will be tried), then
turn it
Brian,
Somehow the server ate my response...
Re your schema,
--it's redundant to define PRIMARY and UNIQUE keys on the same column,
--why not an INT student id?
--what if two (eg married) students share an email account?
--comparing datetimes across multiple time zones will be simpler if
Brian,
CURRENT_TIMESTAMP gives you time in your server's timezone.
UTC_TIMESTAMP gives GM (universal) time, so dispenses with all timezone
adjustments. Trouble is, you cannot use it as a defalt. You have to
pass it as an INSERT value.
PB
-
Brian Menke wrote:
Moritz Möller wrote:
Hi list,
we're running some large high-traffic mysql servers, and are currently
reaching the limit of our machines.
We're using mysql 4.1 / innodb on debian, ibdata is about 35GB. Hardware is
quad xeon dualcore, 8 GB RAM. Disk-io is nearly zero, limiting factor is
CPU.
The
A big Thank you goes to you! That was it!
Looks like I tried with too many parentheses i.e.
/this is wrong/
SELECT FROM ...
(
(SELECT FROM ...)
UNION
(SELECT FROM ...)
) AS abc
Regards,
Luke
- Original Message -
From: Neeraj [EMAIL PROTECTED]
To: 'Luke' [EMAIL
Whil Hentzen wrote:
Hi folks,
Brand new Fedora Core 5 box running MySQL 5. I can get into the monitor
and connect, work with databases, etc. I can't get the MySQL
Administrator to run - get lots of errors:
1. I downloaded mysql-administrator-1.1.10-1.i386.rpm.
2. As root, in /usr/bin, did
Hi Dan,
there are about 2GB free, so the net size would still be 32 GB.
The queries are really optimized, 99.9% of all queries can be satisfied
without table scans.
Well, I guess I have to give NDB a chance, I hope it will help. The only
alternative I come to is to cluster the database on
Moritz Möller wrote:
Hi Dan,
there are about 2GB free, so the net size would still be 32 GB.
The queries are really optimized, 99.9% of all queries can be satisfied
without table scans.
Well, I guess I have to give NDB a chance, I hope it will help. The only
alternative I come to is to
Rich
for what? is
SELECT host,user,password FROM mysql.user;
showing you cleartext passwords? It shouldn't.
-Sheeri
On 5/23/06, Rich [EMAIL PROTECTED] wrote:
Hi folks. Me again.
I finally got this all up and running under crypt of 'cleartext'.
So, even though I am going to be on
I don't think MySQL can do thatmaybe with some kind of stored procedure
If you're using 5.0 or higher, use the INFORMATION SCHEMA to find out
if the column exists. If not, use the show create table statement
and parse it.
Why is this a problem, though? (just curious, I'm not sure this
If you run a script with
mysql script.sql
then if there's an error, the script dies.
If you run a script with
mysql -e source script.sql
Then the script will just spit out an error and move on to the next command.
Hopefully that will help.
-Sheeri
On 5/24/06, Daevid Vincent [EMAIL
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor [EMAIL PROTECTED] wrote:
Bgs wrote:
No ideas?
I tried playing around with read/write
++
Phil Robbins
Auckland
New Zealand
++
_
Discover fun and games at @ http://xtramsn.co.nz/kids
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Phil Robbins wrote:
NOTHING
Perhaps you should read the notice at the bottom of each post that you
receive from the list !!!
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922
There may be a clue at the bottom of every message ;-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Wow, if I read that right, it means someone on the East coast submits
answers to a test, it's somehow adjusted to be the same as someone who
submits answers to a test from the west coast 3 hours later (time zone
wise)? I can't possibly imagine how that works, but if it does that solves
huge
As mentioned in the original email, I know about forcing it, but I can't do
that in my case.
DÆVID
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 6:27 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: How do I turn off
55 matches
Mail list logo
