MySQL ‘user_id’ in where clause is ambiguous problem

by

You simply need to specify which user_id to use, since both the user_info and user table have a field called user_id:

... WHERE user.user_id=1

SQL wouldn’t tolerate this ambiguity, since for what it knows, both fields can represent totally different data.

More Related Contents:

  1. 1052: Column ‘id’ in field list is ambiguous
  2. If two columns are 1 then make new column
  3. Can we use CONCAT and JOIN together in MySQL? [closed]
  4. Truncate all tables in a MySQL database in one command?
  5. Retrieving the last record in each group – MySQL
  6. Cast from VARCHAR to INT – MySQL
  7. Find distance between two points using latitude and longitude in mysql
  8. How to convert result table to JSON array in MySQL
  9. Solution to “subquery returns more than 1 row” error
  10. Adding multiple columns AFTER a specific column in MySQL
  11. Storing SHA1 hash values in MySQL
  12. Downloading MySQL dump from command line
  13. DOUBLE vs DECIMAL in MySQL
  14. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  15. tomcat7 – jdbc datasource – This is very likely to create a memory leak
  16. Select from one table where not in another
  17. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  18. MySQL database with unique fields ignored ending spaces
  19. Set value to NULL in MySQL
  20. mysql DECLARE WHILE outside stored procedure how?
  21. How can I check MySQL engine type for a specific table?
  22. mysql SQL: specific item to be first and then to sort the rest of the items
  23. mySQL UPDATE query returns “0 rows affected”
  24. When is a timestamp (auto) updated?
  25. Should I normalize my DB or not?
  26. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  27. GRANT with database name wildcard in MySQL?
  28. Using SUM on FLOAT data
  29. Duplicate entry for key ‘group_key’
  30. SQL query with avg and group by

Leave a Comment