Designing Table for Both Global and Local Indices

2007-11-23 Thread David T. Ashley
Hi, I am developing a large database where the web interface may be shared among many companies, but the data will generally not be shared. For the purposes of example, let's call it a bug tracking system such as Bugzilla. Each company has their own private software bugs. Many companies may ent

Unusual sort

2007-11-23 Thread Jim
I have a table containing web site host names, most of them having both a "name.com" and "www.name.com" version, that I'd like sorted in the following manner: axxx.com www.axxx.com bxxx.com www.bxxx.com wxxx.com www.wxxx.com zxxx.com www.zxxx.com Any way to do this? -- MySQL General Mailin

Re: Determining Table Storage Engine Type on Crashed Table

2007-11-23 Thread Richard Edward Horner
Good call, Paul. I'll try it out! Thanks, Rich(ard) On Nov 23, 2007 3:37 AM, Paul McCullagh <[EMAIL PROTECTED]> wrote: > Maybe this will work: > > SHOW CREATE TABLE table_name; > > > On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote: > > > Hey everybody, > > > > Hopefully some of you are a

Re: Determining Table Storage Engine Type on Crashed Table

2007-11-23 Thread Richard Edward Horner
Micah, I don't think this will work in all cases. Both a memory table and a blackhole table only have an .frm file. Admittedly, we can ignore blackhole table for practical purposes. But, while we're discussing practical purposes, an InnoDB table's data is in the main InnoDB storage file unless you

RE: Problem with a Procedure

2007-11-23 Thread Martin Gainty
Tomas-I would effect a quick iterative check on the table(s) to see if they are empty e.g. SELECT count(trans2.nettovikt) from trans2; (If recordcount>0) then SELECT SUM(trans2.nettovikt) FROM trans2 INNER JOIN artikel on trans2.artikel=artikel.artikel (If recordcount>0) then SELECT SUM(trans

Problem with a Procedure

2007-11-23 Thread Tomas Hylander
Hi! Hope you can help me with this one. Im trying to learn this with stored procedures and optimize my databases. Can someone point what wrong with this? -- DELIMITER

Re: MySQL crash on Debian Etch system

2007-11-23 Thread Norbert Tretkowski
Am Donnerstag, den 22.11.2007, 09:31 -0800 schrieb Frank Niedermann: > Nov 22 15:32:16 localhost mysqld[12720]: InnoDB: Last MySQL binlog file > position 0 1991372, file name /var/log/mysql/mysql-bin.000580 > > Is there a way to find out why MySQL crashed? You have the binlog and the position wher

Re: Determining Table Storage Engine Type on Crashed Table

2007-11-23 Thread Paul McCullagh
Maybe this will work: SHOW CREATE TABLE table_name; On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote: Hey everybody, Hopefully some of you are already enjoying time off. I am not...yet :) Anyway, is there a way to determine what storage engine a table is using if it's crashed? When