{"action":"created","issue":{"url":"https://api.github.com/repos/hadley/dplyr/issues/1694","repository_url":"https://api.github.com/repos/hadley/dplyr","labels_url":"https://api.github.com/repos/hadley/dplyr/issues/1694/labels{/name}","comments_url":"https://api.github.com/repos/hadley/dplyr/issues/1694/comments","events_url":"https://api.github.com/repos/hadley/dplyr/issues/1694/events","html_url":"https://github.com/hadley/dplyr/issues/1694","id":139338776,"number":1694,"title":"writing into MySQL DB using dplyr without pulling down data into R","user":{"login":"vsagar19","id":5356632,"avatar_url":"https://avatars.githubusercontent.com/u/5356632?v=3","gravatar_id":"","url":"https://api.github.com/users/vsagar19","html_url":"https://github.com/vsagar19","followers_url":"https://api.github.com/users/vsagar19/followers","following_url":"https://api.github.com/users/vsagar19/following{/other_user}","gists_url":"https://api.github.com/users/vsagar19/gists{/gist_id}","starred_url":"https://api.github.com/users/vsagar19/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vsagar19/subscriptions","organizations_url":"https://api.github.com/users/vsagar19/orgs","repos_url":"https://api.github.com/users/vsagar19/repos","events_url":"https://api.github.com/users/vsagar19/events{/privacy}","received_events_url":"https://api.github.com/users/vsagar19/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-08T17:19:53Z","updated_at":"2016-03-08T19:20:27Z","closed_at":"2016-03-08T19:20:26Z","body":"Hi,\r\nHow can I  write into DB after some data filtering and without pulling data into R. \r\nLet the table name to be written in database is xyz\r\n\r\n\r\n`conn= src_mysql(dbname = myDbname, host =  myHost,user = myUsername, password = myPassword, port = myPort)`\r\n`remote<-conn %>% `\r\n  `tbl(\"database_table_name\") %>%` \r\n  `select(everything()) %>%` \r\n  `filter(price >= '2000')`\r\n`cached<-compute(remote)`\r\n\r\nThanks in advance!!!\r\n \r\n`\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/hadley/dplyr/issues/comments/193928037","html_url":"https://github.com/hadley/dplyr/issues/1694#issuecomment-193928037","issue_url":"https://api.github.com/repos/hadley/dplyr/issues/1694","id":193928037,"user":{"login":"hadley","id":4196,"avatar_url":"https://avatars.githubusercontent.com/u/4196?v=3","gravatar_id":"","url":"https://api.github.com/users/hadley","html_url":"https://github.com/hadley","followers_url":"https://api.github.com/users/hadley/followers","following_url":"https://api.github.com/users/hadley/following{/other_user}","gists_url":"https://api.github.com/users/hadley/gists{/gist_id}","starred_url":"https://api.github.com/users/hadley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hadley/subscriptions","organizations_url":"https://api.github.com/users/hadley/orgs","repos_url":"https://api.github.com/users/hadley/repos","events_url":"https://api.github.com/users/hadley/events{/privacy}","received_events_url":"https://api.github.com/users/hadley/received_events","type":"User","site_admin":false},"created_at":"2016-03-08T19:20:26Z","updated_at":"2016-03-08T19:20:26Z","body":"`compute(remote, name = \"xyz\", temporary = FALSE)`"}}