SQL Commands

A list with some of the SQL commands I want to remember.

Search and replace in field of a SQL table:
* UPDATE table SET field = REPLACE(field,’oldstring‘, ‘finalstring‘);

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.