网络营销产品营销方案_灰色词首页排名接单_大型营销型网站制作_软文广告成功案例

SELECT COLUMN_NAME, NUMERIC_PRECISION, NUMERIC_SCALE
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'financeproject' AND TABLE_NAME = 'finance_balance' AND DATA_TYPE = 'decimal';

查出的字段   excel 拼接 修改语句

ALTER TABLE finance_income  MODIFY COLUMN 	yyzsrbqje	DECIMAL(28, 10) DEFAULT 0;