MySQL Forums
Forum List  »  Portuguese

Re: Agrupar duas linhas de consulta em uma
Posted by: Gustavo Gustavo
Date: September 03, 2015 07:53AM

Sim, Marcelo, desculpe.

Aqui está a tabela servicosalao:

CREATE TABLE `salao`.`servicosalao` (
`codigo_servicosalao` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_salao` varchar(60) CHARACTER SET latin1 NOT NULL,
`preco_servicosalao` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
`tempo_servicosalao` int(10) unsigned DEFAULT NULL,
`descricao_servicosalao` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
`codigo_servico` int(10) unsigned NOT NULL,
PRIMARY KEY (`codigo_servicosalao`),
KEY `FK_servicosalao_1` (`email_salao`),
KEY `FK_servicosalao_2` (`codigo_servico`),
CONSTRAINT `FK_servicosalao_1` FOREIGN KEY (`email_salao`) REFERENCES `salao` (`email_salao`),
CONSTRAINT `FK_servicosalao_2` FOREIGN KEY (`codigo_servico`) REFERENCES `servico` (`codigo_servico`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_mysql500_ci;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Agrupar duas linhas de consulta em uma
1006
September 03, 2015 07:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.