sql
菜鸟王小凡
这个作者很懒,什么都没留下…
展开
-
docker 运行mysql和sqlserver数据库
学习目标: docker 运行日志 mysql 日志 学习内容: docker run -p 33306:3306 --name mysql -v /opt/data/mysql/conf:/etc/mysql/conf.d -v /opt/data/mysql/logs:/logs -v /opt/data/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=01811a4278394370b566f64dc617e0b0 -d mysql:latest原创 2021-05-07 16:09:23 · 163 阅读 · 0 评论 -
sql servre 从一个数据库到另一个数据库
use ShangYuanHuiDB go /启动Ad Hoc Distributed Queries/ exec sp_configure ‘show advanced options’,1 reconfigure exec sp_configure ‘Ad Hoc Distributed Queries’,1 reconfigure insert into ShangYuanHuiDB.dbo.QuanGuoDataBaiDu select [Name] ,[Lat] ,[Lng] ,[Addr原创 2020-12-30 16:55:41 · 154 阅读 · 0 评论 -
sql server 删除重复数据保留一条!
CREATE VIEW [dbo].[tmp_view] AS SELECT ROW_NUMBER() OVER (PARTITION BY name, addr ORDER BY (SELECT 1) ) AS no, name, addr FROM Test GO 创建视图, delete from tmp_view where no!=1原创 2020-10-16 20:22:13 · 474 阅读 · 0 评论