title: MYSQL is not saving data in database even after successful execution message
body: <p>i am new to MYSQL and using workbench 6.1.
  I have created a database and 10 tables. It was working fine. Accidently I deleted one table. Problem started after I recreated the table. Now, even if I try to load data from csv file or insert data in it, it gives me successful 397 rows affected.
  when I do select * from table_name it displays the data.
  But when I reconnect the database and perform select * from table_name, it has no data in it.</p>
  
  <p>please help me..m not able to find anything related to this online.</p>