Mark,
I agree there is no reason for the sub-select. I'd make one change in
response to the original request - asking for the most recent item.
Take Mark's statement and suffix AND m.KeyDate = MAX(m.KeyDate); to
the last WHERE statement (see example).
UPDATE main m, sub s
SET m.Value =
Its doesn't look like you are starting the process as root. Turn into
root then start the process. Then exit turn back into you're user
account and use mysql.
Regards,
A$
- Original Message -
From: Jbo [EMAIL PROTECTED]
Date: Thursday, July 31, 2003 10:26 pm
Subject: Newbie question
Jim,
Great question!
I use the ol'Reddick VBA naming conventions.
tbl - table
idx - index
fld - field
You can search them in google, but I'd like to know if MySQL has its
own established conventions too.
Regards,
A$
- Original Message -
From: Jim Smith [EMAIL PROTECTED]
Date:
distinct.
-Original Message-
From: Adam Fortuno KOVICK [EMAIL PROTECTED]
Sent: 01 August 2003 15:24
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: standardized naming system ?
Jim,
Great question!
I use the ol'Reddick VBA naming conventions.
tbl
Normally I'd say do a select...into...from, but I don't think MySQL
supports that. In lew of that, try this:
(1) Create the new table.
CREATE TABLE tbl_table_b (
record SMALLINT NULL,
id SMALLINT NULL,
color VARCHAR(10)
);
(2) Insert the values from the source table to the destination.
-
From: Adam Fortuno KOVICK [EMAIL PROTECTED]
Sent: Friday, August 01, 2003 11:31 AM
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: Newbie question...memo field
Normally I'd say do a select...into...from, but I don't think MySQL
supports that. In lew of that, try this:
(1
All,
I've been attempting to assign a password to a user with the following
statement:
UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name';
I get the typical:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
However, when the user attempts the