Attacked_code的博客

select replace(CONCAT("ALTER TABLE 表名称 ADD INDEX ",COLUMN_NAME," (aaaaaaaaa);"),'aaaaaaaaa',COLUMN_NAME) from information_schema.COLUMNSwhere table_name = '表名称'批量创建添加索引的语句:information_schema.COLUMNS : 获取数据库中指定表的列名称 replace:替换函数用法replace(要替...

> 1072 - Key column 'ID' doesn't exist in table问题起因：使用SQL语句创建表出现提示错误解决办法:看下你创建的自增长的主键名名称和PRIMARY KEY (`主键编号名称`) USING BTREE是否对应...

安装mysql 出现错误：软件包：mysql-community-server-5.7.27-1.el7.x86_64 (mysql57-community) 需要：mysql-community-common(x86-64) = 5.7.27-1.el7已安装: mysql-community-common-8.0.17-1.el8.x86_64 (installed)...

SELECT CONCAT( 'truncate TABLE ', table_schema, '.', TABLE_NAME, ';' ) FROM INFORMATION_SCHEMA.TABLES WHERE table_schema IN ( '数据库1','数据库2','数据库3' );生成 删除的语句 复制语句进行删除，删除成功...