Is there a way to fix corrupted table?

Have you worked with any other database before?

Actually, I have to submit Human Resources Management System assignment using mysql yesterday itself 😅

Nope, I’m beginner

Okay, This emoji is conveying something

It is NOT the syntax that is so hard to learn when you learn SQL.

snail crawling on the slope of Fuji

No

ಥ╭╮ಥ

Make the production right away

Then?

Okay

from this

The concept. Idea . Relational theory

Relax and submit – I’m pretty sure the teachers won’t check even if you select data from a different table

Okay can you DM me ready made data, Typing every detail of employee and things for HRMS is cumbersome

https://www.kaggle.com/rhuebner/human-resources-data-set

Thank you:)

Look into the logs. Search for errors.

You mean process list right?

You can’t do urgently things you don’t know how to do.

I mean MySQL error log files

you are right🙏

most probably you have this table corrupt.
And the solution for this is only drop the table and create it again, and fill it with data from the latest backup you have

First find what it is.

Have you gone through the logs?

I couldn’t find unfortunately

Detailed description and locations for these logs are documented. See if you can find them, and then analyze the errors

I think my data is corrupted, I’m trying to repair on phpmyadmin, is that make sense?

Can you fetch data from the table?

Can you use/have you tried using shell for inserting data instead of phpmyadmin?

Problem solved