table creation in mysql

In Mysql Server  , I’m going to show you how to create user , create database and tables.

First of all check how many database is present there by command

Show databases;

Then Choose any database or make your own by command

Create database server;

Now Use database by

Use server;

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 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.

 

Sponsored

LEAVE A REPLY

Please enter your comment!
Please enter your name here