将数据帧写入MySql DB表 [英] Writing the data frame to MySql DB table

问题描述

如何将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.com 221501398 2c10b368ae23ba3        questions#instant_answers
2012-08-22 14:58:23 foo.com 221501398 22c10b368ae23                      questions#new
2012-08-22 14:58:23 foo.com 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

这篇关于将数据帧写入MySql DB表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！