Viking DML Examples

SQL Command (CRUD) Example DML statment Try It
Insert (Create) INSERT INTO ISSUES (USERS_userID, MACHINES_machineID, STATUSES_statusID, SOFTWARE_softwareID, summary, `description`, entryDate, errorMSG) VALUES (2, 3, 1, 6, 'Software sucks!', 'I can't get your dumb software to work right!!!', '2018-11-21 00:00:00','NA' ) Issue Entry
Select (Read) SELECT * FROM viewIssues order by issueID
(NOTE: This SELECT statement uses a view that combines multiple tables and denormalizes the resulting record set.)		 Show Open Issues

Update (Update)

 UPDATE ISSUES SET errorMSG = 'x80001015 - Windows error!' WHERE issueID = 10  
Summary:
 

 
Delete (Delete)

DELETE FROM ISSUES WHERE issueID = 16;
(This would delete the record with an issueID of 16.)

 You can't try this one!
Links:
New Issue Entry
Open Issues Report