Part I: 数据库基本操作
1. 数据库登录:
mysql -h localhost -u root -p 密码 password
2. 创建数据库:
基本语句
CREATE DATABASE database_name;
在创建数据库时指定字符集
create database yourDB CHARACTER SET gbk
3. 查看:
- 查看数据库参数设置:
- 查看数据库大小:
select concat(round(sum(data_length/1024/1024),2),'MB') as data from tables where table_schema='crowd';
其中 crowd 为数据库名字;
- 查看mysql运行状态
Is MySQL running?
sudo ps wwaux | grep -i sql
If that does not output anything, try starting the MySQL service:
sudo service mysql start
Also, what hostname/port is MySQL listening on?
sudo netstat -plutn | grep -i sql
4. 数据库设置:
- 设置变量:
set character_set_database=utf8; set character_set_server=utf8;
- 增删改查
增
"capinfo":'''INSERT INTO APS_CAPINFO(tenid,calno,plant,capg