Is there a routine in MySQL similar to fn_dblog in SQL-server? I already search about fn_dblog and it is about transaction log and it is used in SQL SERVER. if there any way to do transaction log in MySQL like fn_dblog? i can't find one
Yes, you can use mysqlbinlog. Here are a few tutorials:


15 mysqlbinlog Command Examples for MySQL Binary Log Files
Identifying useful info from MySQL row-based binary logs
mysqlbinlog documentation for your version (going by the mysql-5.6 tag you used)