WOLFRAM

Wolfram 语言与系统参考资料中心

SQLExpr[expr]

allows a Wolfram Language expression to be stored in a database.

更多信息和选项
Details and Options Details and Options
范例  
基本范例  
参见
技术笔记
相关指南
DatabaseLink`
DatabaseLink`

SQLExpr

SQLExpr[expr]

allows a Wolfram Language expression to be stored in a database.

更多信息和选项

范例

基本范例  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["demo"];
Wolfram Language code: SQLCreateTable[conn, SQLTable["EXPRTABLE"], {SQLColumn["EXPRCOL", "DataTypeName" -> "VARCHAR", "DataLength" -> 2 ^ 12]}];

Insert an expression:

Wolfram Language code: SQLInsert[conn, "EXPRTABLE", {"EXPRCOL"}, {SQLExpr[Sin[x ^ 2]]}];

Select an expression:

Wolfram Language code: SQLSelect[conn, "EXPRTABLE"]

Use the expression in an evaluation:

Wolfram Language code: Plot[Identity@@%[[1, 1]], {x, -2Pi, 2Pi}]
Wolfram Language code: SQLDropTable[conn, "EXPRTABLE"];
Wolfram Language code: CloseSQLConnection[conn];