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
David,
> I don't have a good example, but suppose I have a few tables with some
> fields each and I realize that I should make a new table with data
from
> some columns of some tables. What to do?
Do you want to CREATE TABLE tbl_new SELECT (col1, col2, ...) FROM
tbl_old? Or do I miss something w
-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
