> For the complete documentation index, see [llms.txt](https://redryan.gitbook.io/studyjoon/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://redryan.gitbook.io/studyjoon/hacking/undefined/sql-sql/sql-1.md).

# SQL 기본 문법과 활용

## 1. CREATE, DROP 구문

<figure><img src="https://287627346-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ysBTUxkIeOC7SqTEZ2L%2Fuploads%2FJ3bMUms4Z0lsNlrK84yJ%2Fimage.png?alt=media&amp;token=68669b60-0e80-4393-acbd-85e5744a200b" alt=""><figcaption></figcaption></figure>

* show databases;
* create databases example;
* use example;
* select database();
* create table member(seq int, name char(20), email char(50));
* show tables;
* desc member;

## 2. INSERT, SELECT, UPDATE, DELETE 구문

<figure><img src="https://287627346-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ysBTUxkIeOC7SqTEZ2L%2Fuploads%2FC4dBUPWHNSEBFUU5jhnX%2Fimage.png?alt=media&amp;token=09fc5f43-f292-4a27-aedb-997dce38cf9a" alt=""><figcaption></figcaption></figure>

<figure><img src="https://287627346-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ysBTUxkIeOC7SqTEZ2L%2Fuploads%2FV2Pisa1lL9A9zfDCWqMy%2Fimage.png?alt=media&amp;token=32a15a80-a836-4ae1-9b52-d801babdd310" alt=""><figcaption></figcaption></figure>

## 3. 연산

<figure><img src="https://287627346-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ysBTUxkIeOC7SqTEZ2L%2Fuploads%2FcVqXXCU3EDjsmkA7pX7U%2Fimage.png?alt=media&amp;token=7bf9d5e6-53ee-44d4-b07a-34a4768cd6de" alt=""><figcaption></figcaption></figure>
