At a guess - and it can only be a guess, since you haven't shown any of your code - you have used the wrong delimiters for the table and column names.
Your error message refers to both
insert into 'fy...
and
'fyp2' ('name','gender','age','health','absences','test1','test2')
, so it looks like you're putting single quotes (ASCII code 39,
') around the table and column names.
MySQL and MariaDB require that you use the backtick (ASCII code 96,
`) to quote names:
MySQL :: MySQL 8.0 Reference Manual :: 9.2 Schema Object Names[
^]
Fix your query to resolve the error.
insert into `fyp2` (`name`, `gender`, `age`, `health`, `absences`, `test1`, `test2`) ...