ID: atabase.complex
Version: 1.47
Size: 0 Mb
SQL relational database system Screen Preview
SQL relational database system Details
If you use Android 6 Marshmallow, enable memory access permission manually for this appplication to run in task manager mode, please! Otherwise this application can't run normally in Marshmallow. No problems to run in other Android OS. SQL RDBMS (ATABASE), the SQL relational database management system complex application for Android OS provides the next: - Creating any simple or complex relational dabases - Renaming or delete databases - Runing any simple or very complex SQL queries - Calculation any complex mathematical expressions in SELECT queries - Creating VIEWs in databases by any SQL SELECT queries - Browsing any table of a database as a table form - Browsing any VIEW of a database as a table form - Backuping and restoring any database - Importing CSV files into new tables in a database (Windows 1251 code page for now) - Exporting tables of databases as CSV files (Windows 1251 code page for now) - Checking out any databases structure (tables and VIEWs) - Checking out any tables structures in any databases - Checking out SQL SELECT queries content of any VIEW - SQL queries templates list provided for quick learn SQL and to try - SQL Script Master mode to run any SQL script file and check the execute result list - SQL queries constructor mode to simplify the design SQL queries process - Up to 100 last successfull SQL commands save list to retry and memory - Scripting database modes to script database structure, data of a database or database in whole - Primary key consdtraint check for all data types - SQL join RELATIONAL ALGEBRA for join tables on all types of colums data - Reporting and sharing reports created of VIEWs data sets - Creating charts of VIEWs numeric data sets for visual qualitative representation - Creating normalized data BAR,GRAPH and PIE charts of any numeric column data of a VIEW. - TIME and DATE types components in WHERE logical expressions use. - Multi level ordering feature for all types of columns and for any component of DATE and TIME types. - Multi level grouping feature for all types of columns and for any component of DATE and TIME types - Unusual use of universal function LIKE in WHERE logical expressions. See WEB site for explanations. Data types supported in columns of tables are: int - integer pkint - integer with primary key constraint check numeric - real number (with dot) pknumeric - real number (with dot) with primary key constraint check varchar - any string data as 'This is string data' pkvarchar - any string data with primary key constraint check date - date like 'yyyy.mm.dd', 'yyyy/mm/dd', 'yyyy-mm-dd' where yyyy - year, mm - month, dd - day number pkdate - date with primary key constraint check time - time as 'hh:mm:ss' where hh - hour, mm - minute, ss - second pktime - time with primary key constraint check picture - same as varchar with '.jpg', '.png', '.bmp' at the end of string like 'Picture1.jpg' pkpicture - picture with primary key constraint check Primary key constraint check for column of a table is check for uniqueness of data for that column in the table. That rule is for every column with primary key constraint check but not for column data combinations constraint chect if two or more colums have primary key constraint in this application. Mathematical functions available are: PI() - pi number E() - e number RANDOM() - random number ASIN() - arc sinus ASIN() - arc cosinus\ ATAN() - arc tangent SIN() - sinus COS() - cosinus TAN() - tangent CBRT() - cubic root SQRT() - square root exp2() - square exponent exp() - natural exponent log10() - base 10 logarithm log() - natural logarithm abs() - absolute value degrees() - convertion into degreess radioans() - convertion into radians rint() - round into integer round() - round double presision number ceil() - truncate into whole integer floor() - truncate sign() - convert double presision natural number into integer 1 with a signWhat's new in SQL relational database system 1.47
Create SQL relational databases in your own smartphone! Any complex mathematical expressions in SQL SELECT or UPDATE for numeric type fields are available now! Use table fields as arguments in any mathematical funvction in your expressions. For example, SELECT (1+LOG10(SQRT(MyData+PI()/2)))/2 AS MyCalc FROM MyTable WHERE MyCalc>1.0 UPDATE MyTable SET MyField1=SQRT(SIN(Field2+pi()/2))+1Download SQL relational database system 1.47 APK
Search terms:
SQL relational database system for pc
SQL relational database system mod apk
SQL relational database system full version
SQL relational database system full data