How to concatenate parameters in windows batch

(%Major% =10, %MINOR%=5)

set “allBuild=%Major%%MINOR%”

echo %allBuild%

(you get “105”)

set “allBuild=%Major%.%MINOR%”

echo %allBuild%

(you get “10.5”)

 

 

Advertisements

How to copy rows, but change a few fields?

https://stackoverflow.com/questions/2783150/mysql-how-to-copy-rows-but-change-a-few-fields

 

example:

SELECT ID, NAME, PASSWORD, ENVIRONMENT
FROM tbl_USERS

 

INSERT INTO tbl_USERS
(ENVIRONMENT, NAME, PASSWORD)
SELECT ‘global’ , NAME, PASSWORD
FROM tbl_USERS AS tbl_USERS_1