MySQL Commands Cheat Sheet

Another memory-dump. The manual contains more information (that’s a surprise :-). mysql> delete from TABLE where id=X Removes the specified row mysql> describe TABLE; Shows the structure of the specified table mysql> select * from TABLE; Shows all rows in the specified table :-O mysql> show procedure status; Shows stored procedures mysql> show table status; […]