Il mar, 2002-12-31 alle 12:53, David T-G ha scritto:
> Well, yeah, but I want to try to write portable code; just because I like
> mysql doesn't meant that my customer (or some future contract employer)
> will...
Hi,
I am reading a bit late, but let me suggest you Metabase. Metabase does
a very
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
...and then Benjamin Pflugmann said...
%
% Hi again.
And again :-)
%
% On Sun 2002-12-29 at 15:21:33 -0500, [EMAIL PROTECTED] wrote:
% > ...and then Benjamin Pflugmann said...
% [...]
% > % Of course, that's only possible if yo
Hi again.
On Sun 2002-12-29 at 15:21:33 -0500, [EMAIL PROTECTED] wrote:
> ...and then Benjamin Pflugmann said...
[...]
> % Of course, that's only possible if you can live with being
> % MySQL-specific.
>
> Hmmm... so it's a mysql thing and not a SQL thing. Well, I'd like to
> avoid that, even t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
Thanks for all of the help and info. Lots to learn and read :-)
...and then Benjamin Pflugmann said...
%
...
%
% And you have variables. If the above wouldn't work you could write:
%
% SELECT @card_hash := hash FROM ccard WHE
On Sat 2002-12-28 at 05:05:45 -0500, [EMAIL PROTECTED] wrote:
> ...and then Benjamin Pflugmann said...
[...]
> % If you choose to go the SQL route, have a look at TEMPORARY TABLES,
> % CREATE TABLE ... SELECT and INSERT ... SELECT. Don't forget that you
>
> You mean a CREATE TABLE command that ha
y)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 2:37 AM
Subject: altering data structure
> -BEGIN PGP SIGNED MESSAGE-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Benjamin, et al --
...and then Benjamin Pflugmann said...
%
% Hi.
Hi again!
%
% On Fri 2002-12-27 at 20:37:58 -0500, [EMAIL PROTECTED] wrote:
% > Hi, all --
% >
% > What's the best way to change your database schema around if you have
% > data i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
What's the best way to change your database schema around if you have
data in it? How do you know when to simply ALTER TABLE and when to dump
the whole thing (perhaps doing specific SELECTs to spit out the data
you'd like to have in the en