SQL machinations

Submitted by aufumy on Mon, 2007-07-30 23:00

Recently, when performing a slew of alter table statements, I had to do some checking to verify, that I had not completely destroyed my database.

From unix commandline
$ mysqlshow --status my_table

From mysql commandline
> SHOW TABLE STATUS FROM my_database;
> FLUSH TABLES;
> SHOW INDEX FROM my_table;
> ANALYZE TABLE my_table;
> CHECK TABLE my_table;
> OPTIMIZE TABLE my_table;
> DESCRIBE my_table

Thanks..

Submitted by Anonymous on Fri, 2011-12-09 01:27.

Thanks for your information .. :)
Software Akuntansi