ffmpeg -i IMG_0001.jpg -frames:v 1 -filter_complex “color=#FFFFFF:s=500×400[v1];\ [v1]drawtext=fontfile=/usr/share/fonts/msyh.ttf:text=’这是什么东西？’:borderw=3:bordercolor=#FF0000:\ x=30:y=130:fontsize=80[v1];[v1]rotate=a=-PI*30/180:fillcolor=#FFFFFF@0[v1];[v1]colorkey=#00FF00:0.05:1[v2];\ [0:v][v2]overlay=main_w-overlay_w-240:main_h-overlay_h-240″\ -y input_1_1.jpg 在一张图片上画一块区域，在区域中写入文字，然后让文字旋转，就实在了文字打斜功能。 ffmpeg -f lavfi -i color=#FF0000:size=500×400 -frames:v 1 -filter_complex “color=#FFFFFF:s=500×400[v1];\ [v1]drawtext=fontfile=/usr/share/fonts/msyh.ttf:text=’这是什么东西？’:borderw=3:bordercolor=#FF0000:\ x=30:y=130:fontsize=80[v1];[v1]rotate=a=-PI*30/180:fillcolor=#FFFFFF@0[v1];[v1]colorkey=#00FF00:0.05:1[v2];\ [0:v][v2]overlay=main_w-overlay_w-10:main_h-overlay_h-10″\ -y input_1_2.jpg ffmpeg -f lavfi -i color=#FF0000:size=1000×600 -frames:v 1 -filter_complex “color=#FFFF00:s=1000×600[v1];[v1]drawtext=fontfile=/usr/share/fonts/msyh.ttf:text=’It has been exist’:borderw=1:bordercolor=#FF0000:x=50:y=250:fontsize=130[v1];[v1]rotate=PI/9:fillcolor=#FFFFFF@0[v1];v1]colorkey=#00FF00:0.05:1[v2];[0:v][v2]overlay=main_w-overlay_w-10:main_h-overlay_h-10” -f image2 exist_0.jpg -y ffmpeg -f lavfi -i color=#FFFFFF:size=1000×600 -frames:v 1 -filter_complex “color=#FFFFFF:s=1000×600[v1];\ [v1]drawtext=fontfile=/usr/share/fonts/msyh.ttf:text=’It has been… Continue reading ffmpeg filter_complex rotate
Author: linux
alter table
alter table information add column English char(6); 1. 修改列的数据类型 假设你有一个表employees，其中有一个列salary，你想将其从DECIMAL(10, 2) 改为DECIMAL(15, 2)。
update table
update information set English=’89’ where no=0001;
insert into
MySQL [mydb]> insert into employee values -> (‘李天乐’,’93453′,’34’,’中科院信息技术研究所’); Query OK, 1 row affected (0.090 sec)
create database or table
MySQL [(none)]> create database mydb; Query OK, 1 row affected (0.093 sec) MySQL [(none)]> use mydb; Database changed MySQL [mydb]> create table employee; ERROR 1113 (42000): A table must have at least 1 column MySQL [mydb]> create table employee\ (name varchar(20) not null, number varchar(10),\ age char(5), department varchar(50)); Query OK, 0 rows affected (0.094… Continue reading create database or table