Can someone figure out what's going on. This is the only change
I made to this table. Basically I don't want any duplicate rows, so
I setup 4 fields to be my primary key.
When I do a simple select query it takes nearly 30 seconds to complete.
This is affecting my websites and taking a very long t
218 classC: 357
So not having a primary key/index will slow my queries?
-Original Message-
From: Kishore Jalleda [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 10:49 AM
To: nngau
Cc: mysql@lists.mysql.com
Subject: Re: Multiple primary keys
On 4/27/06, nngau <[EMAIL PROT
I was able to install the mysql 5.0 on my machine. But it
Looks like there is a older version of mysql that was installed.
When I run this command:
mysql --version
mysql Ver 14.7 Distrib 4.1.13a, for apple-darwin8.0
Now I need to remove this version because when I
Type the command mysql to r
I don't know what happened. I was doing a very big query and now I'm not
Able to access mysql. This is the error I get when I try to use command:
Mysql -u root -p
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
How do I fix this? This is affecting my websit
Okay all seems to be fine now. All I did was restart the server for the 2nd
time
And now it seems to connect to mysql. Whew! I was starting to panic there.
-Original Message-
From: nngau [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 3:42 PM
To: mysql@lists.mysql.com
Subject
Sorry I apologize, it has to do something with my apache.
-Original Message-
From: James Harvard [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 11:46 AM
To: Ngim
Cc: mysql@lists.mysql.com
Subject: Re: Strange insert
I assume you did not intend to post to this list, but if
I did two query, can someone explain what happened?
First query:
mysql> select * from customer_billing where first_name="shad";
+--+---++-+---+---+-
-+---+--+--+--+-
-+---+
Ahh okay the column was cut off or something \G shows it!
Thanks!!
-Original Message-
From: Rich Lafferty [mailto:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 10:28 AM
To: mysql@lists.mysql.com
Subject: Re: Can someone explain strange query!!
On Fri, Apr 29, 2005 at 10:46:16AM -
Forgive me if this question has been answer in the past.
How can you record IP address on your first page index.html?
I am using my index.html to be index.lasso, and client_ip tag does not
seem to work.
It is picking up my server IP, and yes I have turned off the setting in
Lasso.
Now it see
Help! I did this query and it updated everything!
update customer_order_history set customerID="123 456 789 0123" where
invoiceid-12217;
I typed a '-' rather than an '='.
I haven't did a commit or a rollback saving point. Is there any other
way To undo this update??
Thanks.
--
MySQL Gener
7, 2005 10:17 AM
Cc: mysql@lists.mysql.com
Subject: Re: why does this query work??!!!
NNGau,
It works because 'where invoiceid-12217' is true for every invoice
except invoice 12217.
To undo it, assuming your server is running a binary log, back up the
table in its current state to a
11 matches
Mail list logo
