jackblack369
12/28/2018 - 9:20 AM

[mysql] #mysql

[mysql] #mysql

mysql.md
content_copyfile_download
  • Rendered
  • Source

  • 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');