MYSQL与XLS文件比较复杂,但你可以从MYSQL中导出CSV文件,这个文件EXCEL也可以直接打开。 select * from ..... INTO OUTFILE 'file_name' [CHARACTER SET charset_name] export_options 同样EXCEL可以把文件另存为CSV文件,然后直接导入MYSQL。 LOAD DATA INFILE 'file_name' INTO TABLE tbl_name [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES]
select * from .....
INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
同样EXCEL可以把文件另存为CSV文件,然后直接导入MYSQL。
LOAD DATA INFILE 'file_name'
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html