SELECT command denied to user 'user'@'localhost' for table 'table'

Hello, We are experience an estrange problem with mysql and we need help to debug this properly. We have a mysql server 5.0.67 on a ubuntu intrepid. Sometimes we have one unique query that cannot be executed and we get this error: SELECT command denied to user 'user'@'local

RE: select command

: mysql; asus77x Subject: Re: select command You should not contact people on the MySQL list offline; all communication should be via the list so that everyone can benefit from the discussion. As I said earlier, your WHERE clause does not make sense the way you expressed it in your first email. I

Re: select command

AIL PROTECTED]> Sent: Thursday, November 24, 2005 9:55 PM Subject: RE: select command Hi rhino, Yes, I want the table name, and those two other variable are variety in the query command. Could you advise the correct command ? Ps: my English is not good enough, so hope you can understand my q

Re: select command

Hello. > Becomes to like varName or varTmp ? Sorry, but I'm not completely understanding your question (may be because I'm not familiar with dreamweaver). What does it mean 'like varName or varTmp'? Do you want to change the name from reg_one to var_one? Or you want to be able dynamically

Re: select command

- Original Message - From: "asus77x" <[EMAIL PROTECTED]> To: Sent: Thursday, November 24, 2005 2:07 AM Subject: select command I have a command : SELECT * FROM reg_one WHERE 'varName' like 'varTmp' % This is made within dreamweaver mx.

select command

I have a command : SELECT * FROM reg_one WHERE 'varName' like 'varTmp' % This is made within dreamweaver mx. varName and varTmp is a textselect. Does anyone can help how to make "reg_one" Becomes to like varName or varTmp ? Send instant messages to your online friends http://asia.messenger.y

RE: select command with a search?

Thank you, That did the trick. > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 12:17 AM > To: [EMAIL PROTECTED] > Subject: Re: select command with a search? > > "Christopher Lyon" <[EMAIL PROTECTED

Re: select command with a search?

> I want to be able to search for specific text in a field and return the > results for those rows. What is the best way to go about it? Do I use > the regex stuff or match? You can use - ...WHERE column LIKE '%specific text%' - "use the regex stuff" (which is mostly slower than LIKE) - MATCH afte

Re: select command with a search?

"Christopher Lyon" <[EMAIL PROTECTED]> wrote: > I want to be able to search for specific text in a field and return the > results for those rows. What is the best way to go about it? Do I use > the regex stuff or match? > It depends. You can use LIKE, REGEXP, full-text search for those purpose:

select command with a search?

I want to be able to search for specific text in a field and return the results for those rows. What is the best way to go about it? Do I use the regex stuff or match? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Mysql SELECT command

L specific. Best of luck!! -Original Message- From: Nasir Ali [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 9:51 AM To: [EMAIL PROTECTED] Subject: Mysql SELECT command Can somebody please point me to the good resourse of learning mysql's SELECT co

Re: Mysql SELECT command

On Thu, 14 Jun 2001 13:50:43 -0300, Nasir Ali <[EMAIL PROTECTED]> wrote: Well as they say, "...if all else fails, RTFM.." :) Or pick up Paul Dubois's book on MySQL. >>Can somebody please point me to the good resourse of learning mysql's >>SELEC

Mysql SELECT command

Can somebody please point me to the good resourse of learning mysql's SELECT command on the Internet? Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq