创建数据库,创建表:创建->表
导入数据:外部数据->新数据源, 从文件,导入csv数据,高级设置里可以设置编码格式
汇总:方差,标准差,计数,最大值最小值平均值——开始->合计
简单查询:
1,创建,查询向导
2,创建,查询设计
基本查询语句:
#选择所有数据
SELECT *
FROM table_name;
#选择不同的数据
SELECT DISTINCT column_name,column_name
FROM table_name;
#过滤
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
-where country='cn' #单引号环绕文本值
-where id>50 #数值
-where oid is null #查询空值
-where did between 1500 and 3000
-where oid>50 and did>20
-where oid>50 or did>20
#排序
SELECT column_name,column_name
FROM table_name
ORDER BY column_name,column_name ASC|DESC;
#插入数据
INSERT INTO table_name
VALUES (value1,value2,value3,...);
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
#更新
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
#删除
DELETE FROM table_name
WHERE some_column=some_value;