K
K
Kamel2021-03-11 17:38:15
SQL
Kamel, 2021-03-11 17:38:15

Why does the table change places when importing data from a csv file?

I have a small database with 3 tables. A student project, the essence of which is that after parsing a post, there are 3 csv files: in the 1st URL of the post and the author's Id, his username, etc., in the 2nd comment under the post, the Id of comments, if there are branches, then ParentId and ReplyId of comments with the content of comments, in the 3rd file just Username and UseId. When importing a csv file into the database into the Comments table, the content is incorrectly determined, as a result of which the Content column is UserId, and the UserId column is Content. What could be the problem?
604a2af85dfad780710215.jpeg

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question