Mysql::Select ข้อมูลให้มี Auto Increment

เพื่อใช้เป็น Primary Key ไว้ Replace 

REPLACE INTO mb_HbA1c
 SELECT * FROM (
SELECT (@cnt := @cnt + 1) AS ID, a.VISIT_ID, b.HN ,DATE_FORMAT(a.LREQ_DT,'%Y-%m-%d') AS DATE_SERV , LAB_RESULT,SUBSTR(a.lab_result,7,4) as A1c, a.STAFF_ID, d.TOWN_ID,
 FLOOR(DATEDIFF(NOW() ,d.BIRTHDATE)/365.25)  AS AGE,

SELECT
    (@cnt := @cnt + 1) AS rowNumber,
    t.rowID
FROM myTable AS t
  CROSS JOIN (SELECT @cnt := 0) AS dummy
WHERE t.CategoryID = 1
ORDER BY t.rowID ;

Result
| ROWNUMBER | ROWID |
---------------------
|         1 |     1 |
|         2 |    25 |
|         3 |    33 |
|         4 |   150 |