Sufyan

Get Size from Field of mysql

May 10th, 2016
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.36 KB | None | 0 0
  1. Particular Field Size in Bytes:
  2. ------------------------------
  3. SELECT sum(char_length(msg)) FROM `comments` WHERE id='4514653a-f0b3-11e5-ba3b-74867a3513db' ORDER BY `created` ASC
  4.  
  5. Particular Field Size in KB:
  6. ------------------------------
  7. SELECT sum(char_length(msg))/1024 FROM `comments` WHERE id='4514653a-f0b3-11e5-ba3b-74867a3513db' ORDER BY `created` ASC
Add Comment
Please, Sign In to add comment