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

mysql sql mariadb
qliq picture qliq · Jun 4, 2013 · Viewed 61.5k times · Source

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

Answer

Joachim Isaksson picture Joachim Isaksson · Jun 4, 2013

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.

Related questions

ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk FOREIGN KEY (KundeID) REFERENCES …

Read More
Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(…

Read More
MySQL - SELECT * INTO OUTFILE LOCAL ?

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be hosted on the same server as the client. So we used to do this : SELECT * INTO OUTFILE .... LOAD DATA INFILE .... …

Read More