This post has been de-listed (Author was flagged for spam)
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Hi! I'm learning MySQL, I'm following a tutorial (in Spanish) and everything was well until I got this error: Error Code: 1054. Unknown column 'usuarios_id' in 'field list'. This is the code I'm running:
UPDATE usuarios SET correo_electronico = '[email protected]'
WHERE usuarios_id = 9;
SELECT * FROM usuarios
WHERE usuarios_id = 9 AND correo_electronico = 'coral@random_xyz.xyz';
The thing is that the second part of the code (SELECT * FROM …) works fine. What is it happening?
This is happening on MySQL Workbench 8.0, using MariaDB 11.3.2-1 on Arch Linux.
EDIT: I tried it with DBeaver too, but got the same error.
EDIT 2: looks like it was some error copy/pasting the code, writing it back from scratch solved this issue.
Subreddit
Post Details
- Posted
- 8 months ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/SQL/comment...