MySQL Forums
Forum List  »  Newbie

Error DBNAME.TABLE_NAME: Duplicate column name 'COLUMN_NAME'
Posted by: Azhar Mat Zin
Date: January 10, 2024 03:08PM

Error DBNAME.TABLE_NAME: Duplicate column name 'COLUMN_NAME'

1) Let say there is old development db, mysql 8 community edition, there is a lot of test db/schemas and test tables in it. accumulated over the years.

2) I wanted to create a table, and I get "Duplicate column name" error

3) There is NO duplicate column name in the table I wanted to create.

Searching for this error mostly lead to solution to point 3, in which the answer thinking the user are making this mistake, which I didn't.

There is no constraint in the table that I wanted to create.

Where should I start my investigation? (I have experiences in Oracle db but new in MySQL).

Options: ReplyQuote

Written By
Error DBNAME.TABLE_NAME: Duplicate column name 'COLUMN_NAME'
January 10, 2024 03:08PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.