1.select FROM_UNIXTIME(member_login_time) from test 时间搓转时间格式
select UNIX_TIMESTAMP(member_login_time) from test 时间格式转时间搓
2.select INET_ATON(‘124.200.102.18‘) from member
select INET_NTOA((‘2093508114‘)) from member
原文：http://www.cnblogs.com/fuckV/p/7505347.html