sqlite3.OperationalError: no such column: USA
<p>I am moving data from one database to another with the following statment </p>

<pre><code>    cursor.execute("\
                INSERT INTO table (ID, Country)\
                SELECT ID, Country\
                FROM database.t\
                WHERE Country = `USA`\
                GROUP BY Country\
                ;")
</code></pre>

<p>But I get the error</p>

<pre><code>    sqlite3.OperationalError: no such column: USA
</code></pre>

<p>Can't figure out why</p>

<p>Use single quotes, not backticks, when referring to a string literal in your SQLite query:</p>

<pre><code>INSERT INTO table (ID, Country)
SELECT ID, Country
FROM database.t
WHERE Country = 'USA'
GROUP BY Country
</code></pre>

python sqlite