Lake Database

原创已于 2024-07-05 10:31:38 修改

· 183 阅读

0 ·

版权

文章标签：

#数据库 #mysql #sql

于 2024-07-02 16:29:06 首次发布

Data Engineer 专栏收录该内容

16 篇文章

订阅专栏

rm -r dp-203 -f

git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203

cd dp-203/Allfiles/labs/04

./setup.ps1

SELECT o.SalesOrderID, c.EmailAddress, p.ProductName, o.Quantity
FROM SalesOrder AS o
JOIN Customer AS c ON o.CustomerId = c.CustomerId
JOIN Product AS p ON o.ProductId = p.ProductId

%%sql
INSERT INTO `RetailDB`.`SalesOrder` VALUES (99999, CAST('2022-01-01' AS TimeStamp), 1, 6, 5, 1)

%%sql
SELECT * FROM `RetailDB`.`SalesOrder` WHERE SalesOrderId = 99999