rting?
Cheers,
James
James Green wrote:
> Hi,
>
> I've upgraded from 5.0.26 to 5.0.37, both compiled from same source
> options, and the newer release crashes on startup.
>
> 5.0.26 Appears fine on all counts.
> 5.0.37 Appears to start without innodb switched on, but mys
ith-mysqld-ldflags=-all-static
Any ideas?
Cheers,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ort
1 SIMPLE users ref user_type_idx,entity_idx,geo_idx geo_idx 7
geo_entities.id,const 4202 Using where; Using index
-James
On Jan 25, 2007, at 8:35 AM, Filip Krejc(í <[EMAIL PROTECTED]> Krejc> wrote:
Hi,
try
CREATE INDEX geo_idx ON users(entity_id, user_type);
Filip
Al
FROM users, geo_entities
WHERE users.user_type = 'user'
AND users.entity_id = geo_entities.id
GROUP BY entity_id
LIMIT 0 , 30
It took 51 seconds to execute.
Both tables only have an index on their unique record id.
Is there a way to speed up this up?
-James
--
MySQL General Mailing List
For list a
With so few rows, are you hitting the 50% rule? Try again with a decent
number of rows.
> -Original Message-
> From: devy [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 04, 2007 5:46 AM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Fulltext problem
>
> Hi,
> today I've
emory allocated 22615268; in additional pool allocated 1045760
Dictionary memory allocated 273640
Buffer pool size 512
Free buffers 1
Database pages 510
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 45294, created 16839, written 66895
h to diagnose this problem and also fix it?
Thanks in advance,
--
James Neff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Peter Brawley wrote:
>I want to find all A's such that
>they have exactly B's 1 and 2
>SELECT A.ID, group_concat(BID ORDER BY BID) as Bs
>FROM A INNER JOIN AhasB ON A.ID=AID
>GROUP BY A.ID
>HAVING Bs='1,2'
Why the join? Doesn't your ahasb bridge table already incorporate the
join logic? If your
trying to do? I'm finding it hard to
even Google for information, since a can't seem to describe what I want
concisely enough for a search.
Thanks in advance,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rt? Does that handle a live database w/o any issues?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
08 not found
first. Do I just install the Net package?
...OK
I actually downloaded and installed Net:MySQL...
sudo Perl Makefile.PL
sudo make
sudo make test
sudo make install
...all went ok
then I did the same steps for DBD
...all went ok and no warnings...
But I'm still getting the same
I have a database with roughly the following structure:
album
--
albumid INT
title VARCHAR(255)
artist
--
artistidINT
nameVARCHAR(255)
albumartist
--
albumid INT
artistidINT
From the above, y
e', (SELECT IF(LENGTH('{date_of_birth}') = 0, NULL,
'{date_of_birth}')))
Thanks again,
Jim
James Neff wrote:
I have a table like so:
enrollments
-
ID - INT
Name - VARCHAR(45)
DateOfBirth - DateTime
The DateOfBirth
ng:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ') = 0,
NULL, '')),
Is there a better way to handle optional dates that I am missing?
Constructive criticism welcome.
Thanks,
--
James N
ly go about doing this without breaking down the
datetime?
-James
nothing ive tried works.
Any ideas?
Thanks,
James
e to the database.
Good luck!
--James
-Original Message-
From: Yoloits [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 1:25 PM
To: mysql@lists.mysql.com
Subject: CPUs not being utilized
I am running MailWatch with mysql 4.1.20 with Red Hat
Enterprise 4 on a dual XEON 3.2
.
--James
Brent Baisley wrote:
You would need to convert the table to InnoDB as George mentioned.
Alternatively, break up your SELECT into many smaller selects. If your
query is running slow now, it's only going to get slower and slower as
your table grows. I've noticed with MySQL that la
e-
> From: Robert DiFalco [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 10, 2006 11:50 AM
> To: Jerry Schwartz; Baron Schwartz
> Cc: Rick James; mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: RE: Innodb Locks
>
> Right, as I understand it the query optimizer in
- Original Message -
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To:
Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2006 3:13 PM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
There are some minor performance benefits here when run against
benchmarks... but tin
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Ow Mun Heng" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 09, 2006 9:12 AM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
In the last episode (Oct 09), Ow Mun Heng said:
Just wanted to know if it would be faster
S cardtypes(`id`);
ALTER TABLE `facedefs` ADD constraint `fk_facedefs_cardtype` FOREIGN
KEY(`cardtype_id`) REFERENCES cardtypes(`id`);
- --
"Don't worry about people stealing an idea. If it's original, you will
have to ram it down their throats." Howard Aiken
James Black[EMAIL
If I have the following strings in a varchar column:
Piano Sonata 1 - Brendel
Piano Sonata 10 - Brendel
Piano Sonata 11 - Brendel
Piano Sonata 12 - Brendel
Piano Sonata 13 - Brendel
Piano Sonata 14 - Brendel
Piano Sonata 15 - Brendel
Piano Sonata 16 - Brendel
Piano Sonata 17 - Brendel
Piano Sonat
Can't answer your question directly. But I wonder if this would trick it
into avoiding the lock:
UPDATE AnotherTable
SET...
WHERE id IN (SELECT id FROM SomeTable);
And the real workaround would be
CREATE TEMPORARY TABLE t
SELECT id ...;
UPDATE AnotherTable
SET...
WHERE id IN (SEL
I have a legacy app that only supports MySQL 3.23. I'd like to run it
along with 5.0.24a on a Windows 2000 server, with each instance using the
standard port 3306. So I need to have each instance bound to just one IP
address.
In MySQL 3.23 can you specify a bind-address in the my.ini file, o
Maybe it is the tiny extra time to parse the unnecessary " LIMIT 1"?
> -Original Message-
> From: Robert DiFalco [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 29, 2006 10:09 AM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: RE: Performance: LIMIT 1 with UPDATE
>
> FWIW, m
bind-address of 127.0.0.1, which I'd removed, but since the MySQL server
wasn't actually being restarted, the new configuration was never picked
up.
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "James Eaton" <[EMAIL PROTECTED]>
ected to localhost.
Escape character is '^]'.
A
5.0.21-standard-log&6{-kS?!,$2lMx:Ty%I!d
(I then pressed return and the connection closed)
I can telnet to MySQL from the localhost, but not from any other location.
On 8/23/06, James Eaton <[EMAIL PROTECTED]> wrote:
Is
Is there a way to query a MySQL (5.0.xx) server to find out which IP
address(es) it's listening on? It should be listening on all, but I'm
unable to connect from remote machines, so need to troubleshoot a bit.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
need to do that.
I suppose it just proves that, when it comes to coding practices, Your Mileage
*Will* Vary.
:-)
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from that I agree
with Douglas Sims that what is most readable is best.
select user_email, user_address, user_postcode from users where user_id = %d;
# Hmm
select email, address, postcode from users where user_id = %d;
# Less typing and more readable.
James Harvard
--
MySQL General Mailing Lis
PRIMARY KEY (`userid`,`messageid`)
)
What that does is give each user their own incrementing message
id. Then you can do things like allow users to enter a message id
directly with a number that would be easy for them to remember.
Just an idea.
- Original Message - From: "
Thanks everyone.
Now I feel confident that one table will be fine (Tripp's stat of 30
million records put me at ease :) ).
Cheers,
-James
On Aug 7, 2006, at 4:08 PM, John Meyer wrote:
One table,
USERS
Another table
MESSAGES
With a foreign key referencing users.
Maybe a second foreig
lions of
records.
Thanks.
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to do in one SELECT statement, or should I just iterate
through a resultset in my application?
Thanks in advance,
--
James Neff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for your reply. I repeated your test with the same results on 4.1.21
(database in question is on 4.1). I'll give the ISP another kick and see what
they have to say.
So there's no other reason why an ISP might not want to grant LOCK TABLES in a
shared hosting environment?
Tha
in the bugs db, nor is it listed in
the manual as a side effect of granting 'lock tables' permissions.
Does anyone know if it is a bug or not? Does anyone know whether LOCK TABLES
really is a security risk in a shared server / multi-user environment?
TIA,
James Harvard
--
MySQL
key from table 2 should it
delete the row in table 2?
Thanks,
James
sorry if it's a stupid question, but just to cover the basics, you
remembered to flush privileges after adding it right?
-- James
On Jul 11, 2006, at 9:31 AM, John Doolan wrote:
Hi,
I have just installed mySQL version 5 and want to enable root access
from remote machines. However
The package you sent me was infected, so send me one by mail.Thank you:James
B.Runaku, P.O.Box 190-50100, Kakamega, Kenya.
mysql@lists.mysql.com wrote: The message contains Unicode characters and has
been sent as a binary attachment.
-
How low
OK, fair enough. In that case I would think that filing a report on
bugs.mysql.com would be your best way forward.
At 8:32 am + 7/7/06, SciBit MySQL Team wrote:
>While you are not wrong, James, is the length member suppose to denote the
>maximum length of data contained in re
Although I know nothing about C I imagine this is because the 'type' column can
contain all the possible values from an ENUM or SET field.
James Harvard
At 10:30 am + 6/7/06, SciBit MySQL Team wrote:
>Since a couple of recent stable versions back (and more recently, MySQL
&g
7;t intend to write such an essay on this! Hope it is of some use.
James Harvard
>Ok, so you don't want info on databases, but on which language to use
> to build a web site? You must sit down and determine what the site will be
> used for and what features you *must hav
Thanks for the info,
Not sure how this came about as it has been working fine and it is on a
windows system and using the root user.
Any ideas would be much appreciated,
Thanks,
James
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "Ja
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI"
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
James
Never mind.
I'll just go RTFM and quit bugging you guys on list with stuff
answered plain as day in
http://dev.mysql.com/doc/refman/5.1/en/adding-users.html
Sorry. I'll go caffeinate myself before asking more stupid questions.
-- James
On Jun 14, 2006, at 11:55 AM, James Barros w
Hey guys, I'm running mysql 5.1.9 and I've got a user who's
mysql.user host is set to "%" and can log in from any domain except
localhost. if I change to localhost, and flush privileges they can
log in.
Is this intended behavior, or should % be inclusive of localhost?
--
MySQL General Ma
Can this use log in from localhost successfully?
Try flushing privileges again?
If that failed, I'd drop the user and recreate?
( Theres really not alot to this, sorry I don't have any more ideas :( )
-- James
On Jun 7, 2006, at 1:07 PM, Aron Levy wrote:
Hi James i follow your rec
Well, for starters don't worry about ports being open. If you werent
able to connect, it would give you a different error message.
select password('yourpassword'); and verify that the hash produced
matches the password field in user exactly.
-- James
On Jun 7, 2006, at
this
issue?
Other suggestions?
Is this a legit bug I should report to the buglist or did I screw
something up?
Thanks :)
-- James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication (multi-master replication) with
>failover.
>
>Read the article >>
>
> http://dev.mysql.com/tech-resources/articles/advanced-mysql-replication.html
HTH,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 11:55 am +1200 26/5/06, Phil Robbins wrote:
>I've read the notice AND tried to unsubscribe TWICE. I still get the mail.
http://lists.mysql.com/troubleshoot.php
HTH,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
If you replicate a long command; more specifically, a command (or
transaction) that started a long time ago, it will appear that replication
is far behind. This is because the apparent delay is computed [I think]
from the diff of the current time on slave and the time that the currently
replicated
lect f1 from t1 where match(f1) against ('"c++"' in boolean mode);
HTH,
James
At 12:30 pm -0700 10/5/06, klute wrote:
>Is there any way I can search for a term such as 'c++'
>using a fulltext search index?
>select f1 from t1 where match(f1) against('
Related inequalities:
Given a blob of N bytes:
max_allowed_packet > N
innodb_log_file_size > 10 * N (if InnoDB)
And maybe issues with
bulk_insert_buffer_size
innodb_log_buffer_size
> -Original Message-
> From: Jeremy Cole [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 08, 2006 2:5
to the
table file format.
http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html
I would *guess* that you were using a pre-release version, because I would be
surprised if a public release version in the 4.1 branch would be incompatible
with its predecessor's file format.
HTH & g
82350 | NULL | NULL | YES | BTREE
| |
+++--+--+-
+---+-+--++--+
+-+
3 rows in set (0.00 sec)
T1 has 20,029 rows
T2 has 82350 rows
Many thanks to anyone who can offer any insight to this quandary.
Cheers
James Riordon
Hosting | Webdesign | PHP | DTP
http://www.outofcontrol.ca
I think you will need to give the list some more information!
What error message do you get? Is it an error when running SQL queries, or a
problem connecting to the database?
James Harvard
At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote:
>I migrated to mysql 5 but the applications with Vis
indexes on any tables with a full-text index. Also, note the
warning about using myisamchk further down the manual page.
HTH
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Never used it, but this might help:
http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html
James Harvard
At 5:00 pm -0700 19/4/06, Robinson, Eric wrote:
>I have master-slave replication working fine. However, I worry about the
>possibility of the master and slave accidentally getting
articularly the queries even when I used stored procedures and functions.
So I would like to know some of your suggestions on my setup.
Thanks,
Michael Louie Loria
LoRz Technology Solutions
htttp://www.lorztech.com
James Nobis
Web Developer / System Engineer
Academic Superstore
2101 E. Sa
- Original Message -
From: "Nicolas Verhaeghe" <[EMAIL PROTECTED]>
To: "'MySQL General'"
Sent: Saturday, April 15, 2006 11:20 PM
Subject: Should we petition GoDaddy?
I am slowly considering leaving GoDaddy, who has a very good bandwidth
and
ok tech support (I have seen better but muc
ase that was introduced in v5.
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
HTH,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Not a db setting - the DROP statement itself.
http://dev.mysql.com/doc/refman/5.0/en/drop-table.html
HTH,
James Harvard
At 1:56 pm -0700 21/3/06, ChadDavis wrote:
>I'm runnning a script that creates a few tables. I have line that drops the
>tables before the creation of the tables j
le with no matching rows.
James Harvard
At 11:27 am + 16/3/06, [EMAIL PROTECTED] wrote:
>As someone totally unread in the theory of databases, that seems unduly
>puritanical. I assume that what Date would propose is that you have another
>table (related by master key) in which,
But (in at least some situations) is not appropriate to record that you know
that you don't have a value?
I think the words of Donald Rumsfeld are appropriate here:
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we
e to use
>in many, many situations.
It's not often you can say that two people are quite literally arguing about
nothing!
James Harvard
(... being flippant because the actual arguments started going over my head
about half-a-dozen posts ago...)
--
MySQL General Mailing List
For list archiv
are *not* the same thing, the outcome (the absence of a value) *is*
the same.
So you're both right. Sort of.
:-)
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-JS browsers - i.e. they get the whole form on one page)
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this MySQL server
you can be assured that you made a connection to the MySQL server. The
problem is the MySQL server doesn't think you should be allowed to
connect. I'm sure if you read the page linked above you will be able to
persuade your MySQL server into allowing you to co
>6752 exit(1);
>6753}
>6754my_bind_addr = (ulong)
> ((in_addr*)ent->h_addr_list[0])->s_addr;
>6755 }
>6756 break;
>
>
> > And with other DBs, I can set 'sql.example.com' to resolve to N
> > IPs (N=4 in this example):
> >
> > 10.0.0.10
> > 1
> Hi,
>
> > Thank you very much! I'm willing to help test if you can provide me a diff
> > of your changes.
>
> Well, that was easy. I checked the code, and it turns out that the
> functionality is already there. I just tested it on my laptop (running
> 5.0.13) and it does indeed work.
>
>
> Hi James,
>
> >>> I would like to be able to bind to a host name, rather than
> >>> an IP number. IP numbers come and go, and are beyond the
> >>> control of anyone who doesn't have their own direct allocation.
> >>> But since I own
> Oh, no. I know about etc/hosts (even Windoze boxes has one). It's just
> normally not available for reference until you bind your socket library to
> at least one socket. Again, it's a cart and horse thing. You see, the
> etc/hosts file counts as a "local" DNS server and the DNS protocol
> re
id I make sense?
Yes, but none of the information was new.
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> James Long <[EMAIL PROTECTED]> wrote on 02/27/2006 03:59:14 PM:
>
> > > It doesn't allow to bind to a hostname. According t
iguration
parameter.
>
> On 2/22/06, James Long <[EMAIL PROTECTED]> wrote:
> > I would like to be able to bind to a host name, rather than
> > an IP number. IP numbers come and go, and are beyond the
> > control of anyone who doesn't have their own dir
I would like to be able to bind to a host name, rather than
an IP number. IP numbers come and go, and are beyond the
control of anyone who doesn't have their own direct allocation.
But since I own my domain, a host name is more permanent.
When the time comes to change IP numbers, I want to just
At 5:08 pm -0800 22/2/06, Scott Haneda wrote:
>I think we are close, thanks
>ERROR 1120: Cross dependency found in OUTER JOIN. Examine your ON
>conditions
> > SELECT p.id, p.prod_name, sum(oi.quantity) as qty
>> FROM Products p
>> LEFT JOIN orders as o
>> ON (p.id = oi.product_id)
Maybe
;s humongous... some lines above line 20 and
> some
> beneath...
>
> --
> Gabriel PREDA
> Senior Web Developer
>
>
> On 2/10/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
> >
> > James,
> >
> > You're going to need to show us the contents of ol
Sure, I just use "mysql db name < olddbname.sql
Regards,
James Dey
tel +27 11 704-1945
cell+27 82 785-5102
fax +27 11 388-8907
mail[EMAIL PROTECTED]
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 10 February 2006 11:58 AM
T
Could anyone perhaps let me know how I can remedy this,
Thanks a lot!
James Dey
tel +27 11 704-1945
cell +27 82 785-5102
fax +27 11 388-8907
mail <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
myGUS / SLT retains all its intellectual proper
l heavily load the
>system if you are not careful.
Yes indeed. You need to think carefully about what indices you need on your
tables. As has already been said, EXPLAIN SELECT is your friend!
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
7;s not very clear what the relationship between a multi-part key and
key_len is. From what the manual says I initially assumed that key_len simply
represented the number off key parts used. I don't think a manual suffers from
things being spelt out more clearly!
James Harvard
--
MySQL
e I see that it must be bytes, and I have posted a comment to
that effect on the manual page.
James
At 10:58 am -0500 2/2/06, sheeri kritzer wrote:
>according to:
>http://dev.mysql.com/doc/refman/5.0/en/explain.html
>
>"The key_len column indicates the length of the key that MySQ
exact number of rows someone could
still add another 20 rows in the second after you run SHOW TABLE STATUS.
James Harvard
At 5:54 pm -0700 1/2/06, Dan Trainor wrote:
>So, now this has made me think here. If 'SHOW TABLE STATUS' only shows an
>"estimate" of the number of
t correct?
TIA,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
First of all I would check for file system corruption.
IIRC there is a command line tool for repairing MyISAM tables, so you can use
that without needing the MySQL database server. I'm sure there are full details
in the manual:
http://dev.mysql.com/doc/refman/5.0/en/
Good luck!
James Ha
MySQL versions >= 4.1 use a new, more secure authentication protocol. Probably
the version of PHP you are using does not support it.
Ah, here it is:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
HTH,
James Harvard
At 1:18 pm -0600 29/1/06, Philip R. Thompson wrote:
>
nks-to-tables.html
HTH,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is
inflated, monopoly pricing which can only be hindering UK businesses from
developing localised on-line services.
James Harvard
At 4:00 pm -0500 24/1/06, Rhino wrote:
>You'd think that the people who run the post office in the UK - British
>Telecom?? - would have had a number of en
cannot be read/written to), then download
the appropriate installer from mysql.com and let the list know what problems
you encounter with that.
Good luck,
James Harvard
>On Jan 24, 2006, at 5:13 AM, James Harvard wrote:
>>Is there a reason why you're using Darwin Ports and not the
Your FIELDS clause is not in the right place:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
HTH,
James Harvard
At 7:06 pm -0500 17/1/06, kalin mintchev wrote:
> whats the problem with this:
>load data infile 'stores.txt' into table useyourcash_sports_us (chain,
>store,
It might be a good idea if you could post the results of an EXPLAIN SELECT ...
for a fast query and a slow query along with their actual SQL statements.
James Harvard
At 11:37 am -0800 12/1/06, Tripp Bishop wrote:
>I've got a question regarding optimizing a query.
--
MySQL General
dius of
3. Therefore you search WHERE x BETWEEN 3 AND 9 AND y BETWEEN 5 AND 11.
I'm not certain but I think MySQL should be able to used a combined index of
(x,y) for that. As you probably know you can use EXPLAIN SELECT to check
whether MySQL is using an index.
HTH,
James Harvard
At 12:01 p
You should be able to join the tables like this:
select p1.id /* and other cols */
from people1 p1
inner join people2 p2 on p1.Lname = p2.Lname and left(p1.Fname, 3) =
left(p2.Fname, 3)
group by p1.id;
HTH, James Harvard
>I have two independently built tables of people. I am trying to ma
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
I'd translate it to your example, but it's bed-time here in England!
HTH,
James Harvard
At 11:42 pm + 5/1/06, Terry Spencer wrote:
>I have a question for clearer brains than mine. I would like to joi
I assume you did not intend to post to this list, but if you did then this is a
problem with your application code, not with MySQL, so I'm afraid this list is
not the best place to ask.
James Harvard
At 11:19 am -0600 5/1/06, Ngim wrote:
>Hi all,
>
>I have an one insert state
ay of doing this though, if your tables are very
large.
This might work too:
select c_name, count(t.id) as t_count, max(t.date) as t_latest from customers c
inner join transactions t on c.c_no = t.c_no
group by c.c_no
having t_count > 4 and t_latest < '2005-06-05';
HTH,
James
0.01 seconds is so fast that I wonder if that's actually because the query
cache is storing the query. Do you have query cache enabled?
James
At 6:35 am + 5/1/06, C.R.Vegelin wrote:
>Hi James,
>I have found similar - slowdown - effects for queries.
>However, it is not alw
the subsequent queries
were not dealt with by the query cache.
Any ideas?
Thanks, James Harvard
# Time: 060103 9:45:12
# [EMAIL PROTECTED]: lasso[lasso] @ localhost [127.0.0.1]
# Query_time: 86 Lock_time: 0 Rows_sent: 12 Rows_examined: 6733255
select sql_cache dates.date_month from data_gb_e
401 - 500 of 1105 matches
Mail list logo
