For converting from root to mysql server
mysql -u root -p
enter mysql pass
later to get into one db
use database_name;
later you can change db tabel name as
ALTER TABLE name_old RENAME name_new;
or drop a table like
DROP TABLE table1;
or
DROP TABLE IF EXISTS table1;
to drop multiple tables
DROP TABLE IF EXISTS table1, table2, table3;
Leave a Reply