- 博客(3)
- 收藏
- 关注
RSS订阅原创 sql server查询数据库中所有表名,查询表中所有字段名
1.查询数据库中所有表名称：select table_name from information_schema.tables where TABLE_CATALOG=‘数据库名称’;（包含视图）select table_name from information_schema.tables where TABLE_CATALOG=‘数据库名称’ and table_type = ‘BASE TABLE’ AND table_schema = DATABASE ();（不包含视图）2.查询每张表中所有字
2022-01-13 10:56:25
9680
转载 Linux下SqlServer的备份和还原
Linux下备份SqlServer数据库命令//创建数据库备份文件夹mkdir -pv /usr/local/databackup//给mussql授予/usr/local/databackup文件夹的权限chown -R mssql:mssql /usr/local/databackup///登录数据库sqlcmd -S 127.0.0.1 -U sa//备份数据库到指定路径1> backup database Test to disk='/usr/local/databackup
2020-10-26 11:50:42
1524
2
转载 SQL 查询删除重复记录
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) 2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录 delete from people ..
2020-10-26 11:42:15
331
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人