copy table with all content, database

gistfile1.txt

create table redlist_tmp select * from redlist_2015;

mysql> select * from redlist_2015 where id=102963;

+--------+----------------------------+------------+-------------------------------------------------+--------------------------------------+------------------+---------------+---------------+-------------+
| id     | latin                      | svenskt    | pdf_url                                         | web_url                              | status           | status_abbrev | status_eng    | status_swe  |
+--------+----------------------------+------------+-------------------------------------------------+--------------------------------------+------------------+---------------+---------------+-------------+
| 102963 | Chroicocephalus ridibundus | skrattmås  | //artfakta.artdatabanken.se/artfaktablad/102963 | ca32a96f-bd50-47cc-8faf-57ddde90d5b8 | Livskraftig (LC) | LC            | Least Concern | Livskraftig |
+--------+----------------------------+------------+-------------------------------------------------+--------------------------------------+------------------+---------------+---------------+-------------+
1 row in set (0,06 sec)

library(tidyverse)
library(glue)
redlist <- read.csv("rodlistade_arter_tampered_2.csv",header=TRUE);
dat <- select(redlist,'id', 'status_abbrev')

df2 <- redlist %>% 
  mutate(sql_string = glue("update redlist SET status_abbrev='{status_abbrev}' where id={id}"))

https://stackoverflow.com/questions/63044224/r-looping-through-a-dataframe-creating-a-new-one-with-additional-content/63113796#63113796