mysql中如何根据表名找到库名
mysql中如何根据表名找到库名:
SELECT table_schema FROM information_schema.TABLES WHERE table_name = '表名';
添加字段:
ALTER TABLE `库名`.`表名`ADD COLUMN `字段名称` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '字段释义';
mysql中如何根据表名找到库名:
SELECT table_schema FROM information_schema.TABLES WHERE table_name = '表名';
添加字段:
ALTER TABLE `库名`.`表名`ADD COLUMN `字段名称` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '字段释义';