Data vs Structure

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:

dogs table (see following SQL)

CREATE TABLE `dogs`
(
`id` INTEGER AUTO_INCREMENT ,
`name` VARCHAR(255),
`breed` VARCHAR(255),
PRIMARY KEY (`id`)
);

This is the data in the dogs table:

id name breed
1 Fido Collie
2 Beethoven St. Bernard

You might then want to add a new dog to the table, Fifi:

3 Fifi Poodle

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.

dogs table (see following SQL)

CREATE TABLE `dogs`
(
`id` INTEGER AUTO_INCREMENT ,
`name` VARCHAR(255),
`breed` VARCHAR(255),
`age` INTEGER,
PRIMARY KEY (`id`)
);

Support Updates


Contact Us

To contact us with a support issue please email:

support@malcolmhardie.com