Banco de dados II
Novo teste em aula
SGBD :: MySql
: https://www.mysql.com/
SGBD :: MySql 8.0 Reference Manual
: https://dev.mysql.com/doc/refman/8.0/en/
XAMPP
: https://www.apachefriends.org/pt_br/index.html
Workbench
: https://www.mysql.com/products/workbench/
Data types
: https://dev.mysql.com/doc/refman/8.0/en/data-types.html
- CREATE DATABASE
- DROP DATABASE
- USE
- CREATE TABLE
- RENAME
- DROP TABLE
- TRUNCATE TABLE
- AUTO_INCREMENT
- ALTER TABLE
- ADD
- ALTER
- DROP
- MODIFY / CHANGE
- SHOW COLUMNS FROM
- RETRIÇÕES - CONSTRAINT
- VISÃO GERAL
- NOT NULL
- UNIQUE
- PRIMARY KEY - CHAVE PRIMÁRIA
- FOREIGN KEY - CHAVE ESTRANGEIRA
- CHECK
- DEFAULT
- INDEX
- NORMALIZAÇÃO