查看所有的表
show table status ;
查看具体的某张表
show table status from xxdb like 'tm_properties' ;
查看具体的字段的意思
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_COMMENT
from information_schema.`COLUMNS` where table_Schema='tm_show' and table_Name='tm_purchase_order';
select showName ,content into @var_name,@conetent from tm_show.tm_show where showName like '%周黑鸭%' and showOID = '5d844572a8e20604ae0c6e44';
select @var_name,@conetent;
update tm_show.tm_show set showName= @var_name,content = @conetent where showOID = "5dca52bda8e2065e73f9e714";