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 you
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 though
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 has
-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
-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 in
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