Description:
MySQL RDBMS technical discussions.
|
|
|
Complex query on tree structure: Help!
|
| |
I have a table called 'category' >show fields in category; +-------------+--------------- ---+------+-----+---------+--- -------------+ ...+-------------+------------ ------+------+-----+---------+ ----------------+ ...+-------------+------------ ------+------+-----+---------+ ----------------+ This forms a tree structure under which items are listed. It is never... more »
|
|
|
difficult query...for me
|
| |
Hi everybody, I cannot figure out how to resolve this query that I am gonna describe to you: I have 2 tables: CLUB VISITS CLUB contains many fields but the affected ones are: idclub number_of_visits VISITS contains: idvisit type_of_visit idclub What I would like the query to do is: list the CLUB table and in the "number_of_visit" field and put the COUNT... more »
|
|
|
Got error 12 from storage engine
|
| |
mysql> show variables; ERROR 1030 (HY000): Got error 12 from storage engine mysql> show databases; ERROR 1030 (HY000): Got error 12 from storage engine mysql> show status; ERROR 1030 (HY000): Got error 12 from storage engine mysql> select * from mysql.user limit 1; +-----------+------+---------- ------------------------------ ---... more »
|
|
|
Table join question
|
| |
Hi, I'm just learning mysql and have a question about joining tables. I have two tables, and they both have a field called 'rating'. However, these two fields do not correspond to the same thing. If I join the two tables, how do I specify each particular 'rating' in the result? So if I have a table 'file' with these fields:... more »
|
|
|
Socket Server with MySQL
|
| |
I have a Java socket server that uses MySQL (5.0.27-community) as its backend. I've noticed if the server sits idle for a lengthy period of time (I have duplicated the results to generate a stack trace by not making a socket connection for 48 hours) it faults out with the stack trace listed below. I believe it is likely a mysql configuration... more »
|
|
|
Full outer join?
|
| |
I have used ms sql server 2008 express in school. I am new to sql. I have practiced using some of these joins from this example url here: [link] One of the joins i used was-> SELECT * FROM Table_A as A full outer Table_B as B ON A.PKey = B.PKey where A.PKey IS NULL OR B.Pkey IS NULL;... more »
|
|
|
Not so much empty resultset as empty field?
|
| |
My query doesn't work on the occassion that transaction_id is null, which may be the case. How would I fix this? I thought checking for num_rows would sort this but I guess that's looking for an empty resultset, not a query that doesn't work. $result = mysql_query("SELECT transaction_id FROM booking WHERE... more »
|
|
|
Error 1045 when connecting via Query Browser
|
| |
Hi, MySQL NB here. Got a MySQL on linux. When connecting from the local machine (mysql -u<user> -p<password>) I can log in. When trying from my Win machine to connect using Query Browser, I get error 1045 "Access denied for user '<user>'@'Windows Machine IP' (using password: YES). I tried various combinations of " grant ALL on <DB> to <user>@<IP>;",... more »
|
|
|
Join
|
| |
Afternoon all... Can someone help me with a join...as I now have no hair and am having trouble typing because of all the caffine... I have three tables: TABLE1, TABLE2 and TABLE3. All tables have the IDENTIFIER, QUANTITY and DATE. What I would like is to be able to produce a query that gives a list (for CURDATE()) a list of identifiers and quantities where each... more »
|
|
|
Question about nested JOINs+subqueries, which way is most efficient?
|
| |
For an application where users can nominate answers to survey questions, the master user can censor these to avoid abusive language such as obscenity etc. and approve all the reasonable answers, and then users can vote on their favorite already-approved answers by investing labor credits, I have three tables of... more »
|
|
|
|
