SQL(Structured Query Language)是用于管理关系型数据库的语言。以下是SQL的基本操作:
SELECT语句:用于从数据库中检索数据。语法如下:
SELECT column1, column2, ... FROM table_name WHERE condition;
示例:
SELECT * FROM customers WHERE country='USA';
INSERT语句:用于向数据库表中插入新数据。语法如下:
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
示例:
INSERT INTO customers (name, email, country) VALUES ('John Doe', 'john.doe@example.com', 'USA');
UPDATE语句:用于更新数据库表中的数据。语法如下:
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
示例:
UPDATE customers SET country='Canada' WHERE customer_id=1;
DELETE语句:用于从数据库表中删除数据。语法如下:
DELETE FROM table_name WHERE condition;
示例:
DELETE FROM customers WHERE customer_id=1;
CREATE语句:用于创建新的数据库表。语法如下:
CREATE TABLE table_name (
column1 datatype constrain,
column2 datatype constraint,
...
);
示例:
CREATE TABLE customers (
customer_id INT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(100),
country VARCHAR(50)
);
这些是SQL语言的基本操作,你可以通过这些操作对关系型数据库进行增删改查等操作。
,