title: MySQL Inserting data from one table to another - error FULLTEXT index
body: <p>Hey guys i'm trying to create a stored procedure where I enter in the Loan_ID from my loan_table and it moves it into another table called loan_history. I'm unsure on what I'm doing wrong. The error I'm getting is 'Can't Find FULLTEXT index matching the column list' </p>
  
  <pre><code>CREATE PROCEDURE `INSERT_INTO_lOAN_HISTORY`(in INSERT_LOAN_ID INT(11))
  INSERT into loan_history
  SELECT  *
  FROM `loan_table`
  Where MATCH (LOAN_ID) AGAINST (INSERT_LOAN_ID)
  </code></pre>
  
  <h2>Schema</h2>
  
  <pre><code>CREATE TABLE loan_table 
  ( Loan_ID int(11) NOT NULL AUTO_INCREMENT, 
  Member_ID int(11) DEFAULT NULL, 
  Item_ID int(11) DEFAULT NULL, 
  Book_ID varchar(45) DEFAULT NULL, 
  Video_ID varchar(45) DEFAULT NULL, 
  Transaction_Date date DEFAULT NULL, 
  Due_date date DEFAULT NULL,
  etc
  </code></pre>