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
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.