拉取镜像
docker pull mcr.microsoft.com/mssql/server:2019-latest
运行容器
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=abc123456." -p 1433:1433 --name sqlserver2019 -d mcr.microsoft.com/mssql/server:2019-latest
ACCEPT_EULA=Y
:默认选择统一协议许可证SA_PASSWORD=abc123456.
:密码
进入容器
进入容器:
docker exec -it sqlserver2019 /bin/bash
连接数据库:
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "abc123456."
查询数据库:
select name from sys.Databases
go
创建数据库:
create database test_db
go
远程连接
create table stu (
id int primary key,
name varchar(20)
);
insert into stu values
(1, 'tom'),
(2, 'jerry'),
(3, 'mike');
select * from stu;