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
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
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
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
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
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
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
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