Create, update, delete, and query from skills table
Table Specific Information
Following is an example to select all entries from Skills table:
SELECT * FROM Skills
You can also select a specific entry from Skills table:
SELECT * FROM Skills WHERE Id = 73000001322
Name is mandatory for creating a new skill. Following is an example of creating a new skill:
INSERT INTO Skills (Name) Values ('Example')
Following is an example of how to update a skill:
UPDATE Skills SET Name = 'New name' WHERE Id = 73000001322
Following is an example of how to delete from Skills table:
DELETE FROM Skills WHERE Id = 73000001322
ID of the skill.
Name of the skill.
Position/Rank of the skill.
Agents associated with the skill.
Match type for conditions.
Conditions of the skill.
Skills creation timestamp.
Skills updated timestamp.