Skip to content

Instantly share code, notes, and snippets.

@vinicius5581

vinicius5581/concessionaria.sql

Created April 26, 2020 03:23
Show Gist options
  • Save vinicius5581/2da5bc641a9a76536c76a8b6ee4b6f86 to your computer and use it in GitHub Desktop.
Save vinicius5581/2da5bc641a9a76536c76a8b6ee4b6f86 to your computer and use it in GitHub Desktop.
Download ZIP
Banco de dados simplificado de uma concessionaria de carros fictícia com fins únicos de servir de exemplo para o blog post sobre usando SQL com MySQL.
Raw
concessionaria.sql
DROP DATABASE IF EXISTS `concessionaria`;
CREATE DATABASE `concessionaria` ;
USE `concessionaria`;
CREATE TABLE `carros`(
`id_do_carro` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(50) NOT NULL,
`cor` varchar(50) NOT NULL,
`quantidade_em_estoque` int(11) NOT NULL,
`preco` decimal(8,2) NOT NULL,
PRIMARY KEY (`id_do_carro`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
INSERT INTO `carros` VALUES (1,'Ferrai', 'vermelho', 12, 250000.00);
INSERT INTO `carros` VALUES (2,'Monza', 'preto', 36, 60000.00);
INSERT INTO `carros` VALUES (3,'Fusca', 'vermelho', 9, 95000.00);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment