• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

VPS and Server

  • Home
  • Web Hosting
  • Dedicated Servers
  • vps hosting
You are here: Home / database / Very basics of MYSQL Commands

Very basics of MYSQL Commands

December 22, 2021 by VnS Leave a Comment

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;

Filed Under: database

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • Block IP range / port to access other server using Firewall CSF
  • Changing Hostname, root password in Ubuntu
  • Zip / unzip big folders / files linux | cPanel
  • Very basics of MYSQL Commands
  • Dumping / Restoring Large Mysql Databases

Copyright © 2025 | VPS & SERVER