MySQL exports some data according to conditions

What should I do if I want to export some data in a table? MysqldumpMySQLmysqldump-uroot-p -- no-create-dbTRUE -- add-drop-tableFALSE -- whereuser128560 database name -- skip-lock-tablesdata. SQL # where -- where specifies the query condition SELECTorder_id, product_name,

What should I do if I want to export some data in a table? Mysqldump MySQL mysqldump-u root-p -- no-create-db = TRUE -- add-drop-table = FALSE -- where = "user = 128560" Database Name table name -- skip-lock -tables data. SQL # where -- where is used to specify the query conditions SELECT order_id, product_name,

What should I do if I want to export some data in a table?
Mysqldump MySQL

Mysqldump-u root-p -- no-create-db = TRUE -- add-drop-table = FALSE -- where = "user = 128560" Database Name table name -- skip-lock-tables> data. SQL # where -- where is used to specify the query Conditions

SELECT order_id,product_name,qty FROM orders INTO OUTFILE '/data/data.txt'