I can extract data from my database to my table but everytime I update the database, I will have to create a new table and import all of my old scripts. How do I automatically update the table rather than redo everything?
Are you using JMP12? If so then you can just use the "Update From Database" script that is placed in the data table by the query builder.
Oh dear. Looking at Update a table from a database ? It seems like this is only possible with JMP 12.1. I am using JMP 10
Indeed! Query Builder is a new feature in JMP12 which came out earlier this year. There are a lot of good reasons to upgrade to JMP12. You should talk to your site admin about getting upgraded.