oceanbase的增删改查sql字段的语句事例

OceanBase是一款分布式数据库系统，其SQL语法与标准的MySQL类似，用于在集群上执行数据操作。以下是基本的增删改查操作的一些示例：

1. **插入数据 (INSERT)**:

INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3);

例如：

INSERT INTO employees (id, name, position) VALUES (101, '张三', '经理');

2. **删除数据 (DELETE)**:

DELETE FROM table_name WHERE condition;

例如：

DELETE FROM employees WHERE id = 101;

3. **更新数据 (UPDATE)**:

UPDATE table_name SET column1 = new_value WHERE condition;

例如：

UPDATE employees SET salary = 8000 WHERE id = 101;

4. **查询数据 (SELECT)**:

SELECT * FROM table_name [WHERE condition] [ORDER BY column];

例如：

SELECT * FROM employees WHERE department = '销售部';

或者按姓名排序：

SELECT * FROM employees ORDER BY name ASC;