在iPhone上读取CSV文件到sqlite3中 [英] Read CSV file into sqlite3 on the iPhone

问题描述

有没有办法在iPhone上读取CSV文件到sqlite3？是否有类似于SQL命令的sqlite3功能

Is there a way to read a CSV file into sqlite3 on the iPhone? Is there sqlite3 functionality similar to the SQL commands

LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE TABLENAME FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';

一种方法是将CSV文件转换为sqlite3可以自动读取的格式，iPhone会将应用程序打开？

Or is there an approach that converts the CSV file into a format that sqlite3 can read automatically which the iPhone brings up the application?

推荐答案

请尝试使用firefox addonSQLITE MANAGER，它有一个从CSV导入数据的选项。

you can try the firefox addon "SQLITE MANAGER" wich has an option to import data from CSV.

FireFox的SQLITE Manager

这篇关于在iPhone上读取CSV文件到sqlite3中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！