aonurdemir/mysql.md

Forked from jackblack369/mysql.md

Created September 19, 2019 13:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aonurdemir/b1f77606efc35f0afe57c28c0fc77ed1.js"></script>
Save aonurdemir/b1f77606efc35f0afe57c28c0fc77ed1 to your computer and use it in GitHub Desktop.

Download ZIP

[mysql] #mysql

Raw

mysql.md

the size of blob column

 A BLOB can be 65535 bytes (64 KB) maximum.
 If you need more consider using:
 a MEDIUMBLOB for 16777215 bytes (16 MB)
 a LONGBLOB for 4294967295 bytes (4 GB).

join sql
string convert to timstamp

SELECT STR_TO_DATE('2014-05-28 11:30:10','%Y-%m-%d %H:%i:%s');