Wiki - Mysql

Category about Mysql

Simple Operations

Delete Database SQL Entries [Delete From]

Delete with Condition: DELETE FROM tablename WHERE a = 1; Delete all entries in a table: DELETE FROM tablename; ...


How to replace String in Text with SQL

Here is an example how to replace for example the string "https://test.de/testthis/" with "https://newlink.de/testthis/". The code is: UPDATE tablenamehere SET columnname = REPLACE(columnname , 'test.de', 'newlink.de'); ...

A39 | H38
This Website is using Session Cookies for Site Functionality and AWStats.