Customers from other countries

[wmorris]

There are 3 ways to "get rid of all records in a table":

a) manually delete all records. But this doesn't also reset the "id autoincrement counter"
b) TRUNCATE the table (TRUNCATE is the SQL statement, like INSERT is a SQL statement). This wipes the table empty and resets the autoincrement counter, giving the table and indexes a clean slate.
c) drop the table and recreate it; but this requires knowing how to recreate the table. But it does also give a clean slate.

In PhpMyAdmin you can truncate a table by listing all tables and clicking the "Empty" button beside the table you wish to truncate.
Be aware that this deletes EVERYTHING in the table.

Well they finally all got back into the database. So right now I am hitting the green buttons and make sure its red for other countries.