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:

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.

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