SQL Observer
save
reset
share
Tables
show/hide sample
books
(TABLE)
id
:
INT UNSIGNED (10)
title
:
VARCHAR (200)
author
:
VARCHAR (40)
publisher
:
INT UNSIGNED (10)
SQL
Table View
This version of "SQL Observer" allows user to select which field of the table should be displayed as the result. This version is case sensetive, so all directives MUST be in lower case. Also "SQL Observer" can display all the data using usual syntax as follow: select * from students Keep in mind that due to restrictions of task user can operate only with "students" table, attempts to use other tables will be denied. Try this examples: select * from students select StudentID, LastName, FirstName from students select LastName, DP, StartYear from students select LastName, City from students
Result