Run Code
|
Code Wall
|
Users
|
Misc
|
Feedback
|
About
|
Login
|
Theme
|
Privacy
replace text
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Editor:
CodeMirror
EditArea
Simple
Layout:
Vertical
Horizontal
drop table if exists t1,t2 cascade; create table t1 (id serial primary key, txt text); insert into t1 (txt) values ('str1'), ('str2'), ('str3'); create table t2 (oldtxt text primary key, newtxt text); insert into t2 values ('str2', 'new str2'), ('str3', 'new str3'); update t1 set txt = t2.newtxt from t2 where t2.oldtxt = t1.txt; select * from t1;
absolute service time: 0,51 sec
edit mode
|
history
id
txt
1
1
str1
2
2
new str2
3
3
new str3