title: Insert Boolean Value through variable using Bash Script into MySql
body: <p>I am trying to insert a boolean value which i have stored into some variable and trying to pass it in INSERT query . I am using bash script for this purpose. </p>
  
  <p><strong>The Script</strong></p>
  
  <pre><code>#!/bin/bash -X
  #fields:  id|alias|booking_time|contact_no|deleted|grace|number_in_queue|pax|seated_time|status|walk_in_time|queue_id|user_id 
  
  _alias="Success"
  _contact_no=43456789876
  _deleted="FALSE"
  _number_in_queue=4
  _pax=5
  _status="waiting"
  _queue_id=424
  _user_id=550
  
  mysql -u root -p &lt;databasename&gt; &lt;&lt; EOF
  INSERT INTO queue_item  VALUES ('','$_alias',now(),'$_contact_no','$_deleted',NULL,'$_number_in_queue','$_pax',now(),'$_status',now(),'$_queue_id','$_user_id');
  EOF
  echo "Completed"
  </code></pre>
  
  <p>I am getting some garbage value in that field. </p>