SQL Commands: Difference between revisions
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
|- | |- | ||
| List tables | | List tables | ||
| < | | <pre></pre> | ||
| < | | <pre>show tables;</pre> | ||
| < | | <pre></pre> | ||
|} | |} | ||
Revision as of 07:35, 8 April 2025
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';
|