By Craig Cohen on Monday, 15 September 2014
Category: General

Casper: MySQL Commands to clear a Table

1. In Terminal.app, type the following:
mysql -u jamfsoftware -p

2. Default Password for “jamfsoftware” MySQL User: (Yours may vary)
jamfsw03

3. To view the current databases, type the following: 
show databases;

4. To view the jamfsoftware database, type the following: 
use jamfsoftware;

5. To view the jamfsoftware database tables, type the following: 
show tables;
6. The Truncate Table command, empties a table completely. 
TRUNCATE TABLE vpp_invitation_usage;