sql 常用语句

INNER JOIN SELECTOrders.OrderID,Customers.CustomerNameFROMOrdersINNERJOINCustomersONOrders.CustomerID=Customers.CustomerID;SELECTOrders.OrderID,Customers.CustomerName,Shippers.ShipperNameFROM((OrdersINNERJOINCustomersONOrders.CustomerID=Customers.CustomerID)INNERJOINShippersONOrders.ShipperID=Shippers.ShipperID);SELECTCustomers.CustomerName,Orders.OrderIDFROMCustomersLEFTJOINOrdersONCustomers.CustomerID=Orders.CustomerIDORDERBYCustomers.CustomerName;SELECTOrders.OrderID,Employees.LastName,Employees.FirstNameFROMOrdersRIGHTJOINEmployeesONOrders.EmployeeID=Employees.EmployeeIDORDERBYOrders.OrderID;UNION SELECTCityFROMCustomersUNIONALLSELECTCityFROMSuppliersORDERBYCity;SELECT'Customer'ASType,ContactName,City,CountryFROMCustomersUNIONSELECT'Supplier',ContactName,City,CountryFROMSuppliers; Type ContactName City Country Customer Alejandra Camino Madrid Spain

Markdown Syntax Guide

有一个问题一直没解决,就是inline code的高亮,比如文章中 <h1> MD预览中背景有灰色,可是hugo预览一直非常浅。看官方说是渲染的关系。有强迫症直接在css中改的,也不管后期渲染了,MD中table无法显示。 This article offers a sample of basic Markdown syntax that can be used in Hugo content files, also it shows whether basic HTML elements are decorated with CSS in a Hugo theme.

Placeholder Text

Lorem est tota propiore conpellat pectoribus de pectora summo. 开发中,使用方法 lorem + 单词数量

Math Typesetting

Mathematical notation in a Hugo project can be enabled by using third party JavaScript libraries.

Thumbnail image

Guide to Thumbnails in Hugo

Hugo 缩略图尝试, 图片应该每次都从缓存的文件提取,我改变图片的时候,无法实时改变,只好改变文件名来显示