Skip to main content

Posts

World Nomads Logo

How to Select Database for use and Drop Database in MySQL?

How to create Database in MySQL?

How to select to use & drop DB in MySQL

MySQL SELECT Database SELECT Database is used in MySQL to select a particular database to work with. This query is used when multiple databases are available with MySQL Server. You can use SQL command USE to select a particular database. Syntax: USE database_name; Example: Let's take an example to use a database name "customers". USE customers; MySQL Drop Database You can drop/delete/remove a MySQL database easily with the MySQL command. You should be careful while deleting any database because you will lose your all the data available in your database. Syntax: DROP DATABASE database_name; Example: Let's take an example to drop a database name "employees" Subscribe channel on  YouTube Read this post on  Blogger Like page on  Facebook Tweet about video on  twitter Let's chat on  whatsapp See you at  Instagram Google +

How to create Database?

MySQL Create Database You can create a MySQL database by using MySQL Command Line Client. Open the MySQL console and write down password, if you set one while installation. Now you are ready to create database. Syntax: CREATE DATABASE database_name;  Example: Let's take an example to create a database name "employees" CREATE DATABASE employees;  You can check the created database by the following query: SHOW DATABASES;  By this, you can see the all created databases. Subscribe channel on  YouTube Read this post on  Blogger Like page on  Facebook Tweet about video on  twitter Let's chat on  whatsapp See you at  Instagram Google +

कंप्यूटर साइंस क्विज - 14 - MP PATWARI QUESTION ANSWERS - 14

Hello friends, Welcome to IPCTRD. Dosto MP patwari ke liye Computer Science ki MCQ series me aaj ye 14th video hai jisme 10 questions hai, Dosto pratyek questions ke bad aapko 3.5 seconds ka samay milega aur aapko apna answer soch ke rakhna h 3.5 second ke bad mai apko answer bataunga, comment box me aap mujhe jaroor bataye ki aap ke kitne answer sahi the jisse apko apni taiyari ka status pata chalega. Dosto chalye shuru karte hai. 1. From the following which is known as the administrative section of the computer system ? Control Unit Input Unit RAM Central Processing Unit 2. What is kind of CD-ROM Optical disk Magnetic disk Magneto-Optical disk None of above 3. C is what kind of language ? An assembly language A third generation high level language A machine language Future language 4. Which of the following is a non-volatile memory ? RAM LSI VLSI ROM 5. Which is following is not an operating System ? Unix Linux Windows Java 6.Which among following c...

Contact Us

Name

Email *

Message *