SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE t ( weight varchar(32) ); insert into t values ('100г'), ('200 г'), ('300гр'), ('400 гр'), ('500г.'); SELECT * FROM t; SELECT CONCAT((weight + 0), ' г') FROM t; update t set weight = CONCAT((weight + 0), ' г'), ; SELECT * FROM t;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear