Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8

2006-02-17 Thread Yves Goergen
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 (

describe table : improvement ?

2006-02-17 Thread Gilles MISSONNIER
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 bu

Re: showing zero counts in select statements with group by

2006-02-17 Thread Dan Nelson
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: > >

Re: showing zero counts in select statements with group by

2006-02-17 Thread Peter Brawley
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.repyear>1985 and m.dthcode!=4 and (m.cause like '%red tide%' or m

showing zero counts in select statements with group by

2006-02-17 Thread Chris Fonnesbeck
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 re

RE: (mysqldump) Serial output. . .?

2006-02-17 Thread mwilliams
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

Avoiding disk writes during CREATE TEMPORARY

2006-02-17 Thread Eamon Daly
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 se

RE: Byte Swapping (Re Post)

2006-02-17 Thread Dirk Bremer
> -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 n

Bulk conversion of 3.23 latin1 to 4.1 utf-8

2006-02-17 Thread David Spidley
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 database

RE: User is rejected because of IP, but hostname is allowed

2006-02-17 Thread Ryan Stille
>>> 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 starte

Re: Database design help

2006-02-17 Thread Mike Blezien
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" Sent: Friday, February 17, 2006 7:49 AM Subject: Database design help Hello, we currently have a small database s

Re: Database design help

2006-02-17 Thread Rhino
- Original Message - From: "Mike Blezien" <[EMAIL PROTECTED]> To: "MySQL List" 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" application, one

Database design help

2006-02-17 Thread Mike Blezien
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. Basi

How to turn off all constraints in a table?

2006-02-17 Thread Tomáš Vichta
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 to

Re: User is rejected because of IP, but hostname is allowed

2006-02-17 Thread Kim Christensen
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]

Re: User is rejected because of IP, but hostname is allowed

2006-02-17 Thread Kim Christensen
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]