Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

sql

mysql

mariadb

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

like image 774
qliq Avatar asked Jun 04 '13 05:06

qliq

People also ask

How do I fix MySQL Unknown column in field list error?

To fix the error above, simply add a quotation mark around the value. You can use both single quotes or double quotes as shown below: INSERT INTO users(username, display_name) VALUES ("jackolantern", 'Jack'); Now the INSERT statement should run without any error.

Why is there an unknown column in the field list?

The MySQL unknown column in field list error happens when you put a column name in your SQL script that can't be found by MySQL. The error above is because there's no student_name column in the students table.

1 Answers

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.

like image 153
Joachim Isaksson Avatar answered Oct 05 '22 19:10

Joachim Isaksson
Sign in to Comment

Related questions

where can I find mysql.data.dll for c# [closed]
UTF8 issues PHP -> MySQL. Getting question marks in database?
Java EE application deployment on Amazon EC2
MySQL Subquery with main query data variable
Mysql Server 5 vs 6 vs MariaDB [closed]
PDO IN() Array Statement AND a placeholder
ignoring mysql fulltext stopwords in query
MySQL "binary" vs "char character set binary"
MySQL select random row - rand() performance [duplicate]
What PDO driver to use with mariadb?
can't connect to mysql on AWS RDS (error 2003)
java.sql.SQLException: Connections could not be acquired from the underlying database
Correct way to bind parameters using MySQL "IN" syntax in Yii2?
How to connect to a MySQL database from an iPhone?
Can I write prepared statements in procedural style?
Using MySQL in R for Windows
MySQL Injection - Use SELECT query to UPDATE/DELETE
Most efficient way to store and access a huge data matrix in MySQL
Select a portion from a MySQL Blob Field
Whats the best way to store a time duration in a MySQL larger than the TIME range?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!