MySQL. Quick tips

# Open MySQL:
mysql -u root -p
show databases;
use databasename;
show tables;
select * from tablename limit 100;

SHOW INDEX FROM yourtable;
DROP INDEX index_name ON table_name;

Data truncation error 1406 - Data too long for column …
SET @@global.sql_mode= '';