On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote:
Nope.
Well, have you tried it? Did it solve your problem?
--
Kim Christensen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote:
Nope.
Well, have you tried it? Did it solve your problem?
--
Kim Christensen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I need to turn off all constraints in a table (especially primary and
foreign keys) - because for example I need to exchange primary key
values of two rows in a table. And because of primary key constraints I
can do it directly. I would to turn off the constraint, rename value of
PK1
Hello,
we currently have a small database setup for affilates and visitor/leads. I
believe we have a one to many application, one affiliate can have several
visitor/leads but each visitor can only be assigned to one affiliate.
What I need to know if this the best design for this setup.
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Friday, February 17, 2006 7:49 AM
Subject: Database design help
Hello,
we currently have a small database setup for affilates and visitor/leads.
I believe we have a one to many
OK, I think I got it now. Thanks for the additional info, that helps alot.
Rhino wrote:
- Original Message - From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Friday, February 17, 2006 7:49 AM
Subject: Database design help
Hello,
we currently have a
did u start mysql with --skip-name-resolve ???
Kishore Jalleda
Kim Christensen wrote:
On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote:
Nope.
Well, have you tried it? Did it solve your problem?
Sorry, I misunderstood. I thought Kishore was saying that if I had
started the server
Hello,
I have a few hundred databases, with lots of tables and data, German and
English characters.
I'd like to upgrade to 4.1, but am concerned at losing or corrupting data in
the process.
What is the official way to take this latin1 3.23 dump and load it into the
brand new 4.1 utf-8
-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED]
Sent: Friday, February 17, 2006 08:42
To: Dirk Bremer
Cc: Gordon Bruce; [EMAIL PROTECTED]; gerald_clark;
mysql@lists.mysql.com; David Godsey
Subject: RE: Byte Swapping (Re Post)
Endianess is byte ordering not bit
Hi, all. I have a machine with lots of memory, and I'm
trying to avoid the disk entirely for some of our larger
reports. I was under the impression that CREATE TEMPORARY
would create in-memory tables and only write to disk if
tmp_table_size is reached, but that doesn't seem to be the
case: I've
Dirk,
My fear is that the output I must massage won't be 100% consistent across
different Linux
distros. It would make me feel all warm and fuzzy if I knew I could count on
a format that
would simply give me what I needed when I needed (pie in the sky, right?).
Anywho, I probbaly will just
I am trying to figure out how to get a comprehensive count of rows in
a database by year. Unfortunately, when there are no rows for a
particular year, the year is omitted from the result set, rather than
showing up with a zero count:
mysql select count(*) as count, repyear from mortality where
Chris,
Your WHERE clause is weeding out the NULL joined entries. Try something
like...
select
m.repyear as repyear,
count(*) as count
from years y
left join mortality m on y.year=m.repyear
where (
m.region like 'Southwest'
and m.repyear1985
and m.dthcode!=4
and (m.cause like '%red tide%' or
In the last episode (Feb 17), Chris Fonnesbeck said:
I am trying to figure out how to get a comprehensive count of rows in
a database by year. Unfortunately, when there are no rows for a
particular year, the year is omitted from the result set, rather than
showing up with a zero count:
Hello
when I do a describe a_table, it displays :
| Field | Type | Null | Key | Default | Extra |
I would like to have a Comment that would show
the meaning of a field. Extra is to be used for othe info.
I looked around at :
http://se2.php.net/manual/en/function.mysql-field-name.php
but
On 17.02.2006 15:34 (+0100), David Spidley wrote:
What is the official way to take this latin1 3.23 dump and load it
into the brand new 4.1 utf-8 database, with the characters being
converted during the load?
I'm not sure if the official way will help you. I've tried to copy a 4.0
database
16 matches
Mail list logo