# Quick SQL question

**URL:** <https://forum.kirupa.com/t/quick-sql-question/308374>\
**Category:** programming\
**Created:** [April 21, 2010, 6:58pm UTC](https://forum.kirupa.com/t/quick-sql-question/308374 "2010-04-21T18:58:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![45\_ACP](https://avatars.discourse-cdn.com/v4/letter/4/c4cdca/32.png) [@45\_ACP](https://forum.kirupa.com/u/45_ACP)\
**Post date:** [April 21, 2010, 6:58pm UTC](https://forum.kirupa.com/t/quick-sql-question/308374/1 "2010-04-21T18:58:57Z")

</div>

Hi,

Is there any way to take an entire table’s contents and insert it into another table without inserting row by row? Can I create a copy of a table with SQL? The idea is to automatically create a backup.

Thanks!

-45