SQL Commands

From Fundamental Ramen
Jump to navigation Jump to search

Common Operations

Functions

Postgres MariaDB SQLite
Today

Visiting

Postgres MariaDB SQLite
List tables 



show tables;



.tables




GRANT






Postgres
MariaDB




Today









SQLite 3





TODO
Command




yyyymmdd to yyyy-mm-dd



SELECT printf('%s-%s-%s',
  SUBSTR(trading_date,1,4),
  SUBSTR(trading_date,5,2),
  SUBSTR(trading_date,7,2)
) FROM short_sell WHERE trading_date='20190605';











Retrieved from "https://wiki.fundamental-ramen.com/index.php?title=SQL_Commands&oldid=2141"