How to Create Database and Tables in MySql?
hi friends,
in previous sessions,we have seen
1)How to download and install mysql db software?
2)How to change default settings(text color,font style,background color,window size etc..)?
okay guys,
now I am going to show you
1)how to create database in mysql?
syntax:create database db_name
eg:create database company;
2)how to view existing databases in mysql?
syntax:show databases;
eg:we can get all databases already created
employ,company..
3)how to change database name in mysql?
syntax:use db_name
eg:use company;
database changed.
here I wanted to create tables in company db. so I entered to company db.
now we can create table in company db.
using below syntax;
4)how to create tables in mysql?
create table table_name(col1 datatype(size),col2 datatype(size) ,.......)
eg:create table product(pid int,pname varchar(20),price float);
next we can see
5)how to view structure of the table in mysql?
syntax:describe table_name
thats it.. guys
in next video sessions,we can see ddl,dml,dcl etc. commands....
thank u...
so please follow the steps as shown in the video...
please subscribe n share my channel
/ prasadamudalapalli