Skip to content

데이터베이스 삭제하기 #146

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
chung0906 opened this issue Jan 15, 2018 · 2 comments
Closed

데이터베이스 삭제하기 #146

chung0906 opened this issue Jan 15, 2018 · 2 comments

Comments

@chung0906
Copy link

REATE DATABASE opentutorials CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE topic (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(100) NOT NULL,
description text NOT NULL,
author varchar(30) NOT NULL,
created datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

데이터베이스 강의 내용에 따라 프로토콜에서

데이터 베이스를 만들었는데요 데이터베이스를 삭제할려면 어떻게 해야 하나요?

@dhchoi82
Copy link

https://opentutorials.org/module/98/1404
위 강의를 보면 DROP DATABASE `opentutorials`;로 삭제 가능할 듯 합니다.

@ghdalsrldi
Copy link
Collaborator

# 데이터베이스 삭제
DROP DATABASE `opentutorials`;

# 테이블 삭제
DROP TABLE `topic`;

입니다

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants