我正在做一個F#項目,需要對在線mysql數(shù)據(jù)庫進行一些數(shù)據(jù)庫查詢.誰能幫幫我嗎.我需要這樣的東西

\\ Connect to DB

let servername = "localhost"

let username = "username"

let password = "password"

\\ Code that connects to db

\\ Print error message if can connect

\\ Query

let query = "SELECT * FROM table ..."

\\ Code that executes query

\\ Error Message if query not executed

解決方法:

您應(yīng)該為MySQL安裝.NET驅(qū)動程序.然后安裝SQLprovider.在文檔中有MySQL的示例.您將連接到數(shù)據(jù)庫并像這樣查詢它：

type sql = SqlDataProvider<

dbVendor,

connString,

ResolutionPath = resPath,

IndividualsAmount = indivAmount,

UseOptionTypes = useOptTypes,

Owner = "HR"

>

let ctx = sql.GetDataContext()

let employees =

ctx.Hr.Employees

|> Seq.map (fun e -> e.ColumnValues |> Seq.toList)

|> Seq.toList

connstring將如下所示：

[]

let connString = "Server=localhost;Database=HR;User=root;Password=password"

標簽：f,connect,sql,mysql,database

來源： https://codeday.me/bug/20191027/1941119.html

總結(jié)

以上是生活随笔為你收集整理的mysql执行查询出来的数据_F#连接到在线MySQL数据库执行查询的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。