sql备份

MariaDB [codex_game]> select c.roleId, r.username, r.rolename, r.lv, c.chargeId, c.stone, c.isFirst, date_format(FROM_UNIXTIME(c.lastUpdateTime/1000),'%Y-%m-%d %H:%i:%s') lastUpdateTime  from charge c, role r where c.roleid=r.id order by lastUpdateTime asc;

+--------------------+------------+-----------------------+------+-------------------+-------+---------+---------------------+

| roleId             | username   | rolename              | lv   | chargeId          | stone | isFirst | lastUpdateTime      |

+--------------------+------------+-----------------------+------+-------------------+-------+---------+---------------------+

| 576605887838289923 | 1000005616 | 冲破地平线            |   17 | ANDROID_300       |   600 |       1 | 2019-01-23 12:08:52 |

+--------------------+------------+-----------------------+------+-------------------+-------+---------+---------------------+

48 rows in set (0.00 sec)

转载于:https://www.cnblogs.com/xingchong/p/10341345.html