quotes

How to run an EXE file in PowerShell with parameters with spaces and quotes

by

How do you run the following command in PowerShell? C:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe -verb:sync -source:dbfullsql=”Data Source=mysource;Integrated Security=false;User ID=sa;Pwd=sapass!;Database=mydb;” -dest:dbfullsql=”Data Source=.\mydestsource;Integrated Security=false;User ID=sa;Pwd=sapass!;Database=mydb;”,computername=10.10.10.10,username=administrator,password=adminpass” 21 Answers 21

Expansion of variables inside single quotes in a command in Bash

by

I want to run a command from a bash script which has single quotes and some other commands inside the single quotes and a variable. e.g. repo forall -c ‘….$variable’ In this format, $ is escaped and the variable is not expanded. I tried the following variations but they were rejected: repo forall -c ‘….”$variable” … Read more

Insert text with single quotes in PostgreSQL

by

I have a table test(id,name). I need to insert values like: user’s log, ‘my user’, customer’s. insert into test values (1,’user’s log’); insert into test values (2,”my users”); insert into test values (3,’customer’s’); I am getting an error if I run any of the above statements. If there is any method to do this correctly … Read more

When to use single quotes, double quotes, and backticks in MySQL

by

I am trying to learn the best way to write queries. I also understand the importance of being consistent. Until now, I have randomly used single quotes, double quotes, and backticks without any real thought. Example: $query = ‘INSERT INTO table (id, col1, col2) VALUES (NULL, val1, val2)’; Also, in the above example, consider that … Read more