Data Dictionary

2008-07-15 Thread Dan
Can anyone recommend a good tool to generate a PDF or HTML Data Dictonary from a MySql 5 database? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update replace / Operand should contain 1 column(s) 1241

2008-07-15 Thread Rob Wultsch
On Tue, Jul 15, 2008 at 7:59 AM, Guenter Ladstaetter <[EMAIL PROTECTED]> wrote: > UPDATE `phpbt_bug` > SET title = REPLACE (phpbt_bug.title,"ö","ö") > WHERE bug_id IN > (select bug_id, title from phpbt_bug where `title` LIKE "%ö%"); > > > The error message is: Operand should contain 1 column(s) 12

Update replace / Operand should contain 1 column(s) 1241

2008-07-15 Thread Guenter Ladstaetter
Hello, i'm trying to replace german umlauts by using a simple update replace statement but can't find the syntax error: UPDATE `phpbt_bug` SET title = REPLACE (phpbt_bug.title,"ö","ö") WHERE bug_id IN (select bug_id, title from phpbt_bug where `title` LIKE "%ö%"); The error message is: Operan

Re: Table Design

2008-07-15 Thread John Hicks
Neil Tompkins wrote: Hi, I've the following table design (attached txt file, for some reason the content was being blocked) and I'd like any advice if this is the correct method/design. TableName:ProductMaster ProductMasterID FriendlyProductName TableName:ProductContent ProductContentID P

Re: multiple mysql servers

2008-07-15 Thread Madan Thapa
On Tue, Jul 15, 2008 at 7:05 PM, Madan Thapa <[EMAIL PROTECTED]> wrote: > Hello, > > I already have mysql 4 installed on datadir /var/lib/mysql and basedir > /var/lib on RHEL5 running on port 3306. I want to run another instance in > /home/mysql5 with datadir = /home/mysql5 and basedir=/home on p

multiple mysql servers

2008-07-15 Thread Madan Thapa
Hello, I already have mysql 4 installed on datadir /var/lib/mysql and basedir /var/lib on RHEL5 running on port 3306. I want to run another instance in /home/mysql5 with datadir = /home/mysql5 and basedir=/home on port 3307. I installed as follows, but when I try to start mysql5, it fails to sta

design question

2008-07-15 Thread robert rottermann
hi there, I am a casual database tinkerer that has to build a new database. so please do not fall down laughing if I ask stupid questions .. the problem at hand is that I want to create tables with the following structure: - suppliers they produce/deal-with 0 to n products - products a prod

Table Design

2008-07-15 Thread Neil Tompkins
Hi, I've the following table design (attached txt file, for some reason the content was being blocked) and I'd like any advice if this is the correct method/design. Thanks for any comments. Neil _ Play and win great prizes with Li