Re: read only message

2001-11-18 Thread Russell Miller
Have you tried checking the permissions on the .frm files? --Russell - Original Message - From: Barbara Ferrell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 18, 2001 9:08 AM Subject: read only message i am using linux redhat 7.2. on my home computer.. i am logged

Re: WELCOME to mysql@lists.mysql.com

2001-10-30 Thread Russell Miller
If you did not have any backups, then you're probably SOL. ALWAYS MAKE BACKUPS. --Russell - Original Message - From: Kelvin Cheong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 11:15 PM Subject: Re: WELCOME to [EMAIL PROTECTED] dear all, is their anyway at

Re: Bizarre query performance

2001-10-05 Thread Russell Miller
Have you tried explaining the two select to see where all the time is being spent and how the queries are optimized? --Russell - Original Message - From: Philip Brown [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 05, 2001 1:18 PM Subject: Bizarre query performance I

Re: Bizarre query performance

2001-10-05 Thread Russell Miller
It doesn't look like you are using an index. Have you tried creating one and seeing what the effect on execution time is? --Russell - Original Message - From: Philip Brown [EMAIL PROTECTED] To: Russell Miller [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, October 05, 2001 1:34 PM

schema

2001-10-03 Thread Russell Miller
Hi, I just got finished creating a database schema. I tried to follow all the rules and Normal Forms and all of that stuff, and I think I got it right, but as this is my first time creating a production schema I'm not sure. I was wondering if someone would be willing to take a look over my

Re: very newbie insert question

2001-10-03 Thread Russell Miller
I did not see the full schema so I can't give you a definite answer. However, your syntax is wrong: INSERT INTO email_addresses (last_name, first_name, email_address) VALUES ($lastname, $firstname, $email_address); For each value you specify, you also have to specify a column name. Did you set