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 Message - From

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: Beginner question - Preventing Duplicate Entries

2003-03-27 Thread Brian McCain
/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 Subject: Beginner question - Preventing Duplicate Entries

Re: Slow Inserts

2003-03-27 Thread Brian McCain
it 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 PROTECTED] To: Victor

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 6:48 PM Subject: mySQL with C

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 - From

MySQL 4.0 debian packages

2003-03-24 Thread Brian McCain
. 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: 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 simply would like to DELETE a FIELD from

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

2003-03-21 Thread Brian McCain
(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, March 21, 2003 2:29 PM Subject: Selecting identical rows from 2 tables

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 - Original Message

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.html Brian McCain

Re: Selecting only ONCE from multiple tables

2003-03-18 Thread Brian McCain
.* 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 [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 11:49 AM Subject: Re

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] UNION is new in MySQL 4. Be careful

Re: Updat not Updating

2003-03-14 Thread Brian McCain
. 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:49 AM Subject: RE: Updat not Updating I have an idea why this is but not 100

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 transmission. Brian

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: MySQL List [EMAIL

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

2003-03-14 Thread Brian McCain
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 PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday

Re: Innodb

2003-03-10 Thread Brian McCain
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 helps. Brian McCain