rsqlite_send_query(conn @ ptr，语句)中的错误:靠近“("):语法错误 [英] Error in rsqlite_send_query(conn@ptr, statement) : near "(": syntax error

问题描述

下面的代码行:

sqldf("UPDATE q1_sql_1 SET MONTH_YEAR = RIGHT(MONTH_YEAR, LEN(MONTH_YEAR) - 4)")

显示此错误:

Error in rsqlite_send_query(conn@ptr, statement) : near "(": syntax error

推荐答案

使用length和rightstr.有关SQLite中可用的功能，请参见:

Use length and rightstr. For the functions available in SQLite see:

https://www.sqlite.org/lang_corefunc.html

，以及RSQLite也提供的有用功能:

and for the contributed functions that RSQLite also makes available:

https://github.com/ggrothendieck/sqldf#example-15-use-of-rsqliteextfuns-library-functions

这篇关于rsqlite_send_query(conn @ ptr，语句)中的错误:靠近“("):语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！