CREATE TABLE folders ( id INT NOT NULL DEFAULT 0, name VARCHAR(255), parentid INT, PRIMARY KEY (id), FOREIGN KEY (parentid) REFERENCES folders(id) ON DELETE CASCADE ) ENGINE=InnoDB; More options ...

The MySQL Workbench main window. How to create tables and add data to MySQL database with MySQL Workbench Your email has been sent The MySQL Workbench GUI is cross-platform, open source, and ...

Right-click the PHP file you want to use to identify the existing table. Click "Open With" and select your PHP editor. Connect to the MySQL database.