get into dos, (go to your start menu, click run, type cmd) then
using cd \ to get to ur C: directory then move tell you get to your
mysql directory then go to the bin folder in the mysql folder.
type: mysqldump databasename tablename>test.txt
this willl make a text.txt with all the information of the table.
edit it and find the place where the last column is and add the
code for an auto_increment. (remember to place a , after the last
column now since its not the last) then get into the mysql thingy
and type source test.txt.
if you want to drop the entire database instead of just a table
type this: mysqldump databasename>test.txt instead of the
above.
code for auto_increment to add to the test.txt
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
and for all u gurus 😃 plz look at this thread i started Sorting Tables in a database..
