fSQL Features
This tutorial will provide a brief list of supported fSQL queries and functions.
fSQL was originally designed based on mySQL so most of its syntax, features,
and functions were designed after mySQL's. In the future, fSQL will have a complete
set of docs detailing in the supported features but for now, this will be a good
starting point.
I. Supported Queries
- ALTER TABLE
- BACKUP TABLE
- BEGIN
- COMMIT
- CREATE TABLE
- DELETE
- DROP DATABASE
- DROP TABLE
- INSERT
- LOCK TABLES
- RENAME TABLE
- REPLACE
- RESTORE TABLE
- ROLLBACK
- SELECT
- SHOW DATABASES
- SHOW TABLES
- START TRANSACTION
- TRUNCATE
- UNLOCK TABLES
- UPDATE
- USE
II. Supported Functions
- abs
- acos
- asin
- atan2
- atan
- ceil
- ceiling
- concat
- concat_ws
- conv
- cos
- count
- crc32
- curdate
- curtime
- database
- dayofweek
- dayofyear
- degrees
- elt
- exp
- floor
- format
- from_unixtime
- last_insert_id
- left
- length
- ln
- locate
- log
- log2
- log10
- lower
- lpad
- ltrim
- max
- md5
- min
- mod
- now
- pi
- pow
- power
- quote
- radians
- rand
- repeat
- replace
- reverse
- right
- round
- row_count
- rpad
- rtrim
- sha
- sha1
- sign
- sin
- soundex
- sqrt
- strcmp
- substring
- substring_index
- sum
- tan
- truncate
- unix_timestamp
- upper
- weekday
