Q:

mysql command to insert new rows between old rows

i have a table with much data in it.  the id is set as a primary with AUTO_INCREMENT function.  how can i insert a new row like 
INSERT INTO `medikamente`(`id`, `Augmentin`, `Ciproxin`, `Klacid`, `Voltaren`, `Seractil`, `Mexalen`, `Aspirin`, `Thomapyrin`, `Esomeprazol`, `Omeprazol`, `Nexium`, `Pantoloc`, `Guttalax`, `indikator`, `indikator2`) 
VALUES (NULL,'','','','','','','','','','','','','','','');

lets say between id 5 and id 6?  i don't want to change the id's manualy to have a free row between that id's.  how can i do that over an command?  
br

A:

You can get free place in id sequence by query:
UPDATE medikamente SET id = id + 1 WHERE id > 5 ORDER BY id DESC;

After you can use id 6 for insert new row:
INSERT INTO `medikamente`(
    `id`, `Augmentin`, `Ciproxin`, `Klacid`, `Voltaren`, `Seractil`, `Mexalen`, `Aspirin`, `Thomapyrin`, `Esomeprazol`, `Omeprazol`, `Nexium`, `Pantoloc`, `Guttalax`, `indikator`, `indikator2`
) VALUES (
    6,'','','','','','','','','','','','','','',''
);

Be carefully if you table have foreign keys.