I have a general how-to question. I need to populate a database with information stored on a separate database. I have never done this before and I would like to know the process that is usually used. A little information concerning the databases. My database is set up through phpMyAdmin. The database that holds the information I need belongs to a program called SchoolTool. They are going to send me a query that gets the information I need from their end, but I don't know what I should run it in to collect the information.
Another related question. I am dealing with 6 digit IDs and many of them have leading zeros that are not stored in the schooltool database. Is there a way to add zeros to their ID's if they are not 6 digits? And speaking of the zeros...I think phpmyadmin might cut off any leading zeros, is there a way to prevent this from happening?