何虎军

导入 sql 表 > SOURCE /home/username/sample.sql 显示表结构 > DESCRIBE/DESC/EXPLAIN sampleTable; 使用数据库 > USE databaseName; 删除数据库 > DROP databaseName; 创建表 > CREATE TABLE sampleTable(id integer primary key au

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