Ubuntu上安装Mysql

Ubuntu上安装Mysql

sudo apt-get update
sudo apt-get install mysql-server
//设置用户的密码
sudo apt-get isntall mysql-client
sudo apt-get install libmysqlclient-dev
//检查是否安装成功
sudo netstat -tap | grep mysql
//输出如下
//tcp    0   0 localhost:mysql     *:*    LISTEN    11827/mysqld 

2、对于导入csv文件；

ERROR1148(42000）---
解决办法：
登陆时候加上

mysql --local-infile -u root -p

显示表格属性:desc

desc ex_tb;

show full columns from ex_tb;

---

3、导入数据：
导入前，新建表格

CREATE TABLE IF NOT EXISTS lin_01( 
id INT, 
W1112 VARCHAR(100), 
W1 VARCHAR(100), 
W3 DATETIME,
CPU FLOAT,
TTL FLOAT,
CZRLLYL FLOAT,
LL FLOAT, 
JLCZS FLOAT, 
PRIMARY KEY(id));

//导入表格
>>LOAD DATA LOCAL INFILE 'csv文件路径' 
INTO TABLE lin_01 
CHARACTER SET  utf8 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

---

常用sql语句关键词

Select

SELECT “栏位” FROM “表格名”;

Distinct

SELECT DISTINCT “栏位”
FROM “表格名”;

Where 单一条件的查询时候

SELECT “栏位”
FROM “表格名”
WHERE “条件”;

And/Or 多个条件的时候

SELECT “栏位”
FROM “表格名”
WHERE “简单条件”
{[AND|OR] “简单条件”}+;

In

SELECT “栏位”
FROM “表格名”
WHERE “栏位” IN (‘值1’, ‘值2’, …);

Between 选择某个栏位的某个范围内的值输出

SELECT “栏位”
FROM “表格名”
WHERE “栏位” BETWEEN ‘值1’ AND ‘值2’;

Like

SELECT “栏位”
FROM “表格名”
WHERE “栏位” LIKE {模式};

Order By 按照某个栏目进行排序（升/降），栏目可以有多个，先看第一个，再看第二个

SELECT “栏位”
FROM “表格名”
[WHERE “条件”]
ORDER BY “栏位” [ASC, DESC];

Count 对某个栏目进行计数，求出有多少项

SELECT COUNT(“栏位”)
FROM “表格名”;

Group By

SELECT “栏位1”, SUM(“栏位2”)
FROM “表格名”
GROUP BY “栏位1”;

Having

SELECT “栏位1”, SUM(“栏位2”)
FROM “表格名”
GROUP BY “栏位1”
HAVING (栏位);

Create Table 新建一个表格

CREATE TABLE “表格名”
(“栏位 1” “栏位 1 资料种类”,
“栏位 2” “栏位 2 资料种类”,
… );

Drop Table 直接删除掉一个表格

DROP TABLE “表格名”;

Truncate Table 将一个表格里面的内容删除，表格本身没有删除

TRUNCATE TABLE “表格名”;

Insert Into 插入值，可以重一个表中选择出来插入另外一个表中

INSERT INTO “表格名” (“栏位1”, “栏位2”, …)
VALUES (“值1”, “值2”, …);

Update 更新满足某个条件的

UPDATE “表格名”
SET “栏位1” = [新值]
WHERE “条件”;

Delete From 删除满足某个条件的

DELETE FROM “表格名”
WHERE “条件”;