XML, JSON and Protocol Buffers based RDBMS that supports SQL syntax with JDBC API implementation.
CREATE DATABASE dbname;CREATE TABLE table_name (column_name1 data_type, column_name2 data_type);
DROP TABLE table_name;DROP DATABASE database_name;
INSERT INTO table_name (ID,Name) VALUES (1,'Ahmed');INSERT INTO table_name VALUES (1,'Ahmed', ...);
SELECT col1, col2, col3 FROM table_name WHERE col1!='value';SELECT * FROM table_name WHERE TRUE;SELECT * FROM table_name where col1 <= col2;SELECT * FROM table_name where ID == 6;SELECT * FROM table_name order by col1 ASC;SELECT * FROM table_name order by col2 DESC;SELECT * FROM table_name order by Name DESC where Name < 'S';SELECT DISTINCT City FROM Customers;
DELETE FROM table_name WHERE some_column=some_value;DELETE FROM table_name; // delete all rows but keeps the tableDELETE * FROM table_name; // same as above
UPDATE table_name SET column1='value1',column2='value2' WHERE some_column='some_value'; // with conditionUPDATE tableName SET columnName='someValue', columnName='someValue'; // with no condition
ALTER TABLE table_name ADD column_name datatypeALTER TABLE table_name DROP COLUMN column_name
SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2;SELECT column_name(s) FROM table1 UNION ALL SELECT column_name(s) FROM table2;SELECT city FROM Customers UNION all SELECT city FROM Suppliers union select city from City ORDER BY City;
This project is public, feel free to create pull requests or open issues.
