PHP项目在wampserver中使用mysql数据库

Question

When I am importing my database it displayed me this error:

#1452 - Cannot add or update a child row: a foreign key constraint fails (`clearancesystem`.<result 2 when explaining filename '#sql-2744_e'>, CONSTRAINT `useraccount_ibfk_1` FOREIGN KEY (`SIDNO`) REFERENCES `student` (`SIDNO`))

Answer 1

Disable foreign key constraints before starting the import process.

See here how to do it by command or GUI