title: How to add a foreign key column in the MySQL table?
body: <p>I have a table named <code>payment_request</code> in the MySQL and the </p>
  
  <p><code>DESCRIBE payment_request</code> provides the following output, </p>
  
  <p><a href="https://i.stack.imgur.com/hq0jb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hq0jb.png" alt="enter image description here"></a> </p>
  
  <p>The <code>oderbook</code> table is provided below, </p>
  
  <p><a href="https://i.stack.imgur.com/R8Ted.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/R8Ted.png" alt="enter image description here"></a></p>
  
  <p>I want to add the <code>id</code> from the <code>payment_request</code> table in the <code>orderbook</code> as the foreign key with the name as <code>payment_request_id</code> after the <code>id</code> column (2nd position).</p>
  
  <p>What will be the SQL to run the MySQL? </p>