SQL Server
This program should implement a SQL interpreter that is able to get SQL commands from a Telnet connection and send back its results also through the same Telnet connection. The server must be able to handle more than one client at the same time.
The server has to implement, at least, the following SQL commands:
CREATE TABLE table_name (
col_name <type>,
. . .)
DROP TABLE table_name
INSERT INTO table_namcol_name1, col_name2, ...)
VALUES (value1, value2, ...)
DELETE FROM table_name WHERE col_name <operator> value
[ AND|OR col_name <operator> value ]
SELECT FROM table_name WHERE col_name <operator> value
[ AND|OR col_name <operator> value ]
<type> can be: string.
<operator> can be: =.For more information about SQL syntax see an IBM SQL guide <http://ts.adm.ilstu.edu/cgi-bin/bookmgr/bookmgr.cmd/BOOKS/DSNAP0B2/1.2>.
NOTE: The program must use shared memory and threads in its implementation (take care to protected shared memory areas with mutex and/or semaphores). The tables are visible for all users. The program does not need to keep information on files, it does not have to be persistent.