Ben MySQL için yeni bir sorun var. Onun php ile ilgili de sanırım.

I have a table, ID,CODE,string1,string2,string3,string4,string5,string6,string7

now, each customer has a unique code. Each code can store a maximum of 7 strings in their "list".
PROBLEM - if the customer adds a new item or items (important!) to their list and their list is already full, then the list should push out the oldest string and add the new strings to the end.

So say, string 1 to 7 are filled with text t1 to t7. then customer wants to add new items t8 and t9, I need to delete t1 and t2, move everything down 2 spaces and add t8 where t6 was and t9 where t7 was (at the beginning). This is easy to do in java or normal programming, but how can I do this quickly and easily and efficiently in mysql/php code?

Bu mümkün mü? Bu mysql şeyler yapmak için doğru yolu nedir? Daha iyi bir yolu var mı? üzgünüm