Re: creating related tables

2002-12-02 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Brawley said... % % > I can't find a my.cnf file anywhere on this % > FreeBSD 4.5 system! % > % > I know [also from your other reply :-] that I can set various options in % > my personal .my.cnf file... Does that i

Re: creating related tables

2002-12-01 Thread Peter Brawley
> I can't find a my.cnf file anywhere on this > FreeBSD 4.5 system! > > I know [also from your other reply :-] that I can set various options in > my personal .my.cnf file... Does that include innodb file paths and the > like, or is that only in the system-level file? IMO it's best to have just

Re: creating related tables

2002-12-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Brawley said... % % David, % % >From any client... % SHOW VARIABLES LIKE 'version'; % or % SELECT @@version; % will show the version. Ahhh... Thanks! Well, it looks like we're at 3.23.52. Not all is

Re: creating related tables

2002-12-01 Thread Peter Brawley
David, The server and 8 command-line utilities (mysqladmin, mysqldump, mysqlimport, mysqlshow, mysqlcheck, myisamchk, mysqlhotcopy and myisampack) read MySQL option files. Under Linux, they read options from /etc/my.cnf, and under Windows they read from c:\windows\my.ini and c:\my.cnf, in that ord

Re: creating related tables

2002-12-01 Thread Peter Brawley
- Original Message - From: "David T-G" <[EMAIL PROTECTED]> To: "mysql users" <[EMAIL PROTECTED]> Cc: "Peter Brawley" <[EMAIL PROTECTED]> Sent: Sunday, December 01, 2002 11:58 AM Subject: Re: creating related tables > -BEGIN PGP SIGNED MESSAG

Re: creating related tables

2002-12-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Brawley said... % % Did you touch up my.cnf/ini to enable InnoDB? Oh, yeah -- can I do that on a per-user basis or is that for the whole database system? % % PB Thanks again & HAND mysql query, :-D - -- David

Re: creating related tables

2002-12-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Brawley said... % % Did you touch up my.cnf/ini to enable InnoDB? No, I didn't; I'm just a user here. I have yet to see details on whether or not we really have InnoDB support. Is there a way I can tell from the m

Re: creating related tables

2002-12-01 Thread Peter Brawley
Did you touch up my.cnf/ini to enable InnoDB? PB - - Original Message - From: "David T-G" <[EMAIL PROTECTED]> To: "mysql users" <[EMAIL PROTECTED]> Sent: Sunday, December 01, 2002 6:32 AM Subject: Re: creating related tables > -BEGIN P

Re: creating related tables

2002-12-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello again -- ...and then David T-G said... % % I would like to create a couple of related tables (just for starters) but % I can't figure out how to do it; there are lots of CREATE TABLE examples % in the mysql manual but nothing that shows related

creating related tables

2002-11-30 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I would like to create a couple of related tables (just for starters) but I can't figure out how to do it; there are lots of CREATE TABLE examples in the mysql manual but nothing that shows related columns. For instance, I'd have a client