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 (grp,id)
);
INSERT INTO
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
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
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
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
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
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
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,
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()
#
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
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
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
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,
I
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
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, most
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, most
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 was
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|
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
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
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: mysql@lists.mysql.com
Sent: Wednesday, April 23, 2008 3:46 AM
Subject: Re: a strange problem
Not knowing your msqyl
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,
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,
23 matches
Mail list logo