title: row order when inserting multplie rows in MySQL
body: <p>In PHP, I create and execute SQL queries like the following.</p>
  
  <p><code>INSERT INTO Table (Column1, Column2, Column3) VALUES<br>
  ('1', '2', '3'),<br>
  ('A', 'B', 'C'),<br>
  ('AA', 'BB', 'CC');</code></p>
  
  <p>However, the order in which they are inserted into the database is different every time I try this.  Is there a way that I can ensure that they are inserted in the order they are listed?</p>
  
  <p>Addition: 
  Thanks guys for the help.  I have using PHP to create MySQL tables from CSV files for a while.  In the past, I have always used created a table and inserted all the rows all at once.  In these case, the SQL table always had the same order as my INSERT query.  However, now I am creating a MySQL and then adding contents gradually.  This is when the database order becomes random.</p>
  
  <p>I have overcome this by using ALTER TABLE ... ORDER BY queries, but I am curious as there was order in the first case and now it seems very random.</p>