title: MYSQL SQL Statement which insert many rows
body: <p>I want to put contents to notice Database user level > 1;</p>
  
  <p>so I tried this Statement</p>
  
  <pre><code>insert into test4 (id, content) values (
      (select user_id from account where user_rank&gt;=0), 
      'alert'
  );
  </code></pre>
  
  <p>But it keep saying Subquery returns more than 1 row.</p>
  
  <p>Is it impossible to put many rows in one statement?</p>
  
  <p>Thank you.</p>