0

I have file my_request_result.sql which contains data (a lot of rows) exported from SQL phpmyadmin interface. The file contains only one table.

Now I want to read this data in R. Which libraries and commandands should I use to import data frame from this file.

I found out that .sql file extention is used also to save SQL queries like "SELECT * FROM ". My file contains real data not queries.

Improve this question
3
  • 1
    Posssible duplicate : stackoverflow.com/questions/36738301/… Commented Aug 8, 2019 at 8:13
  • How does "my_request_result.sql" file look like? Could you add couple of example rows? Commented Aug 8, 2019 at 8:19
  • After reading the link provided of @Rohit I decided that export from SQL server to .csv files and than import it to R is the best way. Alternatively, one should use direct access to SQL server and query database Commented Aug 8, 2019 at 9:19
Related questions
0
import .sql file into database found on a server
4
Import .db file into R
5
How do I get SQL database into R from local host?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.