SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table CLIENTES ( endereco varchar(64), logradouro varchar(64), numero varchar(64), complemento varchar(64) ); insert into CLIENTES (endereco) values ('Rua do Whisky, 1292 - sala 14'), ('Travessa Costa Teles, 672 - Apto 591'); UPDATE CLIENTES SET logradouro = SUBSTRING_INDEX(endereco,',', 1), numero = SUBSTRING_INDEX( SUBSTRING_INDEX(endereco,'-', 2), '-', -1), complemento = SUBSTRING_INDEX(endereco,'-', -1); select * from CLIENTES;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear