how to insert data in max id by using sql query

Question

I want to get the maximum id of row data. In my table first column is id then firstname. this is the sql command I used to get the max(id) of row data and insert firstname in max(id) row. but it is not working

<?PHP  $maxid=mysql_query("insert into test(firstname) values ('$sym') where id =max('id') ;?>

sir i have id's in ID column..and i want to insert firstname in max(id) row — nik, Dec 01 '16 at 07:48
possibly duplicate of http://stackoverflow.com/questions/2349993/how-to-add-a-where-clause-in-a-mysql-insert-statement — Naga, Dec 01 '16 at 07:51

Naga · Answer 1 · 2016-12-01T08:37:19.537

0

You can achieve your requirement in this way.

UPDATE test
   SET  firstname = '$sym'
 ORDER BY `id` DESC LIMIT 1;

edited Dec 01 '16 at 08:37

answered Dec 01 '16 at 08:11

Naga

2,190
3
16
21

i am not getting max(id) – nik Dec 01 '16 at 08:20
mysql_query("update disorder_symptom set sym_id='$sym' WHERE 'id' = (SELECT MAX(id) FROM disorder_symptom);"); – nik Dec 01 '16 at 08:25
i am getting error...........#1093 - You can't specify target table 'test' for update in FROM clause – nik Dec 01 '16 at 09:19

score 0 · Answer 2 · answered Dec 01 '16 at 13:24

0

UPDATE yourtable
   SET  firstname = '$sym'
 WHERE id in (SELECT max(id) from yourtable)

answered Dec 01 '16 at 13:24

jophab

5,356
14
41
60

how to insert data in max id by using sql query

2 Answers2