Append table with new information

[robin01]

Hello All,

2 mysql questions:
1. How do I append a table with new information.
2. how do I just replace the old information in the table with new information.

background information:
I purchased a web software and it installed successfully. I also purchased a zip code (zipcode.sql) to work within the area I live in. The zipcode.sql is formated to work with the software all i need to do is figure out how to append the table with the information provided in zipcode.sql (zipcode.sql is formated to work with the software)

I have MYSQL Administrator & Navicat mysql but i'm not sure how to use these tools to append even add whats in zipcode.sql as a new data into the table. currently the table zipcode is empty.
database MYSql.

any help you can provide would be greatly appreciated

r

[bpat1434]

Download and setup phpMyAdmin. Once in that, you can upload and run the SQL file. There's nothing more you need to do for the zipcode table if it's empty right now.

To update information, you need to use the UPDATE syntax. I'd get a good SQL for beginners book. I suggest O'Reilly's Learning SQL book 😉