RE: MySQL Installation

2002-11-08 Thread SpyProductions Support Team
uery > > ~Kelly W. Black > > PS IN the future check out http://www.rpmfind.net/ > > -Original Message- > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > Sent: Friday, November 08, 2002 12:51 PM > To: Black, Kelly W [PCS] > Cc: [EMAIL PROTECTED] >

RE: MysQL Installation

2002-11-08 Thread SpyProductions Support Team
;[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: MysQL Installation > > > Mysqladmin is seperate rpm > > ~K Black > > -----Original Message- > From: SpyProductions Support Team [mailto:support@;spyproductions.com] > Sent: Friday, November 08, 2002 11:13 AM &

MysQL Installation

2002-11-08 Thread SpyProductions Support Team
I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -Mike - Before posting, please check: http://www

MySQL statement problem

2002-05-20 Thread SpyProductions Support Team
Shouldn't this come up with a list of names from each table that matches? SELECT * FROM table1,table2 WHERE table1.name = table2.name; Does anyone see anything wrong with this query? It keeps giving me an empty set - but there definitely matches. I even did a LIKE instead of =, takes longe

RE: Getting Data From One Table Based On Another - Agh!

2002-02-20 Thread SpyProductions Support Team
gt; Subject: RE: Getting Data From One Table Based On Another - Agh! > > > SELECT Table1.orderid, Table2.otherfield1, Table2.otherfield2 > FROM Table1, Table2 > WHERE Table1.orderid = Table2.orderid; > > --Greg Johnson > > -Original Message- > From: SpyProductions S

Getting Data From One Table Based On Another - Agh!

2002-02-20 Thread SpyProductions Support Team
Looking through the MySQL stuff online, I still can't come up with a statement to pull data from one table based on data from another. Table1 Contains: orderid Table2 Contains: orderid otherfield1 otherfield2 I want to get the data from table 2 based on a matching orderid first pulled from t

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread SpyProductions Support Team
> Jeremy Zawodny wrote : > > > > I'm getting duplicate messages separated by several hours. Am I alone > > in this, or are others seeing it too? > > > > Jeremy > > -- > > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > > Technical Yahoo - Yahoo Finance > > Desk: (408) 349-7878 Fax: (408) 349-5454

Granting Privileges

2002-01-28 Thread SpyProductions Support Team
Hey there! Hoping someone can help me out when it comes to granting privileges for a user in MySQL. Basically, I have granted privileges to a user who I do not want to have root access and I want to minimize his access to only his databases. Using the MySQL manual, I granted him basic privileg