Re: NuSphere

2001-11-20 Thread Russell Miller
http://www.mysql.com/news/article-75.html --Russell - Original Message - From: "Juan Ildefonso Núñez Pérez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 20, 2001 6:54 AM Subject: NuSphere > Hello!!! > > I use Mysql since some time ago and I've allways heard a

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

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 a

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 PR

Re: Bizarre query performance

2001-10-05 Thread Russell Miller
Have you tried "explain"ing 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

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 yo

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 sche