웹보안 기초(01)

student@security:~/바탕화면$ sudo mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.35-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 

데이터베이스 생성

mysql> create database test;
Query OK, 1 row affected (0.00 sec)

mysql> use test;
Database changed
mysql> create table test_table(no int, name varchar(200));
Query OK, 0 rows affected (0.01 sec)

mysql> desc test_table;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| no    | int          | YES  |     | NULL    |       |
| name  | varchar(200) | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

 

테이블에 값 입력하기

mysql> insert into test_table(no, name) values(1, 'test');
Query OK, 1 row affected (0.00 sec)

mysql> insert into test_table(no, name) values(2, 'test2');
Query OK, 1 row affected (0.00 sec)

mysql> insert into test_table(no, name) values(3, 'test3');
Query OK, 1 row affected (0.00 sec)

mysql> select no from test_table;
+------+
| no   |
+------+
|    1 |
|    2 |
|    3 |
+------+
3 rows in set (0.00 sec)

mysql> select no, name from test_table;
+------+-------+
| no   | name  |
+------+-------+
|    1 | test  |
|    2 | test2 |
|    3 | test3 |
+------+-------+
3 rows in set (0.00 sec)

 

mysql> select * from test_table;
+------+-------+
| no   | name  |
+------+-------+
|    1 | test  |
|    2 | test2 |
|    3 | test3 |
+------+-------+
3 rows in set (0.00 sec)

mysql> select * from test_table where no=2;
+------+-------+
| no   | name  |
+------+-------+
|    2 | test2 |
+------+-------+
1 row in set (0.00 sec)

 

mysql> select * from test_table where no=1 and name='test';
+------+------+
| no   | name |
+------+------+
|    1 | test |
+------+------+
1 row in set (0.00 sec)

mysql> select * from test_table where no=1 or name='test2';
+------+-------+
| no   | name  |
+------+-------+
|    1 | test  |
|    2 | test2 |
+------+-------+
2 rows in set (0.00 sec)

 

mysql> select * from test_table where name like 't%';
+------+-------+
| no   | name  |
+------+-------+
|    1 | test  |
|    2 | test2 |
|    3 | test3 |
+------+-------+
3 rows in set (0.00 sec)

mysql> select * from test_table where name like '%2';
+------+-------+
| no   | name  |
+------+-------+
|    2 | test2 |
+------+-------+
1 row in set (0.00 sec)

mysql> select * from test_table where name like '%es%';
+------+-------+
| no   | name  |
+------+-------+
|    1 | test  |
|    2 | test2 |
|    3 | test3 |
+------+-------+
3 rows in set (0.00 sec)

 

mysql> select * from test_table where name like 't_';
Empty set (0.00 sec)

mysql> select * from test_table where name like 't___';
+------+------+
| no   | name |
+------+------+
|    1 | test |
+------+------+
1 row in set (0.00 sec)

 

mysql> delete from test_table where no=1;
Query OK, 1 row affected (0.01 sec)

mysql> select * from test_table;
+------+-------+
| no   | name  |
+------+-------+
|    2 | test2 |
|    3 | test3 |
+------+-------+
2 rows in set (0.00 sec)

 

mysql> update test_table set name='change' where no=3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from test_table;
+------+--------+
| no   | name   |
+------+--------+
|    2 | test2  |
|    3 | change |
+------+--------+
2 rows in set (0.00 sec)

 

mysql> drop table test_table;
Query OK, 0 rows affected (0.01 sec)

mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)