| |
| |
| |
|
Comments:
<0> Hey. I have a little problem with one of my tables. I can't even take backup of it atm.
<0> I get "mysqldump: Got error: 1105: File '/usr/local/mysql/share/mysql/charsets/?.conf' not found (Errcode: 2) when using LOCK TABLES"
<1> flawed configuration
<0> Meaning?
<1> meaning you try to load something that doesn't exist
<1> probably installed it from an RPM or something
<1> RedHat / Fedora I presume
<1> which everybody worth a cent know is a PITA in the first place
<1> so that leave us with learn how to administrate your system and stop bugging us... http://www.tldp.org
<0> It's not my system. I'm trying to take backup of my tables. But thanks for being such a prick.
<2> hi
<2> Can we make an update with a condition ? I want to update data on specific table if some data exist in another table
<1> that would be an ordinary where clause
<1> http://www.kfwebs.net/links/6 for SQL
<3> hello I have a small question how can I give a privilege to a role to view only 2 records(specified by me) in a table?
<4> i have a table called Tags (TagID, TagName, TagItem) and a table called items (ItemID, ItemName, ItemData).... how can I form a query that will find ItemID's where two specific TagName's exist for that item (like all items tagged as both "cars" and "racing") ??
<5> hello
<5> anyone around?
<6> hi
<5> hello beebum, what's up?
<6> not much
<5> can you help me debug a query i have?
<6> maybe
<5> here is my query:
<5> SELECT users.name, messages.id, messages.from, messages.subject, (messages.status & 0) as read, messages.time FROM messages, users WHERE messages.to = 1 AND messages.from = users.id AND ~messages.status & 4 ORDER BY read ASC, messages.time DESC
<5> here's what was returned:
<5> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from , messages . subject , ( messages . status & 0 ) as read , messages . time ' at line 1
<5> any idea?
<6> i don't understand (messages.status & 0)
<5> bitwise
<6> i'm not familiar with bit operations
<5> i dont think that's the problem though
<5> when i take out the bit operations it doesn't work either
<6> what's the message when you take it out
<5> heres the query without bitwise operations
<5> SELECT users.name, messages.id, messages.from, messages.subject, messages.time FROM messages, users WHERE messages.to = 1 AND messages.from = users.id ORDER BY messages.time DESC
<5> heres the error
<5> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from , messages . subject , messages . time FROM messages , users WHERE messages' at line 1
<6> not sure but it could be the comma between the tables
<6> i'm not sure the tables are supposed to be separated by a comma
<5> think so?
<6> i'm in the middle of something else and it's late so anything goes
<5> heh
<5> thanks for helping
<2> help
<2> text type doest work with richtextbox
<2> what else I should use ?
<7> hello
<6> hi
Return to
#mysql
or
Go to some related
logs:
brotakul
#linux
#c++
#skype
#MissKitten
#javascript
#mysql
#squid
#linuxhelp
#php
|
|