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; ...

What you need I’ll use MySQL Working 6.3, which has drastically evolved from older versions of the tool. My instance of MySQL Workbench will connect to a MySQL database, housed on Ubuntu Server ...

Connect to the MySQL database. The following code connects to a database server named "myserver:"mysql_connect ('myserver', 'user', 'password') Retrieve a list of tables from the database.