Menu

#6 Backticks for SQL

open
nobody
None
5
2016-11-27
2008-11-18
No

Hello,

I have created a patch which adds backticks round the SQL table and field names, to prevent syntax errors when reserved keywords are used.

It has been tested with sqlite version 3.5.9

nick.

Discussion

  • Nicholas Humfrey

    patch to add backticks round sql

     
  • Roland Hermans

    Roland Hermans - 2016-11-27

    Improved version of Nicholas' backticks patch when using the SQL output --sql option of pxview. Changes with respect to the original patch:
    1. also use backticks for the index names,
    2. removed the incorrect backticks in the INSERT statements.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.