SQL relational database system

2016年10月17日

1. Any complex mathematical expressions are available in SELECT parameters list.
For example,
SELECT (1+LOG10(SQRT(MyData+PI()/2)))/2 AS MyCalc FROM MyTable WHERE MyCalc>1.0
2. New field type 'autoint' in database tables. Good to add auto incremental unique integer data into autoint type fields of tables.
For example,
CREATE TABLE MyAuto (Col1 autoint, Col2 varchar)
INSERT INTO MyAuto VALUES ('','Name1')
INSERT INTO MyAuto VALUES ('','Name2')
INSERT INTO MyAuto VALUES ('','Name3')