# \[phpMyAdmin, MySQL\] - When you create a new index, does existing data copy over?

**URL:** <https://forum.kirupa.com/t/phpmyadmin-mysql-when-you-create-a-new-index-does-existing-data-copy-over/194638>\
**Category:** programming\
**Created:** [July 25, 2006, 7:08am UTC](https://forum.kirupa.com/t/phpmyadmin-mysql-when-you-create-a-new-index-does-existing-data-copy-over/194638 "2006-07-25T07:08:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![redrum87](https://avatars.discourse-cdn.com/v4/letter/r/f04885/32.png) [@redrum87](https://forum.kirupa.com/u/redrum87)\
**Post date:** [July 25, 2006, 7:08am UTC](https://forum.kirupa.com/t/phpmyadmin-mysql-when-you-create-a-new-index-does-existing-data-copy-over/194638/1 "2006-07-25T07:08:27Z")

</div>

This is a simple question to answer, but a little bit too complex to be Googled…

If I have existing data in a MySQL table, and I create a new index for that table in phpMyAdmin, does the existing data get inserted into the new index (besides any data that is added after the index is created)?

Thanks in advance.