1. 安装客户端和登陆
客户端安装:
apt-get install mysql-client
登陆:
mysql -u 用户名 -P 端口号 -h 数据库地址 -p
根据提示输入密码
2. 查看所有数据库名
show databases;
use db_name;
3. 查看所有数据表名
show tables;
4. 创建表
CREATE TABLE `table_name` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`field_name` varchar(100) NOT NULL DEFAULT '',
`status` int(10) unsigned NOT NULL DEFAULT '1',
`modifier` varchar(60) NOT NULL DEFAULT '',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modified_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
4. 销毁表
DROP TABLE <表名>;
5. 插入数据
INSERT INTO table_name ( field1, field2,...fieldN )
VALUES
( value1, value2,...valueN );
3. 查看语句,以及看最后几条
SELECT * FROM table_name order by field DESC limit 10;
select * from ailab_dic_core_word where product like '%人字梯%';
4. 更新记录
update table_name set fieldName=0 where fieldVal='str';
5. 删除数据
DELETE FROM tableName where field='val';