Breaking News: Grepper is joining You.com. Read the official announcement!
Check it out

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'Name' in where clause is ambiguous

Shy Snake answered on May 14, 2021 Popularity 8/10 Helpfulness 1/10

Contents


More Related Answers

  • SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
  • how to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
  • Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
  • Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
  • [SQLITE_ERROR] SQL error or missing database (table destination has x columns but y values were supplied).
  • SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
  • column 'user_id' in on clause is ambiguous
  • Uncaught PDOException: SQLSTATE[42S22]: Column not found:
  • ERROR: column reference "doctor_id" is ambiguous

  • SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'Name' in where clause is ambiguous

    0

    Ambiguous, means that mysql doesn't know which column to order by, you have two columns with the name name, you probably need to prefix it with the table name as well. 

    answer given by Tray2 in https://laracasts.com/discuss/channels/laravel/sqlstate23000-integrity-constraint-violation-1052-column-name-in-order-clause-is-ambiguous

    Popularity 8/10 Helpfulness 1/10 Language sql
    Source: Grepper
    Link to this answer
    Share Copy Link
    Contributed on May 30 2023
    Shy Snake
    0 Answers  Avg Quality 2/10

    Closely Related Answers



    3
    Popularity 9/10 Helpfulness 4/10 Language php
    Source: Grepper
    Tags: ambiguous ambi
    Link to this answer
    Share Copy Link
    Contributed on Dec 26 2022
    Shadow
    0 Answers  Avg Quality 2/10

    1
    Popularity 9/10 Helpfulness 3/10 Language php
    Source: Grepper
    Tags: ambiguous ambi
    Link to this answer
    Share Copy Link
    Contributed on Nov 28 2022
    Adam, the developer
    0 Answers  Avg Quality 2/10

    0
    Popularity 10/10 Helpfulness 1/10 Language sql
    Source: Grepper
    Tags: ambiguous ambi
    Link to this answer
    Share Copy Link
    Contributed on May 14 2021
    Lokesh003
    0 Answers  Avg Quality 2/10


    X

    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    X
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.