1216 mariaDB

DATABASES 확인

SHOW DATABASES;

 

DATABASE 생성

CREATE DATABASE db1216;

 

DATABASE 사용

USE db1216;

 

TABLE생성

CREATE TABLE notice(
notice_id INT PRIMARY KEY AUTO_INCREMENT
, title VARCHAR(100)
, writer VARCHAR(20)
, content TEXT
, regdate TIMESTAMP DEFAULT NOW()
, hit INT DEFAULT 0
) DEFAULT CHARACTER SET UTF8;