数据的基本操作

最新推荐文章于 2023-01-17 21:51:49 发布

yandao

最新推荐文章于 2023-01-17 21:51:49 发布

阅读量177

点赞数

文章标签： mysql 数据库 php

本文链接：https://blog.csdn.net/yandao/article/details/125130257

版权

查看数据库

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