Got it

The Series of MySQL -4- MySQL User Management - EP 04_02

Latest reply: May 21, 2022 08:37:23 494 18 11 0 0

The Series of MySQL -4- MySQL User Management - EP 04_02


HI Hi, Greetings!  i_f47.gif

Happy February i_f25.gif


Hi Everyone,


Today, I would like to share with you an article about the fourth episode of Series of MySQL (MySQL Database), and the content is given below.


a.    Create Database

b.   Select Database

c.    Show Databases

d.   Drop Database

e.   Copy Database 


Select Database

 

The SELECT Database command in MySQL is used to select a database to work with. This query is used when MySQL Server supports multiple databases.

 

To select a specific database, use the SQL statement "USE."

 

Syntax:

USE database_name; 

 

Example:

Let's use the database name "empdb" as an example.

 

USE empdb;

 

It will seem as follows:


12


You are welcome to like and leave feedback in the comment area.


Link:


EP 03_01:

The Series of MySQL - 4 - MySQL User Management - EP 04_01




EP 03_03:


EP 03_04:


EP 03_05:

Source:

  • https://www.w3schools.com/mySQl/default.asp

  • https://www.mysqltutorial.org/mysql-basics/



M M Zaheer Hussain

Stay Safe!

tt


The post is synchronized to: Author groupzaheernew's Author Collection

  • x
  • convention:

zaheernew
MVE Author Created Feb 18, 2022 09:56:23

  • x
  • convention:

andersoncf1
andersoncf1 Created Feb 19, 2022 16:13:08 (0) (0)
 
wissal
wissal Created Feb 27, 2022 16:19:10 (0) (0)
Thank you, my friend  
zaheernew
zaheernew Created Feb 27, 2022 17:36:35 (0) (0)
Awesome guys  
Rumana
Created Feb 18, 2022 10:28:51

simple & excellent post
View more
  • x
  • convention:

Unicef
MVE Created Feb 18, 2022 11:59:30

WELL DONE
View more
  • x
  • convention:

zaheernew
zaheernew Created Feb 20, 2022 09:55:09 (0) (0)
Fantastic  
Saqib123
Moderator Created Feb 19, 2022 11:41:36

Thanks for sharing
View more
  • x
  • convention:

zaheernew
zaheernew Created Feb 27, 2022 17:40:38 (0) (0)
Awesome  
andersoncf1
MVE Author Created Feb 19, 2022 16:13:28

Well! Thank you
View more
  • x
  • convention:

zaheernew
zaheernew Created Feb 27, 2022 17:40:32 (0) (0)
Awesome  
Zonger
Moderator Created Feb 20, 2022 08:33:07

useful share
View more
  • x
  • convention:

MahMush
Moderator Author Created Feb 21, 2022 06:43:12

excellent
View more
  • x
  • convention:

zaheernew
zaheernew Created Feb 27, 2022 17:40:21 (0) (0)
Awesome  
Saqibaz
Created Feb 23, 2022 19:14:52

Thanks useful
View more
  • x
  • convention:

wissal
MVE Created Feb 27, 2022 16:19:28

Interesting content
View more
  • x
  • convention:

zaheernew
zaheernew Created Feb 27, 2022 17:37:27 (0) (0)
Awesome  
12
Back to list

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.