How truncate a table in MySQL that is using ManyToMany field

I have a table in MySQL which have a ManyToMany field and I want truncate the table, but when I try it, I obtain the following error:

ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint ...

I'm using Symfony with Doctrine but if it is possible, I'm interested in learn how to do it through console

class Project {

  /**
  * @ORM\ManyToMany(targetEntity="Shipping", mappedBy="projects")
  **/
  private $employee;
}

class Employee{

  /**
  * @ORM\ManyToMany(targetEntity="Product", inversedBy="employee")
  * @ORM\JoinTable(name="middle_table")
  **/
  protected $projects;
}

Solution

To truncate a table with a ManyToMany relationship, you'll need to temporarily disable foreign key checks, truncate the related tables, and then enable foreign key checks again. Since you want to do this through the console, you can follow these steps using MySQL commands:

SET FOREIGN_KEY_CHECKS = 0; -- Disable foreign key checking.
TRUNCATE TABLE forums;
TRUNCATE TABLE dates;
TRUNCATE TABLE remarks;
SET FOREIGN_KEY_CHECKS = 1; -- Enable foreign key checking.

Keep in mind that truncating tables will remove all data from the tables, so be careful when executing these commands. Make sure to backup your data if necessary.

If you're using Doctrine in Symfony, you can achieve the same result by executing raw SQL queries using the Doctrine connection. However, since you're interested in using the console, the above MySQL commands should work for your use case.