MYSQL get data from table and insert on new table with variable

Question

I need to take the value in a table to generate a URL containing this value and insert it in a new table. Is it possible to use variables within MySQL to form this URL?

Example:

SELECT `identity_id`, `email` FROM `identities` WHERE 1

Output: 1 [email protected]

With the ID and email in hand, I need to insert the HTML content below where the respective email for each ID says VARIABLE.

INSERT INTO `identities`(`html_signature`) VALUES ([<img src="https://example.com/images/VARIABLE.png" width="580" height="138">])

Thanks for help

MBeale · Accepted Answer · 2021-01-19 13:11:01Z

1

You can use the select into statement

INSERT INTO `identities` (`html_signatures`)
  SELECT CONCAT("<img src=\"https://example.com/images/", `email`, ".png\" width=\"580\" height=\"138\">") as html_signatures
  FROM `identities` WHERE 1

I'm not sure if VARIABLE represented the id, email, or both but you could change the concat function arguments as needed.

answered Jan 19, 2021 at 13:11

MBeale

7501 gold badge6 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marcelo Leães Over a year ago

Result: #1364 - Field 'user_id' doesn't have a default value

MBeale Over a year ago

Is that error from MySQL or somewhere else?

Collectives™ on Stack Overflow

MYSQL get data from table and insert on new table with variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related