Key column '' doesn't exist in table while the column exists

Question

i have a simple and weird problem . when i run

 alter table verizon_device_usages drop verizon_device_id

mysql gives this error .

alter table verizon_device_usages drop verizon_device_id
> 1072 - Key column 'verizon_device_id' doesn't exist in table
> Time: 0.003s

but when i run

 alter table verizon_device_usages ADD COLUMN verizon_device_id VARCHAR(15)

my sql returns this error :

alter table verizon_device_usages ADD COLUMN verizon_device_id VARCHAR(15)
> 1060 - Duplicate column name 'verizon_device_id'
> Time: 0.02s

i just want to remove that column with laravel migration or even query but i cant . any idea why its like that ?? i can see the column on table exists

Could you please provide DDL (create table....) for your table? — asd-tm, Sep 18 '22 at 20:17
i can even rename that column without problem or make it nullable , but i cant drop it — Farshad, Sep 18 '22 at 20:25
Is it possible you need to say `... DROP COLUMN column_name`, including the word `COLUMN`? — O. Jones, Sep 18 '22 at 20:27

asd-tm · Answer 1 · 2022-09-18T20:50:16.043

1

I guess you've simply lost column in your script:

alter table verizon_device_usages drop column verizon_device_id;

Key column '' doesn't exist in table while the column exists

1 Answers1