Questions tagged [mysql-error-1052]

Ask Question

Error 1052 - "Column '%s' in field list is ambiguous". This error appears because there are more than one identically named columns referenced in the query.

45 questions More

• Bountied 0
• Unanswered
• Frequent
• Score
• Unanswered (my tags)

Apply filter

2 votes 2 answers 307 views

ON DUPLICATE KEY doesn't work with my INSERT INTO script

I have two tables. One is permission_index and the other is permission_index_bkp. My script is supposed to transfer some rows and data from permission_index to permission_index_bkp. However, I don't ... mysql sql mysql-error-1054 mysql-error-1052 Hilas

• 61

asked Aug 22, 2021 at 5:11 0 votes 1 answer 481 views

Column 'department_id' in where clause is ambiguous

I got error on my page like the title above. I am trying to export an Excel with the Laravel Excel extension. Here is my code: public function query() { $test = Leave::query() ... laravel mysql-error-1052 Maria

• 13

asked Jul 7, 2021 at 8:30 -1 votes 2 answers 151 views

#1052 - Column 'bookingId' in where clause is ambiguous

I want to join to two table but I got a problem Here is my SQL syntax select * from booking as b, booking_detail as bd WHERE bookingId = 9 AND b.bookingId = bd.bookingId Here is I got error: # 1052 ... mysql sql mysql-error-1052 user9468951 asked Nov 7, 2019 at 9:58 0 votes 2 answers 442 views

Column 'date_start' in where clause is ambiguous

I wanna SELECT some date, but i have problem with this SELECT DISTINCT `clients_agreements`.`date_start` , `buildings`.`id` , `buildings`.`street` , `buildings`.`street_nr` , `clients`.`... mysql mysql-error-1052 JustNone

• 15

asked May 23, 2019 at 10:44 0 votes 1 answer 582 views

#1052 - Column 'date' in field list is ambiguous

update callingroute AS t1 INNER JOIN callingroute AS t2 SET t1.day = (select date FROM (select dayname(date) from callingroute where status = 'OK')AS X) WHERE t1.calling_route_id IS ... sql mysql-error-1052 Pravesh

• 25

asked Mar 19, 2019 at 12:30 0 votes 2 answers 361 views

MySQL 'tahun_pemilihan' in where clause is ambigous

How can I correct the problem I keep getting from the code below which states 'tahun_pemilihan' in where the clause is ambiguous. Thanks for the help in advance. here is the MySQL table $sql = "... mysql mysql-error-1052 Nazarudin

• 589

asked Apr 12, 2018 at 3:12 -1 votes 1 answer 154 views

Error 1052: Column 'metric_name' in where clause is ambiguous

SELECT b.target_host AS 'host', a.target_ip AS 'Target', a.monitor_type AS 'Type Monitor', ... mysql sql grafana mysql-error-1052 Alvianno Wijaya

• 1

asked Jan 19, 2018 at 8:16 0 votes 2 answers 247 views

Column 'size' in field list is ambiguous

Invalid SQL: SELECT info_hash, size, comment, created_by, announce_list, completed_by, completed, seeders, leechers, ulspeed, dlspeed, dateline, thumbnail_dateline, filename, ... mysql sql mysql-error-1052 Film Buzz

• 1

asked Oct 4, 2017 at 0:48 4 votes 1 answer 10k views

Laravel relationship Column 'id' in where clause is ambiguous

I have courses and subscription types. I want to get all the courses that has a given subscription type. My attempt: $courses=Course::wherehas('subscriptionType',function ($q) { ... php laravel laravel-5 eloquent-relationship mysql-error-1052 user3844579

• 475

asked Mar 2, 2017 at 19:13 4 votes 1 answer 10k views

Mysql error: violation: 1052 Column 'created_at' in where clause is ambiguous'

I am getting the issue: Integrity constraint violation: 1052 Column 'created_at' in where clause is ambiguous but the table sales_flat_order_grid have created_at Column SELECT DISTINCT main_table.*, ... mysql left-join mysql-error-1052 Amit Bera

• 7,514

asked Nov 28, 2016 at 16:43 1 vote 2 answers 2k views

MySQL query: How to fix Error 1052 (ambiguous column)

I keep getting an error when I run both of the following queries that the CUST_NUM is ambiguous. How can I fix this? SELECT INV_NUM, CUST_NUM, CUST_LNAME, CUST_FNAME, INV_DATE, INV_AMOUNT FROM ... mysql sql mysql-error-1052 Abby Schukei

• 45

asked Oct 7, 2015 at 3:19 1 vote 1 answer 150 views

ambiguous error in mysql recordset in Dreamweaver

The following recordset in Dreamweaver throws a 1052 ambiguous error every time I attempt to test it. I know it has something to do with the dateADDED, but don't know how to fix it. SELECT ... mysql sql dreamweaver recordset mysql-error-1052 Mike

• 31

asked Apr 25, 2015 at 23:27 0 votes 1 answer 877 views

Error Code: 1052 when INSERTing (ID in field list is ambiguous)

I am being thrown a really weird error code, judging that I have successfully INSERTed values using the same query in a similar schema. I am trying to execute the following query: INSERT INTO ... mysql sql ambiguous mysql-error-1052 fieldlist mmmarius

• 15

asked Jun 3, 2014 at 16:45 1 vote 4 answers 253 views

#1052 - Column 'noMyKid' in where clause is ambiguous

SELECT *, DATEDIFF(CURDATE(),tarikhmohon) AS hari FROM mohon a INNER JOIN tblstatus_tak_lengkap b on a.noMyKid=b.nomykid WHERE noMyKid=130902100437 I have tried that SQL but I got an error. #1052 -... sql database mysql-error-1052 user3487681

• 149

asked Apr 14, 2014 at 3:25 11 votes 1 answer 64k views

Column 'id' in where clause is ambiguous

I get this error and I can't figure out why? Error Number: 1052 Column 'id' in where clause is ambiguous SELECT `leads`.*, `customers`.`id` AS customers_id, `customers`.`name` AS ... mysql codeigniter mysql-error-1052 Casperlarsen

• 131

asked Mar 25, 2014 at 10:56
15 30 50 per page123 Next