查看数据库
show databases;
创建数据库
mysql> CREATE DATABASE STU;
Query OK, 1 row affected
使用数据库
mysql> use stu;
Database changed
删除数据库
drop database STU;
创建数据库表
CREATE TABLE IF NOT EXISTS `runoob_tbl`(
`runoob_id` INT UNSIGNED AUTO_INCREMENT,
`runoob_title` VARCHAR(100) NOT NULL,
`runoob_author` VARCHAR(40) NOT NULL,
`submission_date` DATE,
PRIMARY KEY ( `runoob_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
表中增加数据
mysql> INSERT INTO runoob_tbl
(runoob_title, runoob_author, submission_date)
VALUES
("学习 PHP", "菜鸟教程", NOW());
Query OK, 1 row affected
mysql> INSERT INTO runoob_tbl
(runoob_title, runoob_author, submission_date)
VALUES
("学习 MySQL", "菜鸟教程", NOW());
Query OK, 1 row affected
mysql> INSERT INTO runoob_tbl
(runoob_title, runoob_author, submission_date)
VALUES
("JAVA 教程", "RUNOOB.COM", '2016-05-06');
Query OK, 1 row affected
查询
mysql> select * from runoob_tbl;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
| 3 | JAVA 教程 | RUNOOB.COM | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
3 rows in set
mysql> select runoob_title from runoob_tbl;
+--------------+
| runoob_title |
+--------------+
| 学习 PHP |
| 学习 MySQL |
| JAVA 教程 |
+--------------+
3 rows in set
mysql> select runoob_title,runoob_author from runoob_tbl;
+--------------+---------------+
| runoob_title | runoob_author |
+--------------+---------------+
| 学习 PHP | 菜鸟教程 |
| 学习 MySQL | 菜鸟教程 |
| JAVA 教程 | RUNOOB.COM |
+--------------+---------------+
3 rows in set
更新
mysql> UPDATE runoob_tbl SET runoob_title='学习 C++' WHERE runoob_id=3;
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
mysql>
mysql>
mysql> select * from runoob_tbl;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
| 3 | 学习 C++ | RUNOOB.COM | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
3 rows in set
mysql> UPDATE runoob_tbl SET runoob_title='学习 Java++' , runoob_author="abc" WHERE runoob_id=3;
Query OK, 1 row affected
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
mysql>
mysql>
mysql> select * from runoob_tbl;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
| 3 | 学习 Java++ | abc | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
3 rows in set
删除
mysql> select * from runoob_tbl;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
| 3 | 学习 Java++ | abc | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
3 rows in set
mysql>
mysql>
mysql>
mysql> delete from runoob_tbl where runoob_id=3;
Query OK, 1 row affected
mysql>
mysql>
mysql>
mysql> select * from runoob_tbl;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
+-----------+--------------+---------------+-----------------+
2 rows in set
TEST
mysql> select * from runoob_tbl;
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
| 4 | JAVA 教程 | RUNOOB.COM | 2016-05-06 |
+-----------+--------------+---------------+-----------------+
3 rows in set
mysql>
mysql> select * from runoob_tbl where runoob_author='菜鸟教程';
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 PHP | 菜鸟教程 | 2022-06-05 |
| 2 | 学习 MySQL | 菜鸟教程 | 2022-06-05 |
+-----------+--------------+---------------+-----------------+
2 rows in set
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。
文章由极客之音整理,本文链接:https://www.bmabk.com/index.php/post/140760.html