将数据帧写入MySql DB表

本文介绍了将数据帧写入MySql DB表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何将R中的数据帧写入MySQL?

How to write the data frame in R into MySQL?

dateTime host authId sessionId status action 2012-08-22 14:58:23 foo 221501398 2c10b368ae23ba3 questions#instant_answers 2012-08-22 14:58:23 foo 221501398 22c10b368ae23 questions#new 2012-08-22 14:58:23 foo 221501398 01a36f64bd3f80c sessions#new

我想一次将所有数据帧写入MySQL DB表. 我已经使用RMySql包进行连接并建立连接.

I want to write the dataframe all at once to the MySQL DB table. I have used RMySql package to connect and establish the connection.

谢谢

推荐答案

使用dbWriteTable函数.看起来像这样:

Use the dbWriteTable function. It looks like this :

dbWriteTable(connection, value = data.frame, name = "MyTable", append = TRUE )

该功能有据可查.

P.S 还要看: 带有field.types的RMySQL dbWriteTable

P.S Also look at: RMySQL dbWriteTable with field.types