RE: mysql comes with linux ?

2002-08-19 Thread Aron Pilhofer
I don't know if it is installed by default or not (in most distros it is not), but checking is easy enough: When you get to the point of selecting packages, click on the choose individual packages button or radio box (it's been a while since I have done a RH installation) and select MySQL and

RE: mysql comes with linux ?

2002-08-19 Thread Aron Pilhofer
The Red Hat Database is PostgreSQL, but I don't think it comes with RH. Isn't it a seperate (and rather costly) add-on? -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 4:40 PM To: [EMAIL PROTECTED] Subject: RE: mysql comes with linux

RE: Strange PHP + MySQL add / update issue with NULL values

2002-08-17 Thread Aron Pilhofer
Try this instead: INSERT INTO table SET required_field = -Original Message- From: Dan Tappin [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 17, 2002 12:56 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Strange PHP + MySQL add / update issue with NULL values I have a

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
Not to open a can of worms here, Mary, but I'd love to know exactly how you got those results, since they basically contradict every known benchmark I have seen (at least those not funded by M$... this being one: http://www.eweek.com/article2/0,3959,293,00.asp) as well as every benchmarking test

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
DOH! See what happens when I post before having a nice cup of coffee? My face is red. Never mind. :) aron -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:53 AM To: Francisco; Elizabeth Bogner; [EMAIL PROTECTED] Subject: RE: MySQL

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
going. and going and going... -Original Message- From: Aron Pilhofer [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:25 AM To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED] Subject: RE: MySQL vs. Oracle (not speed) Not to open a can of worms here

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
I'm sorry, but are you and I reading the same thread here? :) -Original Message- From: Serge Paquin [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 12:01 PM To: Mark Matthews Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MySQL vs. Oracle (not speed) I think

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
You can index fields with nulls. You can't make into a primary key, that's all. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 12:38 PM To: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED] Subject: RE: MySQL vs. Oracle (not speed)

RE: Access to MySQL

2002-08-16 Thread Aron Pilhofer
If your table(s) are already set to comply with MySQL's much stricter formatting standards (e.g., spaces in field names, etc), then you can simply create an ODBC connection and export your table to the MySQL database. That does not always work, and does not always work well. But it is pretty

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
The explain command is still a little confusing new to me, but... does this ;tempsap;ALL;10019; ... not mean that MySQL is not recognizing the indexes on the tempsap - AdminProducer join? -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] Sent: Friday,

RE: mysql 4.1?

2002-08-13 Thread Aron Pilhofer
Sorry, but I can't seem to locate the page that addresses this question specifically -- so, what version is scheduled to support views? -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 5:40 AM To: [EMAIL PROTECTED] Subject:

NULL values -- expected behavior or bug?

2002-08-12 Thread Aron Pilhofer
! : Aron Pilhofer : Director, Campaign Finance Information Center : Investigative Reporters and Editors : National Institute for Computer-Assisted Reporting ~ : Phone: (202) 362-3223 : Email: [EMAIL PROTECTED] :SQL Forever - Before

RE: NULL values -- expected behavior or bug?

2002-08-12 Thread Aron Pilhofer
this is the expected, correct behavior or a bug? Also, if there's any workaround that makes those blanks into true NULLs? Hope that's clearer. Thanks in advance! : Aron Pilhofer : Director, Campaign Finance Information Center : Investigative

RE: Re: Importing into MySQL from Access

2002-08-12 Thread Aron Pilhofer
I don't think that's going to work because it sounds like the escapes are built into the data. The only thing I can think of is to run it through a function first to strip out said escape characters, and then import it. PHP has a stripslashes() function that does that, and you certainly could

RE: RE: NULL values -- expected behavior or bug?

2002-08-12 Thread Aron Pilhofer
sql,query The current behavior is what I'd expect to have happen, and what I'd expect most people to expect to have happen. Maybe you just need to adjust your expectations. Paul/Keith: OK, I see. It was a varchar field, so I assume it must have been entering empty strings where