Before creating tables in mysql, we have to create database.
command to create database
Command:-
CREATE DATABASE database_name;
Example:-
CREATE DATABASE naikgroup;
To use/choose/enter the database follow this command.
Command:-
USE database_name;
Example:-
USE naikgroup;
Here Naikgroup is database name.
Get list of database in mysql use this command
Syntax:-
SHOW DATABASES;
Note:-
# We can use any word as database name.
# Database name can be combination of Character and number but not number only.
# Number can be used as 1st digit in database name.
command to create database
Command:-
CREATE DATABASE database_name;
Example:-
CREATE DATABASE naikgroup;
To use/choose/enter the database follow this command.
Command:-
USE database_name;
Example:-
USE naikgroup;
Here Naikgroup is database name.
Get list of database in mysql use this command
Syntax:-
SHOW DATABASES;
Note:-
# We can use any word as database name.
# Database name can be combination of Character and number but not number only.
# Number can be used as 1st digit in database name.
I strongly believe that there will be great opportunities for those who looked into this area...
ReplyDeleteBest Online Software Training Institute | SQL Server Training
Wonderful article, very useful and well explanation. Your post is extremely incredible.
ReplyDeleteThis is a 2 good post. This post gives truly quality information.
ReplyDeleteRPA Training in Hyderabad
Thanks for sharing great information. If anyone looking for the online training mindmajix is the ultimate place to opt for.
ReplyDeletebest SQL Server Training
I really enjoyed your blog Thanks for sharing such an informative post.Looking For Some More Stuff.
ReplyDeletebest seo company in bangalore SSS digital Marketing
ReplyDeletenice post.......
apache solr resume sample
apache spark sample resume
application developer resume samples
application support engineer resume sample
asp dotnet mvc developer resume
asp net core developer resume
asp net developer resume samples
assistant accountant cv sample
assistant accountant resume
assistant accountant resume sample
Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
ReplyDeleteData Analytics Training in Gurgaon