SQLEditor works only with the structure of the database, it cannot edit individual records within the database.
For example, a dog database has a table called dogs which lists individual animals.
This is the structure:
CREATE TABLE `dogs` ( `id` INTEGER AUTO_INCREMENT , `name` VARCHAR(255), `breed` VARCHAR(255), PRIMARY KEY (`id`) );
This is the data in the dogs table:
You might then want to add a new dog to the table, Fifi:
Unfortunately SQLEditor cannot do this, you would need to use a different tool.
However if the ages of the dogs became important and you wanted to modify the dogs table to include a new field age to the table then SQLEditor can help.
CREATE TABLE `dogs` ( `id` INTEGER AUTO_INCREMENT , `name` VARCHAR(255), `breed` VARCHAR(255), `age` INTEGER, PRIMARY KEY (`id`) );
To contact us with a support issue please email: