title: Insert date into multiple table or create one table with more column and store at once
body: <p>Suppose I have several user tables i.e user_table1, user_table2, user_table3, user_table..... . I have created this because if I create single-user table, it will create approx 150 columns. So I separated it with fewer columns table. In user_table1 user_id is set to primary key and rest of the table I set user_id as a foreign key.</p>
  <p>user_table1</p>
  <pre><code> -------------------------------------------
  | user_id | column1 | column2 | column.....|
   -------------------------------------------
  |   1     | value 1 | value 2 | value .....|
   -------------------------------------------
  </code></pre>
  <p>user_table2</p>
  <pre><code> -----------------------------------------------
  | user_id(fk) | column1 | column2 | column.....|
   -----------------------------------------------
  |   1         | value 1 | value 2 | value .....|
   -----------------------------------------------
  </code></pre>
  <p>user_table3</p>
  <pre><code> -----------------------------------------------
  | user_id(fk) | column1 | column2 | column.....|
   -----------------------------------------------
      ------ ----- --------- ----- ------- -----
  </code></pre>
  <p>The first table is generally stored for login details and some other value when the user register. So my question is after registration when user edit their profile (profile details value will store into another table i.e  user_table2,  user_table3) how to insert to another table? Is this method is ok or I should create one table with 150 columns?</p>