'Skipping same entries in different rows of a column in SQL table

for example I have created a dataframe in R named as "Numbers" which has following output:

Numbers
1
2
3
2
4
1

When I tried to insert this dataframe in SQL table having column named as "Numbers" , it has given me the output:

 title<- sqlQuery(conn,paste0("INSERT INTO my_table(Numbers) VALUES('",Numbers, "')")) 

Numbers
1
2
3
4

That's mean SQL insert function is skipping the same entries while inserting into different rows of same column. But I want to insert all entries without skipping any repeated entry.

sqlrdataframerodbc


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions