mysql sam和db_Mysql

mysql> show variables like 'wait_timeout'; #查询连接超时

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| wait_timeout | 28800 |

+---------------+-------+

1 row in set (0.00 sec)

mysql> show processlist;# 查询连接表

+----+------+-----------+------+---------+------+----------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+----+------+-----------+------+---------+------+----------+------------------+

| 7 | root | localhost | NULL | Sleep | 2140 | | NULL |

| 9 | root | localhost | NULL | Sleep | 773 | | NULL |

| 10 | root | localhost | NULL | Query | 0 | starting | show processlist |

+----+------+-----------+------+---------+------+----------+------------------+

3 rows in set (0.00 sec)

mysql> show variables like 'query_cache_type'; # 查询缓存

+------------------+-------+

| Variable_name | Value |

+------------------+-------+

| query_cache_type | OFF |

+------------------+-------+

1 row in set (0.00 sec)

— 语法基础

mysql> create database `create_news`;# 创建数据库

Query OK, 1 row affected (0.00 sec)

mysql> use `create_news `;# 进入数据库

Database changed

mysql> show databases;# 查询数据库

+--------------------+

| Database |

+--------------------+

| information_schema |

| create_news |

| mysql |

| performance_schema |

| sys |

+--------------------+

5 rows in set (0.00 sec)

mysql> use create_news;# 进入数据库

Database changed

mysql> show tables;# 显示所有表

+-----------------------+

| Tables_in_create_news |

+-----------------------+

| news |

| news01 |

| news02 |

+-----------------------+

3 rows in set (0.00 sec)

mysql> desc news;# 显示表所有字段信息

+------------+---------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+------------+---------------+------+-----+---------+----------------+

| id | int(11) | NO | PRI | NULL | auto_increment |

| title | varchar(200) | NO | | NULL | |

| content | varchar(2000) | NO | | NULL | |

| created_at | datetime | YES | | NULL | |

| types | varchar(10) | NO | | NULL | |

| images | varchar(300) | NO | | NULL | |

| autors | varchar(20) | NO | | NULL | |

| view_count | int(11) | YES | | 0 | |

| is_valid | smallint(6) | YES | | 1 | |

+------------+---------------+------+-----+---------+----------------+

9 rows in set (0.00 sec)

# 添加数据。语法 INSERT INTO table_name(字段) VALUES(值) (ps NOW()表示当前创建时间)

mysql> INSERT INTO news (

-> title,content,created_at,types,images,autors)

-> VALUES(

-> '天天Python','我要学习',NOW(),'新闻','not photo','lianwu');

Query OK, 1 row affected (0.00 sec)

# 查询数据。 语法 SELECT * form table_name WHERE 添加。 (ps *表示所有字段 WHERE条件不设置表示显示所有信息列表)

mysql> SELECT * from news WHERE id >20;

+----+--------------+--------------+---------------------+--------+-----------+--------+------------+----------+

| id | title | content | created_at | types | images | autors | view_count | is_valid |

+----+--------------+--------------+---------------------+--------+-----------+--------+------------+----------+

| 29 | 天天Python | 我要学习 | 2020-08-23 20:59:39 | 新闻 | not photo | lianwu | 0 | 1 |

| 30 | 天天Python | 我要学习 | 2020-08-23 21:00:00 | 新闻 | not photo | lianwu | 0 | 1 |

+----+--------------+--------------+---------------------+--------+-----------+--------+------------+----------+

2 rows in set (0.00 sec)