Skip to content

Instantly share code, notes, and snippets.

@aonurdemir

aonurdemir/mysql.md

Forked from jackblack369/mysql.md
Created September 19, 2019 13:37
Show Gist options
  • Save aonurdemir/b1f77606efc35f0afe57c28c0fc77ed1 to your computer and use it in GitHub Desktop.
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');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment