CRUD
- Create / Read / Update / Delete
DDL
DML
조회
SHOW DATABASES;
SHOW TABLES;
SHOW TABLES LIKE 'ar%'
DESC article;
SELECT id, regDate
FROM article
WHERE id >= 4
AND title LIKE '제%'
ORDER BY id DESC
LIMIT 3;
생성
CREATE DATABASE `new_database`;
CREATE TABLE article (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
regDate DATETIME NOT NULL,
title VARCHAR(100) NOT NULL,
body TEXT NOT NULL,
PRIMARY KEY(id)
);
INSERT INTO article
SET regDate = NOW(),
title = '제목1',
body = '내용1';
수정
ALTER TABLE table_name1 RENAME table_name2;
ALTER TABLE article ADD PRIMARY KEY(id);
ALTER TABLE article ADD COLUMN hit INT(10);
ALTER TABLE article ADD COLUMN hit INT(10) FIRST;
ALTER TABLE article MODIFY COLUMN hit INT(10) UNSIGNED NOT NULL;
ALTER TABLE article MODIFY COLUMN hit INT(10) UNSIGNED NOT NULL UNIQUE;
ALTER TABLE article DROP CONSTRAINT hit
ALTER TABLE article CHANGE COLUMN hit hitNumber INT(10) UNSIGNED NOT NULL;
ALTER TABLE article DROP COLUMN hit;
ALTER TABLE article DROP INDEX `PRIMARY`;
UPDATE article SET title = '인기글' WHERE id > 3;
삭제
DROP DATABASE `a1`
DROP DATABASE IF EXISTS `a1`;
DROP TABLE `article`;
DELETE FROM `article`;
정리
- 제약사항 넣는 것을 추천
- 중복 금지
- 숫자만/음수/양수만
- 문지만/
- 공백 제외/
CREATE database
DROP database
CREATE table
DROP table
ALTER table
SELECT colume_name FROM table_name ;
INSERT INTO table SET colume_name = 'texts';
UPDATE table SET colume_name = 'texts';
DELETE TABLE `table_name`;