[SQL] 테이블 생성하기(DROP DATABASES, CREATE DATABASE)

 

DROP DATABASE IF EXISTS pokemon;
CREATE DATABASE pokemon;
USE pokemon;
CREATE TABLE mypokemon(
number INT,
name VARCHAR(20)
type VARCHAR(10)
height FLOAT
weight FLOAT
);

INSERT INTO mypokemon(number, name, type, height, weight)
VALUES(10,'caterpie', 'bug', 0.3, 2.9)
(25, 'pikachu', electric, 0.4, 6) ;

번개표시 누르기
SELECT * FROM mypokemon;