347 reputation
610
bio website
location
age
visits member for 2 years, 10 months
seen Nov 27 '13 at 16:24

Nov
24
comment Create a custom log table in MySQL
Thank you very much, it's working really good:D
Nov
18
comment INFORMATION_SCHEMA Selection Error
I spent a lot of time to figure out where the INFORMATION_SCHEMA tables are. finally I got it thanks for you ;)
Aug
22
comment MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench
Yes, I logged in as a root
Aug
17
comment Too Many Connections
Thank you for the helping, I already solved the problem, I added pause(0.1) after each insert. It's slow the insert because in one time I'm inserting 500 rows. And also I'm catching the connection error, if I exceed the 151 threads than I will wait a few seconds, and retrying to connect
Aug
4
comment Shift db data to another column
the default value is 0.0
Aug
2
comment MySQL Query Optimization : Bets and Averages
This is good, and faster than mine, I figured out that this query is returning only one value which is bigger than the average, but I want all row where the q1 are greater than the average.
Aug
2
comment MySQL Query Optimization : Bets and Averages
Yes, it worked.
Aug
2
comment MySQL Query Optimization : Bets and Averages
If it's help, this is the database, with data: sharetext.org/AZWV
Aug
2
comment MySQL Query Optimization : Bets and Averages
Still the same, not working.
Aug
2
comment MySQL Query Optimization : Bets and Averages
I'm still getting the same error.
Aug
2
comment MySQL Query Optimization : Bets and Averages
I tried your version, but I'm getting the following error: ERROR 1054 (42S22): Unknown column 'q1' in 'having clause'
Jul
22
comment Complex mysql selection
It is a really nice solution and complex, but I updated my table, and the ordering is depending sometimes I have to order where the bet is 1, you solved this, but sometimes I have to order where the bet is 1 or x
Jul
22
comment Complex mysql selection
Yes, I want to concatenate the odds where the bet_id equal .
Jul
20
comment Too many columns in MySQL
Is there maximum table number in a schema?
Jul
20
comment Too many columns in MySQL
It's a measurement system with 2000 sensors(lol)