title: How to show image in table using mysql command line
body: <p>I have tried to show photo in MySQL command line, but always unable to do. Although I can retrieve photo using <em>JDBC</em>.</p>
  
  <p>I am beginner to learn <em>JDBC</em> using MySQL, so, please help me by giving answer.mysql code are given below  </p>
  
  <blockquote>
    <p><strong><code>create database image;</code><br>
         <code>use image;</code><br>
         <code>create table imgtable(photo,BLOB);</code><br>
         <code>insert into imgtable(photo) values(LOAD_FILE('D:\\pic.png'));</code><br>
        <code>select *from imgtable</code>;</strong></p>
  </blockquote>
  
  <p>I cannot find storage photo in <em>imgtable</em>, only show garbage. But why it occur like this, actually is it not possible to show in table. Please suggest a way.</p>
  
  <p>Thank you.</p>