SQL

test sql query

-- Test SQL queries online: use a fiddle:
http://sqlfiddle.com/

Example SQL Test

12345678910111213141516
CREATE TABLE tests(id INTEGER PRIMARY KEY,server_name TEXT NOT NULL,server_port INTEGER);INSERT INTO tests VALUES (99123, "server_test1", 99321);INSERT INTO tests VALUES (99423, "server_test2", 99313);INSERT INTO tests VALUES (99763, "server_test3", 99333);INSERT INTO tests VALUES (99913, "server_test4", 99666);SELECT * FROM tests WHERE server_port = 99321;SELECT * FROM tests WHERE server_port = 99333;SELECT * FROM tests WHERE server_port = 99666;