Mysql - REPLACE (Select e Update)

Опубликовано: 21 Июль 2026
на канале: queissofera

317

Como utilizar o REPLACE no mysql
Exemplos com SELECT e com UPDATE
=-=-=-=-=-=-=-=-=-=-=-=-=-=-===
Recursos:
-- Usar os comandos mysql de forma online:
https://sqliteonline.com/
-- Descrição e explicação dos comandos:
https://www.1keydata.com/pt/sql/sql-r...

-- Script utilizado para criar e popular as tabelas:
CREATE TABLE Aluno(
matricula INTEGER PRIMARY KEY,
nome VARCHAR(50),
email VARCHAR(50),
telefone VARCHAR(13),
altura DECIMAL(3,2),
mensalidade DECIMAL(5,2),
bairro VARCHAR(40),
uf VARCHAR(2),
situacao VARCHAR(1));

insert into Aluno VALUES (2020100,'Ana Caroline','[email protected]','(21)988881234',1.65,820.15,'Madureira','RJ','A');
insert into Aluno VALUES (2020101,'Camille Carvalho','[email protected]','(21)988881235',1.62,820.15,'Méier','RJ','A');
insert into Aluno VALUES (2020102,'Gabriel Duarte','[email protected]','(21)998881234',1.72,820.15,'Madureira','RJ','A');
insert into Aluno VALUES (2020103,'Isabella Motta','[email protected]','(21)987881234',1.60,820.15,'Lins de Vasconcelos','RJ','A');
insert into Aluno VALUES (2020104,'Isabella Oliveira','[email protected]','(21)997881234',1.65,820.15,'Madureira','RJ','A');
insert into Aluno VALUES (2020105,'João Marcelo','[email protected]','(21)997681234',1.70,600.00,'Tijuca','RJ','T');
insert into Aluno VALUES (2020106,'Júlia Araújo','[email protected]','(21)997651234',1.68,600.00,'Lins de Vasconcelos','RJ','A');
insert into Aluno VALUES (2020107,'Júlia Stasinlesreins','[email protected]','(21)999651234',1.65,600.00,'Engenho Novo','RJ','A');
insert into Aluno VALUES (2020108,'Kaio Vinícius','[email protected]','(21)987651235',1.80,600.00,'Engenho de Dentro','RJ','A');
insert into Aluno VALUES (2020109,'Kamilly Lima','[email protected]','(21)917651244',1.72,600.00,'Todos os Santos','RJ','A');
insert into Aluno VALUES (2020110,'Larissa de Almeira','[email protected]','(21)917651224',1.70,600.00,'Lins de Vasconcelos','RJ','A');
insert into Aluno VALUES (2020111,'Letícia Oliveira','[email protected]','(21)927651224',1.60,600.00,'Maracanã','RJ','A');
insert into Aluno VALUES (2020112,'Lorenna Véo','[email protected]','(21)913651224',1.64,600.00,'Lins de Vasconcelos','RJ','A');
insert into Aluno VALUES (2020113,'Marco Antonio','[email protected]','(21)955651224',1.80,600.00,'Méier','RJ','T');
insert into Aluno VALUES (2020114,'Maria Eduarda','[email protected]','(21)998331224',1.68,600.00,'Madureira','RJ','T');
insert into Aluno VALUES (2020115,'Pedro Lucas','[email protected]','(21)933381235',1.72,820.15,'Maracanã','RJ','A');
insert into Aluno VALUES (2020116,'Raissa Lima','[email protected]','(21)977781235',1.62,820.15,'Cambuci','SP','T');
insert into Aluno VALUES (2020117,'Rayssa Ferreira','[email protected]','(21)955581235',1.60,820.15,'Liberdade','SP','A');
insert into Aluno VALUES (2020118,'Thiago Rosa','[email protected]','(21)997781235',1.82,820.15,'Bom Retiro','SP','A');
insert into Aluno VALUES (2020119,'Vivian Victória','[email protected]','(21)944441235',1.68,820.15,'Consolação','SP','A');
insert into Aluno VALUES (2020120,'Wesley Pulgueres','[email protected]','(21)928881234',1.82,820.15,'Liberdade','SP','T');