title: Is that a good practice to put several longtext into a same table mysql?
body: <p>I am creating a mysql table which contain several longtext rows. I am expecting a lot of users enter a lot of texts. Should I split them into different table individually or just put them together in one table? I concern about the speed, will that affect the speed when I query the result, how about if I want to transfer the data on the future? I am using InnoDB, or should I use Myisam?</p>
  
  <pre><code>CREATE TABLE MyGuests (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    diet longtext NOT NULL,
    run longtext NOT NULL,
    faith longtext,
    apple longtext
  );
  </code></pre>