. 查看所有的数据表
SHOW TABLES;
2. 查看某个数据表的所有的字段
DESCRIBE tb_watch_back;
SHOW COLUMNS FROM tb_watch_back;
3. 查询数据库中某个字段以及所在的表
SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_SCHEMA = 'super_star' AND COLUMN_NAME = 'imei';
4. 使用存储过程更新数据库中某个字段的值
DROP PROCEDURE IF EXISTS update_imei;
CREATE PROCEDURE update_imei(IN oldImei CHAR(15),IN newImei CHAR(15))
BEGIN
DECLARE flag INT DEFAULT 0;
DECLARE tname VARCHAR(50);
DECLARE result CURSOR FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.Columns WHERE TABLE_SCHEMA = 'super_star' AND COLUMN_NAME = 'imei';
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET flag = 1;
OPEN result;
WHILE flag <> 1 DO
FETCH result INTO tname;
SET @execSql = CONCAT('UPDATE ',tname,' SET imei = ',newImei,' WHERE imei = ',oldImei,' ;');
PREPARE stmt FROM @execSql;
EXECUTE stmt;
END WHILE;
END;
CALL update_imei('888888888888888','864773030025354');
5. 参考文章连接
select结果赋值: http:
字符串表名转换: http: