Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to export and import mysql data, the contents of the article are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand how mysql data is exported and imported.

1. Query data from mysql and import it into txt file

Mysql-h 10.3.20.251-u addata_r-P 3417-pARreBOEhw9MijIEN_eP6BYKOxkTikUnl ad_data-e "select id, advertiser_id,date,cost,0 as cash_cost, 0 as reward_cost, 0 as return_goods_cost, income,balance, create_time, ad_count, 'show',click,deal_base,'grant',compensation,frozen,transfer_out,transfer_in,income_all, DATE_FORMAT (date '% Y% m% d') as' datetime' from daily_accounting_new where date > = '2017-11-27' and date

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.