Environmental Science:
spring cloud + Mybatis-plus + postgresql
Scenario:
Prompt during table insertion
org.postgresql.util.PSQLException: ERROR: syntax error at or near “current_date”
Causes:
current_ Date() is the method of SQL, current_ Date is the method name
resolvent:
current_ Change date to create_ Date (optional here, not the method name)
Analysis process:
The Error statement in XML file and navigator displays current_ Date is green (keyword color)
Read More:
- Pyspark36830;- 25509;- Postgresql38169; java.lang.ClassNotFoundException: org.postgresql.Driver
- Linux view current date and time
- PostgreSQL sets the default value of the field to the current year
- Get the current date in Python
- Error: Could not find or load main class org.apache.hadoop.hbase.util.HBaseConfTool
- Used by: Java. Lang. classnotfoundexception: org. PostgreSQL. Driver
- Failed to convert value of type ‘java.lang.String‘ to required type ‘java.util.Date‘;
- Vitis: platform out of date, makefile error at compile time; The modified application compiles to undefined reference
- [PostgreSQL tutorial] · PostgreSQL error prompt: “error 42501” or “permission denied”
- ‘Conversion failed when converting date and/or time from character string.DB-Lib error message 241,
- 1、 Java 8 date and local date
- PSQLException: ERROR: cached plan must not change result type
- [Solved] IE Browser Upload Files Error: org.apache.tomcat.util.http.fileupload.FileUploadException: Stream ended unexpectedly
- Solve syntax error: unexpected end of file or /bin/bash^m: bad interpeneter: no match file or directory
- Solve the problem of syntax error: unexpected end of file or syntax error near unexpected token ` fi ‘error
- 【error】postgresql relation does not exist
- java.lang.NoSuchMethodError: org.json.JSONObject.put(Java/lang/String; Java/util/Collection;) “209151;”
- Error: syntax error – unexpected token P in JSON at position 0
- The build report plug-in reported an error in importing unit script (BRT_ Util.cs :error CS1525: Unexpected symbol `;’, expecting `)’, or `,’)
- Problems encountered after Maven installation or upgrade: could not find or load main class org.codehaus.plexus .class…..