mysql图书表的数据操作
时间: 2023-07-26 09:44:47 浏览: 131
可以使用以下 SQL 语句对 MySQL 数据库中的图书表进行数据操作:
1. 创建图书表:
```
CREATE TABLE books (
book_id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
author VARCHAR(255) NOT NULL,
price DECIMAL(10, 2) NOT NULL,
publish_date DATE NOT NULL
);
```
2. 插入数据:
```
INSERT INTO books (title, author, price, publish_date)
VALUES ('The Great Gatsby', 'F. Scott Fitzgerald', 12.99, '1925-04-10');
INSERT INTO books (title, author, price, publish_date)
VALUES ('To Kill a Mockingbird', 'Harper Lee', 10.99, '1960-07-11');
INSERT INTO books (title, author, price, publish_date)
VALUES ('1984', 'George Orwell', 9.99, '1949-06-08');
```
3. 查询数据:
```
SELECT * FROM books;
```
4. 更新数据:
```
UPDATE books
SET price = 14.99
WHERE book_id = 1;
```
5. 删除数据:
```
DELETE FROM books
WHERE book_id = 3;
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)