MySQL CREATE Table

In this post we will learn how to create a table in MySQL. In last posts we learned how to create,use and drop a database. Now we will start learning operations for table. Syntax To create MySQL table we will need following information. Table name Column name Column destinations/types Example In this example we have …

MySQL CREATE Table Read More »

MySQL DELETE Database

In this post we will learn how to delete a database in MySQL. Some time we need to delete a database so we need to use this command. Syntax Example This command will delete the user_service database from your MySQL server. All the data and tables will be deleted and this cannot be recovered. So …

MySQL DELETE Database Read More »

MySQL SELECT Database

In this blog post we will learn how to select a database from list of databases to work on it. So to run command on database first you have to select that database on you MySQL server. Syntax Example This command will select user_service database. Now we can do operations on that database. To select …

MySQL SELECT Database Read More »

MySQL CREATE Database

In this post i will be explaining how to create a database using MySql. Syntax Example This will create a database named user_service. At this time our MySql server might have many databases. We can list all the databases using following command. If you have any doubts or suggestions then please comment below.