[EMAIL PROTECTED] schrieb:
Hi,
I did a select on a primary key..
Select max(account_id) from mytable;
-- it gave me a value X
I did a select with order by
Select account_id from mytable order by account_id desc limit 3
-- it gave me a value of Y ( Y is the ri
liaojian_163 schrieb:
> hi,all.
> In my mysql server,I have a strange problem.
> can someone help me?
> Thank you.
>
> mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41
> and id >2500 order by id desc limit 10;
> +--+-+-+
> | id | clas
On Tue, Apr 22, 2008 at 1:13 PM, "Bruno B. B. Magalhães"
<[EMAIL PROTECTED]> wrote:
> Hi Phill, Rob and Perrin,
>
> I forgot to attach the explain query from MySQL, course it's one of the most
> important things... Sorry!!!
>
> EXPLAIN SELECT UNIX_TIMESTAMP(transactions.transaction_date) AS date,
Hi Phill, Rob and Perrin,
I forgot to attach the explain query from MySQL, course it's one of
the most important things... Sorry!!!
EXPLAIN SELECT UNIX_TIMESTAMP(transactions.transaction_date) AS date,
transactions.transaction_complement AS complement,
I don't think that the limit cause the stange problem.
thank you anyway.
- Original Message -
From: "Phil" <[EMAIL PROTECTED]>
To: "liaojian_163" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
> Not knowing your msqyl version, perhaps it'
Not knowing your msqyl version, perhaps it's the form of your LIMIT clause.
try LIMIT 0,10 instead.
Phil
2008/4/22 liaojian_163 <[EMAIL PROTECTED]>:
> hi,all.
> In my mysql server,I have a strange problem.
> can someone help me?
> Thank you.
>
> mysql> select id,classid,newstime from phome_ecms
Hi,
I did a select on a primary key..
Select max(account_id) from mytable;
-- it gave me a value X
I did a select with order by
Select account_id from mytable order by account_id desc limit 3
-- it gave me a value of Y ( Y is the right value )
I was wonderin
hi,all.
In my mysql server,I have a strange problem.
can someone help me?
Thank you.
mysql> select id,classid,newstime from phome_ecms_zhichang where classid=41
and id >2500 order by id desc limit 10;
+--+-+-+
| id | classid | newstime|
+--+
On Tue, Apr 22, 2008 at 11:41 AM, Bruno B. B. Magalhães
<[EMAIL PROTECTED]> wrote:
> I thing
> the most problematic part of those queries are the date range part, should I
> use a different index only for this column to maintain the index small?
My experience with doing data warehousing in MySQL
On Tue, Apr 22, 2008 at 8:41 AM, Bruno B. B. Magalhães <
[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
> I am back to this list after a long period away due to work time
> restrictions... I have great news and a few interesting applications that I
> will release to the mysql community very soon, mos
On Tue, Apr 22, 2008 at 8:41 AM, Bruno B. B. Magalhães <
[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
> I am back to this list after a long period away due to work time
> restrictions... I have great news and a few interesting applications that I
> will release to the mysql community very soon, mos
I'm rebuilding a server that is a slave to our primary. At this
point in the game, I can no longer access anything on the slave server
(its main drive is being rebuild). However, I do have a full rsync of
the /var/lib/mysql folder that was on it (this rsync was done AFTER
MySql was prope
I'm sure if you created an index on
client_id,client_unit_id,transaction_date (with optionally something else to
make unique) it would increase performance.
What does an EXPLAIN give you?
Phil
On Tue, Apr 22, 2008 at 11:41 AM, Bruno B. B. Magalhães <
[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
Hi everybody,
I am back to this list after a long period away due to work time
restrictions... I have great news and a few interesting applications
that I will release to the mysql community very soon, most probably as
open source.
But now I have a performance problem with a client of min
Ingo Weiss schrieb:
Hi all,
I have an application where items can be tagged. There are three tables
'items', 'taggings' and 'tags' joined together like this:
items inner join taggings on (items.id = taggings.item_id) inner join
tags on (tags.id = taggings.tag_id)
Now I have been struggli
Hi all,
I have an application where items can be tagged. There are three
tables 'items', 'taggings' and 'tags' joined together like this:
items inner join taggings on (items.id = taggings.item_id) inner
join tags on (tags.id = taggings.tag_id)
Now I have been struggling for some time no
Victor Subervi schrieb:
Hi;
The python code works properly, so I assume this is a strictly MySQL
question now :)
If I grab an image in the database thus:
sql = "select pic1 from products where id='" + str(id) + "';"
cursor.execute(sql)
pic1 = cursor.fetchall()[0][0].tostring()
On Tue, 22 Apr 2008, Sebastian Mendel wrote:
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi list,
reading manual on mysql regarding auto_increment with multiple-column
index:
CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
You are right, I've tried 5.0.18 and 5.0.45 which work.
There must have been a bug in 5.0.41 with which I used test the question...
I belive the question has been answered by now anyway :)
Ben
Sebastian Mendel wrote:
Ben Clewett schrieb:
Are you sure, I just get:
CREATE TABLE ...
ERROR 1
Eric Bergen schrieb:
> TCP checksums aren't as strong as encryption. It's rare but corruption
> can happen.
>
But it happens every other day? that means at least one error in 4GB of
data (I have around 2GB of binlogs/day)?
Every DVD-ISO you download would be corrupt (statistically)?
> Where are
Ben Clewett schrieb:
Are you sure, I just get:
CREATE TABLE ...
ERROR 1075 (42000): Incorrect table definition; there can be only one
auto column and it must be defined as a key
the mentioned CREATE TABLE is fine and works
On version 5.0.41. What version are you using?
this works on al
Are you sure, I just get:
CREATE TABLE ...
ERROR 1075 (42000): Incorrect table definition; there can be only one
auto column and it must be defined as a key
On version 5.0.41. What version are you using?
Hiep Nguyen wrote:
hi list,
reading manual on mysql regarding auto_increment with m
B. Keith Murphy schrieb:
A simple rsync should do the trick. How long will depend on how much
data you have. I would just shut down the server, copy over the data
directory and start the new server up. Should be a piece of cake.
Keith
David Ruggles wrote:
I have a MySQL 5.x box and I am t
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi list,
reading manual on mysql regarding auto_increment with multiple-column
index:
CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (gr
24 matches
Mail list logo
