Something About Me and All Blogging Tools

About This Blog.

All blogging tools  is an experimental blog. The purpose of this blog is to share the things that I learn on my journey to blogging, social media, and web technologies. I do not claim an expert of anything. Tips and advice shared here is what I have found from various other resources. I have explained these tips and advice in my own words.

MySQL Commands and Uses

mysql > drop database abc;

This command will delete the database by name abc, if its already present.

mysql > create database abc;

This MySQL command creates a new database by name abc.

mysql > use abc;

After creating the database abc, we must tell the console that we want to operate on the newly created database. i.e., use abc;

mysql > create table bbc(name varchar(15), company varchar(20));

This MySQL command is used to create a table by name bbc with two string type data fields name and company with character length of 15 and 20 respectively.

mysql > desc bbc;