Linux MySQL操作

看数据库：

show databases;

建数据库：

CREATE DATABASE IF NOT EXISTS 数据库名;

进数据库：

use 库名;

看表：

show tables;

建表：

create table if not exists 表名 (
    id int quto_increment primary key,
    username varchar(20)
);

看表结构：

describe 表名;

看表内容：

select * from 表名;

添加内容：

insert into '数据库名'.'表名' ('id', 'username') values (5, 'lshib44');

建表记录：

detection_user表：
CREATE TABLE `detection`.`detection_user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `password` varchar(40) NOT NULL,
  `access_token` varchar(400) NOT NULL,
  `create_time` varchar(100) NULL,
  `img_name` varchar(255) NULL,
  PRIMARY KEY (`id`)
);

detection_user_info表：
CREATE TABLE `detection`.`detection_user_info`  (
  `id` int NOT NULL,
  `nickname` varchar(50) NULL,
  `username` varchar(50) NOT NULL,
  `gender` varchar(10) NULL,
  `description` varchar(320) NULL,
  `location` varchar(100) NULL,
  PRIMARY KEY (`id`)
);

user_login_history表：
CREATE TABLE `detection`.`user_login_history`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `login_time` varchar(100) NULL,
  `login_location` varchar(100) NULL,
  `login_ip` varchar(100) NULL,
  PRIMARY KEY (`id`)
);


INSERT INTO `detection`.`detection_user` (`id`, `username`, `password`, `access_token`, `create_time`, `img_name`) VALUES (2, 'lshib00', '000000', 'hjhfxbczdfshbjxvduzfshdshbjxdsjbdxcvdf', '2023-03-27 13:11:01', 'moren.jpg')


INSERT INTO detection_user_info (`id`, `nickname`, `username`, `gender`, `description`, `location`, `birth_date`) VALUES (5, NULL, 'lshib33', NULL, NULL, NULL, NULL);



INSERT INTO `detection`.`user_login_history` (`user_id`, `login_time`, `login_ip`, `login_location`) VALUES (3, '2024-03-27 15:52:21', '(114.223.4.*)', '中国江苏省无锡市');
{'user_id': 3, 'login_time': '2024-03-27 15:52:21', 'login_ip': '(114.223.4.*)', 'login_location': '中国江苏省无锡市'}



alter table 表名 change 字段名 字段名 varchar(10) character set utf8;
alter table  character set utf8;

ffmpeg一些问题：

ffmpeg: /opt/anaconda3/lib/libtinfo.so.6: no version information available (required by /lib/x86_64-linux-gnu/libcaca.so.0)
ffmpeg: /opt/anaconda3/lib/libncursesw.so.6: no version information available (required by /lib/x86_64-linux-gnu/libcaca.so.0)
ffmpeg: /opt/anaconda3/lib/libncursesw.so.6: no version information available (required by /lib/x86_64-linux-gnu/libcaca.so.0)
ffmpeg: symbol lookup error: /lib/x86_64-linux-gnu/libp11-kit.so.0: undefined symbol: ffi_type_pointer, version LIBFFI_BASE_7.0
/media/amax/2ba0296e-970d-47b1-a3a5-6c20e1b70441/lshib/Vue_Flask_Detection/flask_back/static/result/004_video_final.mp4

/opt/anaconda3/lib/libtinfo.so.6: no version information available (required by /lib/x86_64-linux-gnu/libcaca.so.0)

ll /opt/anaconda3/lib/libtinfo.so.6