如何将表从mysql数据库导出到excel? [英] How to export table to excel from mysql database?

问题描述

我在 mysql 中有一个表，它有超过 10 万行，非常大，我想将它导出到 excel.但是，我尝试在 phpmyadmin 上导出到 excel 功能，但是转储 excel 文件需要很长时间.它甚至不是倾倒.错误始终是连接已重置".有没有其他方法可以做到这一点?

I have a table in mysql which is quite big for having over 100k rows and I want to export it to excel. However, I tried the export to excel function on phpmyadmin but it takes forever to dump the excel file. It's not even dumping. The error is always, "the connection is reset". Is there an alternative way on how to do this??

推荐答案

首先，Excel 中的 100k 行听起来很糟糕，当然这需要一段时间.这将需要一段时间才能打开.如果您必须这样做，请尝试:

First, 100k rows in Excel sounds like a horrible idea and of course it'll take awhile. This is going to take awhile just to open. If you MUST do this try:

SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
'

这应该会给你一个名为:/tmp/orders.csv 的文件，它将在 Excel 中打开.

This should give you a file called: /tmp/orders.csv which will open in Excel.

这篇关于如何将表从mysql数据库导出到excel?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！