Mysql命令

1.命令新增数据库字段

Sql：ALTER TABLE t_top_declare ADD COLUMN (
	`line_rmk` TINYINT ( 1 ) DEFAULT '0' COMMENT '是否提交直列',
	`email` VARCHAR ( 255 ) DEFAULT NULL COMMENT '电子邮箱',
`tel` VARCHAR ( 255 ) DEFAULT NULL COMMENT '联系电话' 
);

2.替换

update [表名] set 字段名 = replace(与前面一样的字段名,'原本内容','想要替换成什么')

3。特殊符号

java.sql.SQLException: Incorrect string value: '\xF0\x9F\x92\x94' for column 'content' at row 1_阿武刚巴得-CSDN博客使用Mysql服务器的utf8字符编码，在存入移动端emoji表情时会报异常：Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x84' for column 'content' at row 1 at com.mysql.jdbc.SQLError.createSQLException(S...https://blog.csdn.net/qq_36090463/article/details/82353327

4.

UPDATE ct.t_hn_assessment_terms_register as a
inner JOIN (SELECT b.BIZ_KEY_,b.UPDATE_TIME_ FROM basic.bpm_pro_inst b WHERE b.IS_DELE_ = 0) bb
ON a.id = bb.BIZ_KEY_
SET a.work_flow_end_time = bb.UPDATE_TIME_
WHERE a.delete_flag = 0 and a.status_code = 3 ;