PDA

View Full Version : character_ table help


xSigmax
10-28-2002, 12:51 PM
Ok im in MySQLServer, I just don't know how to properly remove the whole character_ table!

I pressed the delete key and nothing happened so i'm asking on here to make sure i dont fux everything up...

Thanks alot
Sigma

Lurker_005
10-28-2002, 01:21 PM
This involves dos commands

open a dow (command prompt) window
c:>
go to your mysql dir
c:> cd /mysql/bin
run mysql
c:/mysql/bin> mysql.exe
make the EQ DB active
mysql> use eq;
delete all data from the character_ table
mysql> delete from character_;
it shoud return that 0 or more rows were affected
then exit mysql and close the dos window
mysql> quit
c:/mysql/bin> exit