Reputation
736
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 11
Newest
 Yearling
Impact
~61k people reached

Apr
25
comment Connecting to MySQL VM remotely (Azure Resource Manager)
10060 seems to be "connection timeout" error, so firewall is most likely the cause of this. Also the bind-address setting of mysql should be set to something else that 127.0.0.1 or localhost.
Apr
25
comment slave auto update - MySQL Replication
what do you mean by 'after one period' ? what is the binlog_format setting ( show global variables like 'binlog_format'; )? If the data is inserted on the master again it will be present on the slave.
Apr
25
answered Get distinct count from row and display in sepearte column
Mar
31
comment MySQL Explain gives different result for same query, query performance changes
Are you sure that everything is the same when MySQL produces those two different query execution plans? see stackoverflow.com/questions/25276127/… and stackoverflow.com/questions/18218071/… as those refer to a similar problem
Mar
31
answered MySQL code to show specific rows based on another…?
Mar
31
answered How to detect level in nested MySQL table?
Mar
23
comment How to detect level in nested MySQL table?
Also, it would help a lot if you specified what output exactly you want to get, in tabular form.
Mar
23
comment How to detect level in nested MySQL table?
you order the children 'Aston Martin' of based on what? the id? what is the 10 under 'Vanquish' supposed to mean?
Dec
11
awarded  Yearling
Aug
4
awarded  Constituent
Jul
28
awarded  Caucus
Apr
10
comment Mysql query to find nth largest entry in a column
Beware that the "LIMIT offset,number" approach does have performance implications on large offsets, i.e. the bigger offset is the more rows have to be scanned (and possibly JOINed) to get the right ones. This can hinder performance of complex queries severely.
Apr
10
answered On triggers and replication in MySQL
Jan
5
answered DROP PROCEDURE IF EXISTS not included in mysqldump
Dec
11
awarded  Yearling
Jan
9
comment MySQL: why provide size of a datatype in table definition?
the manual you are referencing to gives an explanation as well: dev.mysql.com/doc/refman/5.1/en/numeric-type-attributes.html
Dec
11
awarded  Yearling
Aug
20
reviewed No Action Needed Is SQLT safe to run in production?
Aug
2
reviewed No Action Needed How to optimise T-SQL query using Execution Plan
Aug
1
reviewed No Action Needed Does disconnecting the network stop a query?