sqlmysqldatabasemariadbmysql-command-line-client

ERROR 1054 (42S22): Unknown column '‍' in 'field list'

I get this annoying error when I try to insert data from db1 to db2 in MaridaDB 10 using mysql CLI. This is while all the columns exist.

INSERT INTO db2.thread (threadid, title, postuserid, dateline, views)
SELECT  `nid`, `title`, `uid`, ‍‍`created`,
`comment`   from db1.node  where type = 'forum'  and status = 1;

When I execute the same query in PHPMyAdmin, I get:

#1054 - Unknown column 'â€

I tried different syntax like 'like' etc. with no avail. Appreciate your hints

Solution

  • Looks like there are invisible garbage characters in your query.

    Try retyping the query (don't copy and paste or you'll most likely include the garbage character) and it should work.