insert same Value Probelm!!

[harris97]

well. i'd like to insert same value to two fields in one table, like this:
NAME_ID | FILE_ID
0 | 0
1 | 1

i set name_id as an auto_increment. So..how to insert the same value to FILE_ID as inserted in NAME_ID (in PHP coding such as INSERT into mytable (NAME_ID, FILE_ID)...etc?

[jariizumi]

First of all, I don't see any good reason why this can't be done another way... IMHO, you should probably avoid the redundancy by reusing NAME_ID instead of providing an exact copy. But that's just me...