創(chuàng)建數(shù)據(jù)庫

CREATE DATABASE my_database;

創(chuàng)建表

CREATE TABLE products (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(255) NOT NULL,description VARCHAR(255),price DECIMAL(10, 2),stock_quantity INT NOT NULL DEFAULT 0,PRIMARY KEY (id)
);

插入數(shù)據(jù)

INSERT into products (name, description, price, stock_quantity)
VALUES('Apple iPhone 14', 'Powerful smartphone with advanced camera system', 999.99, 100),('Apple iPad Pro', 'Versatile tablet for work and play', 749.99, 50),('Apple MacBook Air', 'Lightweight and portable laptop', 999.99, 25),('Sony WH-1000XM4', 'Noise-canceling headphones', 349.99, 75),('Bose QuietComfort 35 II', 'Over-ear headphones with superior sound quality', 299.99, 50);

更新數(shù)據(jù)

UPDATE products SETprice = price  1.10
WHEREstock_quantity < 50;

刪除數(shù)據(jù)

DELETE FROM products
WHEREstock_quantity = 0;

查詢數(shù)據(jù)

SELECTFROMproducts
WHEREname LIKE '%Apple%';

管理數(shù)據(jù)庫

備份數(shù)據(jù)庫

mysqldump -u username-p password my_database > backup.sql

還原數(shù)據(jù)庫

mysql -u username -p password my_database < backup.sql

維護數(shù)據(jù)庫

優(yōu)化表

OPTIMIZE TABLE products;

修復(fù)表

REPAIR TABLE products;

分析表

ANALYZE TABLE products;

---

---

相關(guān)標簽： 使用Sql創(chuàng)建商品表1、 SQL、 管理和維護數(shù)據(jù)庫、 創(chuàng)建、 使用、

上一篇：從零開始JavaScript代碼下載指南從零開始建

下一篇：掌握SQL事務(wù)和并發(fā)控制sql掌握到什么程度