table creation in mysql

Basic Commands of MySQL Server In Daily Use

Basic Commands of MySQL, In MySQL Server, 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.   

show processlist; 

With the above command, you can check which query is taking long time to execute.

Check Out: Solve MySQL Can’t Connect To Local MySQL Server Through Socket

First of all, check how many databases is present thereby command

show databases;  

Basic Commands of MySQL

Then Choose any database or make your own by command

create database server;

mysql basic commands

Check Out: Install MySQL 5.6 Database Server Using Repository In Linux

Now Use database by below command

use server;

mysql commands for database

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.

Check Out: How To Check Users In Mysql Database Server In Linux

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

Leave a Reply

avatar
  Subscribe  
Notify of