SQL Commands

From Fundamental Ramen
Revision as of 07:36, 8 April 2025 by Tacoball (talk | contribs)
Jump to navigation Jump to search

Common Operations

Functions

Postgres MariaDB SQLite
List tables

Visiting

Postgres MariaDB SQLite
List tables 



show tables;







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=2052"