362 reputation
1614
bio website
location
age
visits member for 3 years, 4 months
seen Sep 4 at 14:32

Aug
29
asked Preordering the table by a specified column
Aug
24
accepted Clear all tables with one DELETE
Aug
23
asked Clear all tables with one DELETE
Aug
22
comment MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench
Yes, I logged in as a root
Aug
22
asked MySQL tables do not show up in the phpMyAdmin and MySQLWorkbench
Aug
18
accepted Too Many Connections
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
17
asked Too Many Connections
Aug
6
accepted Shift db data to another column
Aug
4
comment Shift db data to another column
the default value is 0.0
Aug
4
accepted MySQL Query Optimization : Bets and Averages
Aug
4
asked Shift db data to another column
Aug
4
accepted Character Set Encoding in a Table
Aug
2
revised MySQL Query Optimization : Bets and Averages
added 22 characters in body
Aug
2
revised MySQL Query Optimization : Bets and Averages
added 352 characters in body
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
awarded  Commentator
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.