江苏龙网

  1. 主页 > 生活百科 > >

如何使用GPT作为SQL查询引擎的自然语言( 三 )

GPT

<- openai::create_chat_completion(model = "gpt-3.5-turbo", temperature = 0, messages = list( list(role = "user", content = the_prompt()) ))the_gpt_sql <- my_results$choices$message.content# print the SQL sql_html <- gsub("n", "
", the_gpt_sql)sql_html <- paste0("

", sql_html, "

")# Run SQL on data to get results gpt_answer <- sqldf(the_gpt_sql)setProgress(value = 1, message = 'GPT results received') # Send msg to user that}) # Print SQL and results output$the_sql <- renderUI(HTML(sql_html))if (is.vector(gpt_answer) ) { output$results <- renderPrint(gpt_answer)} else { output$results <- renderPrint({ print(gpt_answer) })} }) }shinyApp(ui = ui, server = server)原文标题：How to use GPT as a natural language to SQL query engine，作者：Sharon Machlis

【如何使用GPT作为SQL查询引擎的自然语言】


推荐阅读


上一篇：Windows 12预计将带来更多AI功能 Copilot或将取代开始按钮

下一篇：ChatGPT企业版，基本凉了！