Bra kommandon att kunna med MySQL

MySQL:

DELETE FROM temps where id =’10451′;

SHOW databases;
USE ha;
DESCRIBE temps;

CREATE DATABASES temps;

Outside MySQL:

mysql -u root -p -h localhost futelldus < data.sql