>You could use a temporary table for that:
>CREATE TEMPORARY TABLE tmp (
> deptID INT NOT NULL,
> appSeq INT NOT NULL
>) AS
>SELECT deptID, max(appSeq) AS appSeq
>FROM approvers
>GROUP BY deptID;
>
>UPDATE approvers, tmp
>SET approvers.appName = 'Sting Ray'
>WHERE approvers.appName = 'Joe Bass'
I have some tables for placing orders. Depending on the department, an
order must be approved by 1, or more, specific approvers.
create table department (
deptID int not null,
deptName varchar(32),
...
)
create table approvers (
deptID int not null,
appS
Here are some tables:
Create Table FN (
FNunid varchar(32) not null,
...,
PRIMARY KEY (FNunid)
);
Create Table Dependent (
DEPunid varchar(32) not null,
FNunid varchar(32) not null,
...,
PRIMARY KEY (DEPunid),
CONSTRAINT `0_69` FOREIG
How do I figure out the physical disk storage size of a table and of the
containing database? I'm using InnoDB. When I look at the directory
through the OS, I see the Ibdata1 file is about 1GB and a
MyServer-bin.06 file that is about 900MB. There are also other -bin
and various log files th
Is that equivalent to NOT running mysql_fix_privilege_tables? Or, do I
need to run the script -- or do I even need to run the script on a new 4.1
install; just go back and alter the table to change the size?
Didn't think of "Password hashing" as a search term. Thanks for the tip.
Randy
Randolp
It would be nice to dump the confidentiality statement. Unfortunately, our
mail server adds it to the message as it's sent to the internet -- I have
no control over it. It's alright though since my message is "intended to
be for the use of the entity named above." In this case, the MySQL list
c
I have a workstation that I set up as a 4.0.16 server to prove to myself
that I could use MySQL for an application we are developing. Now, for beta
testing, I set up a new 4.1.1 server on a real server box. I did not
upgrade the workstation with the 4.0.16 server. In setting up the new
server,
