MySQL有暫存變數的語法,例如:SELECT @var := 1
如果要在VB.NET使用這種語法,只要在MySQL連線設定的字串裡加入allowuservariables=true即可。
程式
Dim server As String = "localhost"
Dim port As Integer = 3306
Dim dbName As String = "MyDB"
Dim user As String = "root"
Dim pw As String = "MyPassword"
Carlo Chuang changed a year agoView mode Like Bookmark
修改命令提示符號
Cmder預設的命令提示符號是 λ,如果想改成常見的 $,可依以下步驟修改。
開啟cmder安裝目錄下的\vendor\clink.lua檔案。
找到下面這段程式碼。if not prompt_lambSymbol then
prompt_lambSymbol = "λ"
end
修改成以下程式碼。if not prompt_lambSymbol or prompt_lambSymbol == "λ" then
prompt_lambSymbol = "$"
Carlo Chuang changed a year agoView mode Like Bookmark