jackblack369/mysql.md

Last active July 13, 2023 01:14

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/jackblack369/2f9dbe51f895e44c25aba3732979e4e8.js"></script>
Save jackblack369/2f9dbe51f895e44c25aba3732979e4e8 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');