Inserting HTML (with inline styling) to MySQL via command line

Question

I'm trying to automate a Magento site build and one of the challenges I'm having is updating the content of a page in the database through a command. When trying to do:

mysql -D magento -e "INSERT INTO cms_page ('content') VALUES ("<p style="text-align: center;"><a href="http://www.magentocommerce.com/knowledge-base"><img src="{{media url=&quot;36d3c9416834b86ba9a78b92d97325f556a2f32f.png&quot;}}" alt="" width="1200" height="630"></a></p>");"

I'm receiving this error:

-bash: syntax error near unexpected token `<'

I'm by no means a DBA, but I have a feeling the issue is that I'm not properly escaping the double quotes, or that it's running into the terminating ';' in the middle of the HTML and failing.

Any help would be appreciated.

nbk · Accepted Answer · 2020-08-23 22:59:54Z

1

You have to escape the double quote with \ them when you using them to mark the string start and end

mysql -D magento -e "INSERT INTO cms_page ('content') VALUES (\"<p style=\"text-align: center;\"><a href=\"http://www.magentocommerce.com/knowledge-base\"><img src=\"{{media url=&quot;36d3c9416834b86ba9a78b92d97325f556a2f32f.png&quot;}}\" alt=\"\" width=\"1200\" height=\"630\"></a></p>");"

edited Aug 23, 2020 at 22:59

answered Aug 22, 2020 at 1:43

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

1 Comment

bsander Over a year ago

Thank you, that was it!

Collectives™ on Stack Overflow

Inserting HTML (with inline styling) to MySQL via command line

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related