I simply selected the records I wanted to copy and used the “Copy as SQL INSERT” feature. At this point I found a really neat and helpful feature in Sequel Pro: Copy as SQL INSERT Using mysqldump was another option but that seemed like overkill in this case-I only needed to copy a few records from a single table. I tried using the “SELECT…INTO OUTFILE” method but ran into a permissions issue with that approach. I recently needed a way to copy a few dozen records from one camp to another. I also find it very useful for making small changes to the data while I develop and test web apps. It’s a free OS X application that lets you inspect and manage MySQL databases. It means that the values in the task_id column will uniquely identify rows in the table.I often use Sequel Pro when I’m getting up to speed on the data model for a project or when I just want to debug in a more visual way than with the mysql command-line client. The task_id is the primary key column of the tasks table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |