RPM help

2006-01-06 Thread Jeffrey Goldberg
. I'm sure that there are tools or instructions on how to do that, but I haven't found any yet. Thanks for any help with this. Cheers, -j -- Jeffrey Goldberghttp://www.goldmark.org/jeff/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: RPM help

2006-01-06 Thread Jeffrey Goldberg
On Jan 6, 2006, at 4:38 PM, Jeffrey Goldberg wrote: I'm using SuSE 9.3 (not the Enterprise Server), and I would like to upgrade from MySQL 4.1 to the latest stable version. There do not appear to be SuSE rpms for 5.0. Someone has kindly pointed out to me off-list that there are generic

Re: MySQL 5.0 character sets

2005-10-28 Thread Jeffrey Goldberg
utf8 for everything, unless the window in which you run the client can't handle utf8. Remember, those accent marks matter. After all Szárba szökik just isn't the same without them. Minden jót. -j -- Jeffrey Goldberghttp://www.goldmark.org/jeff/ -- MySQL

Re: Map of MySQL Users

2005-10-24 Thread Jeffrey Goldberg
[posted only] On Oct 24, 2005, at 8:14 PM, Claire McLister wrote: if you go to the web page, http://www.zeesource.net/maps/help.do, then in the paragraph under the heading Automatic Maps the last sentence should give you the location of your IP. Hmm. That located me perfectly, but on the

Turning tables on their side

2005-10-19 Thread Jeffrey Goldberg
I suspect that this is the wrong list for this kind of question, but if someone could point me to appropriate sources, I would very much appreciate it. I am new to SQL but inherited project designed by someone who doesn't seem answer his email anymore. Essentially date were collected on

Re: Turning tables on their side

2005-10-19 Thread Jeffrey Goldberg
[mailed and posted] On Oct 19, 2005, at 3:34 PM, Brent Baisley wrote: The person you inherited from formatted the data correctly in my opinion. I agree. What you are trying to do is store the data as you see it, which is rarely a normalized data model. Your presentation layer should

Re: Turning tables on their side

2005-10-19 Thread Jeffrey Goldberg
[posted only] On Oct 19, 2005, at 4:07 PM, Jon Frisby wrote: Create an Excel spreadsheet. Import the raw data, structured as-is, into a worksheet. Select all the relevant columns. Go to Data - Pivot Table and Pivot Chart Report. Click Finish. From the PivotTable Field List, drag the

Re: Turning tables on their side

2005-10-19 Thread Jeffrey Goldberg
[posted only] On Oct 19, 2005, at 3:48 PM, sheeri kritzer wrote: One particular bit of SQL you may find helpful is this: concat(ifnull(a_id,),ifnull(a_text,)) concat with anything and a null value will produce a null value. That snippet of sql code will help you get one answer from the 2

Re: Encryption for mySQL 3.23

2005-10-05 Thread Jeffrey Goldberg
On Oct 4, 2005, at 4:34 PM, Jeff Pflueger wrote: Where might I find the key so that I can send it along to them? any suggestions on this? The password is what you need to send. The encryption and decryption functions generate a key from the password. Internally, the key that the

Documenting and visualizing a database

2005-09-25 Thread Jeffrey Goldberg
This is probably a FAQ, but I haven't been able to find the answer. Briefly, I am looking for tools that will help me document a database. Visualization would be nice too, so that I could quickly see the relations between tables. Less briefly. I am new to MySQL, SQL in general and

Re: Documenting and visualizing a database

2005-09-25 Thread Jeffrey Goldberg
On Sep 25, 2005, at 5:44 PM, Robert L Cochran wrote: I would start by writing down what you believe the database consists of: 1. The table structures -- write them down, commit them to paper. Thanks, I've already printed out all of table structure information. 2. The relationships you