meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years |
| seen | May 20 at 20:39 | |
| stats | profile views | 38 |
|
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) |
