Re: How do you create a join table?

2002-06-08 Thread BJ Phillips
The question is kind of *generic*. You can create tables and how u want to query them will not make a diff during creation. So, what exactly are you trying to do? You r probably trying to just grab info out of two different tables. If so, that does not *require* a join. If that is not what u r

RE: newbie help

2002-05-09 Thread BJ Phillips
"Mysql.org is an IMPOSTER's site." What? They are one in the same. -Original Message- From: Ryan Hatch [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 1:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: newbie help "bd"... Two things here: 1.) Mysql.org is a

RE: Password handoff

2002-04-16 Thread BJ Phillips
thanks all!! -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 11:27 AM To: BJ Phillips; Mysql Help Subject: RE: Password handoff mysql -u user -pPASSWORD ... See: http://www.mysql.com/doc/m/y/mysql.html Notice that there is no space between

Password handoff

2002-04-16 Thread BJ Phillips
Does anybody know how I would hand the password to this command line automatically? mysql -u root fastlane < /home/fastlane/queries/daily_netcfr_query -=BJ=- - Before posting, please check: http://www.mysql.com/manual.php

load data infile file location???

2002-04-12 Thread BJ Phillips
I can load files from '/home/mysql' but when trying to do it from any other user ('/home/user/directory'), I get an error 13 about cannot get stat on file such and such. The files are located on the server and are owned by the user, both mysql user and the system user. I specify the full path to

RE: BUG using left join.

2002-04-12 Thread BJ Phillips
Is the date read the same with or without the dashes? -Original Message- From: Steve Briant [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:17 AM To: [EMAIL PROTECTED] Subject: BUG using left join. Hi, I think I may have spotted a bug in connection with the LEFT JOIN statemen

RE: Access Denied

2002-04-12 Thread BJ Phillips
http://www.mysql.com/downloads/api-dbi.html -Original Message- From: Jane Tsai [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 9:12 AM To: Steven Hajducko Cc: [EMAIL PROTECTED] Subject: Re: Access Denied Steve, Thanks for help. To unpack the test/benchmarks RPM files: rpm -i