数据库怎么导入数据命令

2026-11-07 21:52:41

常见数据库导入命令示例

MySQL导入CSV文件示例:LOAD DATA INFILE 'file_path' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; PostgreSQL导入CSV文件示例:\copy table_name FROM 'file_path' WITH CSV HEADER; SQL Server可以用BULK INSERT命令实现导入。