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

Advertisements

Run c# program In Jenkins, cannot save Excel files

Usually get this error:

System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot open or save any more documents

After SaveAs method

 

to solve this problem do this works:

  1. Create directory “C:\Windows\SysWOW64\config\systemprofile\Desktop ” (for 64 bit Windows) or “C:\Windows\System32\config\systemprofile\Desktop ” (for 32 bit Windows)
  2. Set Full control permissions for directory Desktop (for example in Win7 & IIS 7 & DefaultAppPool set permissions for user
    “IIS AppPool\DefaultAppPool”

 

See here foe more details: