Re: mySQL GUI

2003-04-04 Thread Brian McCain
MySQLCC is pretty popular, and it's probably the easiest to set up. http://www.mysql.com/products/mysqlcc/index.html I like MySQLTool though...it's clean and easy to use. http://www.dajoba.com/projects/mysqltool/index.html?_of=,10,20,14 - Original Message - From: "Neil Tompkins" <[EMAIL

Re: Security

2003-04-04 Thread Brian McCain
>From the fine manual: "4.2 General Security Issues and the MySQL Access Privilege System MySQL has an advanced but non-standard security/privilege system. This section describes how it works." http://www.mysql.com/doc/en/Privilege_system.html Brian McCain - Original Messa

Re: Slow Inserts

2003-03-27 Thread Brian McCain
ran. I found that adding a key to the name used in the lookup did, indeeed, slow down inserts a little bit, but it sped up the lookup exponentially, and as it turns out, that's what was causing the slowdown. Brian McCain - Original Message - From: "Dan Wright" <[EMAIL PROTE

Re: Beginner question - Preventing Duplicate Entries

2003-03-27 Thread Brian McCain
oc/en/CREATE_TABLE.html and http://www.mysql.com/doc/en/ALTER_TABLE.html for information about keys. -Brian McCain - Original Message - From: "Wileynet" <[EMAIL PROTECTED]> To: "'mysql users'" <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 3:03 PM Su

Re: BEGINNER QUESTION.

2003-03-24 Thread Brian McCain
You were so close... ALTER info DROP count; -Brian McCain - Original Message - From: "Wileynet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 5:26 PM Subject: BEGINNER QUESTION. > I have looked everywhere online, books. > I s

MySQL 4.0 debian packages

2003-03-24 Thread Brian McCain
le package. Thank you all at MySQL very much, btw, for the OSX package. It installed beautifully. -Brian McCain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fulltext search

2003-03-24 Thread Brian McCain
Maybe they should set up some way to donate via PayPal. I'm sure there are plenty of developers around the world who'd be willing to chip in $10 here or $20 there in order to be able to use fulltext searching on InnoDB tables. I know I would. -Brian McCain - Original Message

Re: mySQL with C

2003-03-24 Thread Brian McCain
If you mean a tutorial for compiling MySQL from source using gcc3.2, try here: http://www.mysql.com/doc/en/Installing_source.html -Brian McCain - Original Message - From: "David Matthews" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 23, 2003

Re: Selecting identical rows from 2 tables (basically Row AND Row)

2003-03-21 Thread Brian McCain
ere aren't keys on them (and if the number of columns is variable, it would probably be difficult to have the keys to handle all combinations of columns). Brian McCain - Original Message - From: "Hal Vaughan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, M

Re: Selecting only ONCE from multiple tables

2003-03-18 Thread Brian McCain
Actually, I just found a tutorial on how to mimic the "UNION" statement with MySQL 3.x: http://www.nstep.net/~mpbailey/programming/tutorials.union.php - Original Message ----- From: "Brian McCain" <[EMAIL PROTECTED]> To: "mysQL List" <[EMAIL PROTECTED]&g

Re: Selecting only ONCE from multiple tables

2003-03-18 Thread Brian McCain
o select T.* if T.Amount > 500 and C.* if C.Amount > 500. Which, without UNION, is only possible through separate queries, unless I'm missing something. Brian McCain - Original Message - From: "Bruce Feist" <[EMAIL PROTECTED]> To: "mysQL List" <[E

Re: error

2003-03-18 Thread Brian McCain
You don't want to use any calls to 'mysqladmin' inside of the MySQL Monitor, as mysqladmin is for command line functions (outside the command line)...you may want to reread some of the documentation on this, starting here: http://www.mysql.com/doc/en/Connecting-disconnecting.htm

Re: Fulltext Search Problem

2003-03-18 Thread Brian McCain
No, that should work. Do any items in the db have the text 'madrid' in them? Does it fail with an error or does it simply not return any results? Are you executing it on the command line? If not, are you checking for errors? What version of MySQL do you have? Brian McCain - Origin

Re: Looking for a bona fide distributed database that is open source

2003-03-14 Thread Brian McCain
Sorry, here's the link: http://www.emicnetworks.com/products/products_eac_mysql.html And the link to the MySQL newsletter issue: http://www.mysql.com/newsletter/2003-02/a000125.html Brian McCain - Original Message - From: "Bruce Feist" <[EMAIL PROTECTED]> To:

Re: Looking for a bona fide distributed database that is open source

2003-03-14 Thread Brian McCain
t they've got a free evaluation version, and it looks like it might do what you're looking for. If anyone has used this product, I for one would be really interested in hearing any feedback on it. Brian McCain - Original Message - From: "Bruce Feist" <[EMAIL PRO

Re: Remote Administration

2003-03-14 Thread Brian McCain
There are a few tools you can use to remotely administer MySQL graphically, if that's what you're looking for. You might be interested in MySQL Control Center http://www.mysql.com/products/mysqlcc/index.html although I'm not entirely certain about it's support for secure data

Re: Updat not Updating

2003-03-14 Thread Brian McCain
27;re inserting. Brian McCain - Original Message - From: "Andrew" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "cTpaXo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 10:4

Re: Innodb

2003-03-10 Thread Brian McCain
4x installed in your computer, you can install the corresponding -Max version with the same version number 3.23.4x just by replacing the MySQL server executable mysqld by the corresponding executable from the -Max version. MySQL and MySQL -Max differ only in the server executable --- Hope this help