Mysql workbench Error code: 1292. Truncated incorrect INTEGER value:''

Question

I got error code 1292 from this code Can you let me know how to fix it?

I am just trying to make temp table

create table percentpopulationvaccinated (
continent varchar(255),
location varchar(255),
date datetime,
population numeric,
new_vaccinations numeric,
People_Vaccinated numeric
);

Insert into percentpopulationvaccinated
Select death.continent, death.location, death.date, death.population, vac.new_vaccinations, 
sum(convert(vac.new_vaccinations, signed int)) over (partition by death.location order by death.location, death.date) as People_Vaccinated
from coviddeaths as death
join covidvaccinations as vac
    on death.location = vac.location
    and death.date = vac.date;
-- where death.continent is not null
-- order by death.location, death.date

select *, (People_Vaccinated/population)*100
from percentpopulationvaccinated;```

Please add table definitions for coviddeaths and covidvaccinations together with sample data as text. — P.Salmon
– P.Salmon, Commented Jul 25, 2022 at 6:36

Nathan Spencer · Accepted Answer · 2022-07-25 03:12:36Z

0

See this answer: Truncated incorrect INTEGER value

It's not an error. It's a warning that comes from CONVERT() when you ask it to convert non-numeric to integer;

convert(vac.new_vaccinations, signed int)

answered Jul 25, 2022 at 3:12

Nathan Spencer

161 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

aassss111 Over a year ago

But I still get no result when I run select *, (People_Vaccinated/population)*100 from percentpopulationvaccinated; can you let me know how to fix it to see the result?

yusuf · Accepted Answer · 2023-04-05 11:47:54Z

0

Maybe This will help you. use '(int)' before the variable value (like (int)new_vaccinations) for solve this error.

answered Apr 5, 2023 at 11:47

yusuf

1

2 Comments

Standin.Wolf Over a year ago

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

KPC · Accepted Answer · 2023-07-05 05:55:49Z

0

I solved this issue using NULLIF to replace '' with NULL.

NULLIF(floor(cv.new_vaccinations), '') as new_vaccinations

sum(NULLIF(cv.new_vaccinations, '')) over (partition by cd.location order by cd.location, cd.date) as RollingPeopleVaccinated

edited Jul 5, 2023 at 5:55

answered Jul 5, 2023 at 4:44

KPC

971 silver badge7 bronze badges

Collectives™ on Stack Overflow

Mysql workbench Error code: 1292. Truncated incorrect INTEGER value:''

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related