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

Common HTTP Response Codes

Code: Description

  • 200 (OK): This response code is returned if the document or file in question is
    found and served correctly.
  • 304 (Not Modified): This response code is returned if a browser has indicated that it has
    a local, cached copy, and the server’s copy has not changed from
    this cached copy.
  • 401: (Unauthorized): This response code is generated if the request in question requires
    authorization to access the requested document.
  • 403 (Forbidden): This response code is returned if the requested document does not
    have proper permissions to be accessed by the requestor.
  • (404 Not Found): This response code is sent back if the file that is attempting to be
    accessed could not be found (e.g., if it doesn’t exist).
  • 500 (Internal Server Error): This code will be returned if the server that is being contacted has a
    problem.
  • 503 (Service Unavailable): This response code is generated if the server is too overwhelmed to
    handle the request.

Case sensitive search in SQL

Hi,

By default SQL query is case-insensitive, so if I query for ‘Finish’ I get both ‘Finish’ and ‘finish’ (and it could also include ‘FINISH’, ‘fiNish’ and so on).

In order to get only the case you wand use:

WHERE <field_name> COLLATE Latin1_General_CS_AS = ‘Finish’)