【项目笔记】基于百度地图的设备监控系统（服务端数据库）

最新推荐文章于 2024-07-20 08:12:21 发布

TAO_GIS

最新推荐文章于 2024-07-20 08:12:21 发布

阅读量899

点赞数

本文链接：https://blog.csdn.net/TAO_GIS/article/details/80356409

版权

MYSQL 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

Project notes

1 篇文章 0 订阅

订阅专栏

项目URL:http://www.1cloud.xyz/

LOAD DATA LOCAL INFILE '/www/wwwroot/www.1cloud.xyz/led_nanan - 副本1.csv' 
INTO TABLE led_nanan1
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
(`led_nanan_phone1`, `dtu`,`led_nanan_place`, `led_nanan_person`, `led_nanan_phone2`, `led_nanan_lat`,`led_nanan_lon`, `led_nanan_zhen`);

//本地为 C:\\Users\\Administrator\\Desktop\\led_nanan - 副本1.csv

LOAD DATA LOCAL INFILE '/www/wwwroot/www.1cloud.xyz/led_fuwu - 副本.csv' 
INTO TABLE led_fuwu1
CHARACTER SET utf8 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
(`dtu`, `state`);

创建表格：

 CREATE TABLE led_fuwu1(
dtu VARCHAR(40) NOT NULL ,
state VARCHAR(20) NOT NULL ,
PRIMARY KEY (dtu)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE led_nanan1(
led_nanan_phone1 VARCHAR(40) NOT NULL,
dtu VARCHAR(40) NOT NULL ,
led_nanan_place VARCHAR(100) NOT NULL,
led_nanan_person VARCHAR(100) NOT NULL,
led_nanan_phone2 VARCHAR(40) NOT NULL,
led_nanan_lat VARCHAR(40) NOT NULL,
led_nanan_lon VARCHAR(40) NOT NULL,
led_nanan_zhen VARCHAR(40) NOT NULL,
PRIMARY KEY (dtu)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

显示数据库可用编码:

SHOW CHARSET;

删除表格：

DROP TABLE led_nanan1;

显示表格：

select * from led_fuwu1;

select * from led_nanan1;

显示编码：

show variables like 'character%'；

设定编码:

set character_set_client = 'utf8'; 

set character_set_connection = 'utf8'; 

set character_set_results= 'utf8'; 

set character_set_server= 'utf8'; 

set character_set_database= 'utf8';

乱码问题：把html文件另存为为utf-8，meta设置为utf-8，导入的csv格式另存为utf-8，数据库默认编码改为utf-8

数据库导入表格时，表格最后一行数据=数据值+换行解决方案：导入前数据最后加一列没用的数据（这列不导入）