mysql - 如何创建一个新表并将其导出为 csv？

Question

假设我将此作为我的 sql 脚本。我如何实际创建一个新表以便可以导出为 csv？

SELECT *

FROM `db`.tableParent1

INNER JOIN tableParent2
ON tableParent1.req_id=tableParent1.req_id

INNER JOIN tableParent3
ON tableParent1.req_id=tableParent3.req_id

UNION ALL

FROM `db`.tableChild1

INNER JOIN tableChild2
ON tableChild1.req_id=tableChild2.req_id

INNER JOIN tableChild3
ON tableChild1.req_id=tableChild3.req_id

Answer 1

要从查询创建新表，您需要输入“CREATE TABLE NAME as QUERY”

CREATE TABLE NAMEOFTABLE
AS
    SELECT *
      FROM db.tableParent1
           INNER JOIN tableParent2
               ON tableParent1.req_id = tableParent1.req_id
           INNER JOIN tableParent3
               ON tableParent1.req_id = tableParent3.req_id
    UNION ALL
    SELECT *
      FROM db.tableChild1
           INNER JOIN tableChild2 ON tableChild1.req_id = tableChild2.req_id
           INNER JOIN tableChild3 ON tableChild1.req_id = tableChild3.req_id

要将表格导出为 csv，请按照下一个 link 操作.

.