Reputation
Next tag badge:
98/100 score
33/20 answers
Badges
11 85 191
Newest
 Guru
Impact
~7.5m people reached

2h
comment Percona mysqld got signal 11
@winmutt Since mysql is open source, I should find the source code and globally change all occurrences of 'stack trace' and replace it with 'rabbit hole'.
9h
comment Database Dump/Backup but only to specific records?
The /tmp example in my answer was cut-and-pasted from the Documentation (dev.mysql.com/doc/refman/5.6/en/select-into.html). You are right it is permissions. You would have to play games with the secure_file_priv option or you could run mysqld as root to get around such restrictions.
18h
comment Database Dump/Backup but only to specific records?
Please tell us what operating system you are using : Windows or Linux ???
18h
comment Database Dump/Backup but only to specific records?
What exact data are you dumping ???
18h
comment Database Dump/Backup but only to specific records?
Do you want a specific student or just all students from schoolA ???
1d
comment How to do housekeep the database in sql server 2008 by specific date range?
Please provide the table structure for all to see
2d
comment Fulltext search using multiple indexes
Yes it does. It should be 3 operations, 1 resultset from MATCH(a, b, c), 1 resultset from MATCH(d), and a merger of the two resultsets.
2d
comment Percona mysqld got signal 11
Is the MySQL instance still up and running ???
2d
comment Mysql user accesable with out password from the host machine but not from the remote machine
Can you login locally as root@localhost ???
Jul
4
comment MySQL 1175 Error While Using Primary Keys
I changed the order of the UPDATE JOIN syntax : See my example in dba.stackexchange.com/questions/11811/…
Jul
2
comment How to write marker messages into the MySQL general_log?
@FranK. why not write that as an answer ?
Jul
1
comment MySQL: OPTIMIZE TABLE vs. myisamchk
Look at my Other difference
Jul
1
comment How to write marker messages into the MySQL general_log?
In MySQL it is simply SELECT NOW();.
Jul
1
comment How to write marker messages into the MySQL general_log?
Please run SELECT engine FROM information_schema.tables WHERE table_schema='mysql' and table_name='general_log'; What storage engine is the table ???
Jul
1
comment mysql replication and innodb_file_per_table
@AbdulManaf you should make it an answer.
Jun
29
comment How to become MySQL trainer?
I'm voting to close this question as off-topic because its about personal education on being a teacher.
Jun
28
comment Syntax error when creating SCHEMABINDING view
Is this MySQL or SQL Server ??? Syntax seems to favor SQL Server.
Jun
27
comment Problem with mysql group_concat, complex query, not getting required result
The section FROM ( up to ) A GROUP BY surrounds a subquery. The GROUP BY performs the aggregation of addresses for each combination of cname, ctype, tname, seats, hostel, dname. That combinations address so that the cname, ctype, tname, seats, hostel, dname are no longer duplicated.
Jun
26
comment Problem with mysql group_concat, complex query, not getting required result
I see a column called new between hostel and dname. Where is that coming from ???
Jun
26
comment MySQL loading NULLs in numeric columns
I was keeping the same table structure to reload and try again but with \N. If you look at the workaround in the bug report, there is a truncate bug_repeat; befoe the second LOAD DATA INFILE attempt. Thus, I was trying to duplicate the test of the workaround.