MySQL Server basic commands, I’m going to show you how to create users, create databases and tables. These are the MySQL daily use commands with these commands we can manage the little tasks on the servers. you can also check a number of processes are running on the servers using the below command.
With the above command, you can check which query is taking a long time to execute.
MySQL Server Basic Commands In Daily Use On CentOS 7:
First of all, check how many databases is present thereby command
Then Choose any database or you can create your database as well.
create database server;
Now Use database by below command
Now try to create a table
CREATE TABLE cus_abl(
cus_ids INT NOT NULL AUTO_INCREMENT,
cus_ftname VARCHAR(100) NOT NULL,
cus_srname VARCHAR(100) NOT NULL,
PRIMARY KEY ( cus_ids )
Now the table has been created.
You can see what’s inside the tables it will empty as we did not assign any values.
You’re done. mysql commands for database create table