mysql linux 数据导出_linux mysql数据导出

一、登录数据库服务器

二、导出语句格式

mysql 数据库  -u用户  -p密码  -e  "select   *   from   xx.yy"   >   d:/test.xls

mysql jlt2 -uroot -pkiller -e "SELECT

WmsOrderBase.order_sn,

SaleOrder.order_sn AS sale_order_sn,

WmsOrderBase.type_id,

WmsOrderBase.consignee_name,

WmsOrderBase.consignee_phone,

WmsOrderBase.consignee_address,

WmsOrderBase.house_id,

WmsHouse.house_name,

WmsOrderBase.province_id,

WmsOrderBase.city_id,

WmsOrderBase.country_id,

Province.region_name AS ProvinceName,

City.region_name AS CityName,

County.region_name AS CountyName,

WmsOrderItem.sku_id,

WmsOrderItem.goods_id,

WmsOrderItem.sku_name,

WmsOrderItem.sku_num,

WmsOrderItem.space_id,

WmsHouseSpace.space_name

FROM

wms_order_base AS WmsOrderBase

LEFT JOIN wms_order_item AS WmsOrderItem ON WmsOrderItem.order_id = WmsOrderBase.order_id

LEFT JOIN wms_house AS WmsHouse ON WmsHouse.house_id = WmsOrderBase.house_id

LEFT JOIN wms_house_space AS WmsHouseSpace ON WmsHouseSpace.space_id = WmsOrderItem.space_id

LEFT JOIN global_region AS Province ON Province.region_id = WmsOrderBase.province_id

LEFT JOIN global_region AS City ON City.region_id = WmsOrderBase.city_id

LEFT JOIN global_region AS County ON County.region_id = WmsOrderBase.country_id

LEFT JOIN sale_order AS SaleOrder ON SaleOrder.order_id = WmsOrderBase.out_order_id

WHERE

WmsHouse.master_id >= 90" > /home/u.txt

三、cd  /home目录下(语句哪儿选择的那个目录就进入那个目录)

四、 sz 文件名字   eg：sz u.txt

桌面或者其他(sz 时选择的路径)就有个u.txt文件

五、  把u.txt弄成excel文件

有些字段数字很长 会是科学计数法 变成excel格式后再转换成文本数据会错误  这儿要选择下成文本

然后修改 另存为就OK了