Skip to content
←

Split View: MySQL SQL 기초(SELECT, INSERT, DELETE, UPDATE) 사용법

|

MySQL SQL 기초(SELECT, INSERT, DELETE, UPDATE) 사용법

Overview

MySQL에서 사용할 수 있는 SQL (SELECT, INSERT, DELETE, UPDATE) 사용법에 대해 알아본다.

Ubuntu MySQL 설치 방법

sudo apt install mysql-server
service mysql start
mysql -u root

데이터 베이스 확인

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

데이터 베이스 생성

mysql> create database my_database;
Query OK, 1 row affected (0.01 sec)

table 생성

mysql> CREATE TABLE person ( id INT NOT NULL AUTO_INCREMENT , name VARCHAR(20),
PRIMARY KEY(id) );

table schema 확인

mysql> show create table person\G
*************************** 1. row ***************************
       Table: person
Create Table: CREATE TABLE `person` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

row insert

row를 업데이트 하기 위해서는 INSERT INTO table_name, VALUES (value1, value2); 구문을 활용하면 된다.

mysql> INSERT INTO person VALUES (3,'abc');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM person;
+----+-------+
| id | name  |
+----+-------+
|  1 | NULL  |
|  2 | chaos |
|  3 | abc   |
+----+-------+
3 rows in set (0.00 sec)

update column

Column을 업데이트 하기 위해서 일반적으로 아래와 같은 구문을 이용한다. UPDATE table_name SET column_name=value WHERE condition;

mysql> select * FROM person;
+----+-------+
| id | name  |
+----+-------+
|  1 | NULL  |
|  2 | chaos |
|  3 | abc   |
+----+-------+
3 rows in set (0.00 sec)

mysql> UPDATE person SET name='def' WHERE id=3;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * FROM person;
+----+-------+
| id | name  |
+----+-------+
|  1 | NULL  |
|  2 | chaos |
|  3 | def   |
+----+-------+

MySQL SQL Basics (SELECT, INSERT, DELETE, UPDATE) Usage

Overview

Learn how to use SQL (SELECT, INSERT, DELETE, UPDATE) in MySQL.

How to Install MySQL on Ubuntu

sudo apt install mysql-server
service mysql start
mysql -u root

Checking Databases

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

Creating a Database

mysql> create database my_database;
Query OK, 1 row affected (0.01 sec)

Creating a Table

mysql> CREATE TABLE person ( id INT NOT NULL AUTO_INCREMENT , name VARCHAR(20),
PRIMARY KEY(id) );

Checking Table Schema

mysql> show create table person\G
*************************** 1. row ***************************
       Table: person
Create Table: CREATE TABLE `person` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Row Insert

To insert a row, use the INSERT INTO table_name, VALUES (value1, value2); syntax.

mysql> INSERT INTO person VALUES (3,'abc');
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM person;
+----+-------+
| id | name  |
+----+-------+
|  1 | NULL  |
|  2 | chaos |
|  3 | abc   |
+----+-------+
3 rows in set (0.00 sec)

Update Column

To update a column, the following syntax is generally used: UPDATE table_name SET column_name=value WHERE condition;

mysql> select * FROM person;
+----+-------+
| id | name  |
+----+-------+
|  1 | NULL  |
|  2 | chaos |
|  3 | abc   |
+----+-------+
3 rows in set (0.00 sec)

mysql> UPDATE person SET name='def' WHERE id=3;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * FROM person;
+----+-------+
| id | name  |
+----+-------+
|  1 | NULL  |
|  2 | chaos |
|  3 | def   |
+----+-------+

Quiz

Q1: What is the main topic covered in "MySQL SQL Basics (SELECT, INSERT, DELETE, UPDATE) Usage"?

Learn how to use SQL (SELECT, INSERT, DELETE, UPDATE) in MySQL.

Q2: What is Row Insert? To insert a row, use the INSERT INTO table_name, VALUES (value1, value2); syntax.

Q3: Explain the core concept of Update Column. To update a column, the following syntax is generally used: UPDATE table_name SET column_name= value WHERE condition;