Home | | Computer Science 12th Std | Creating Database

Structured Query Language(SQL) - Creating Database | 12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL)

Chapter: 12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL)

Creating Database

To create a database, type the following command in the prompt: CREATE DATABASE database_name;

Creating Database

 

1. To create a database, type the following command in the prompt: CREATE DATABASE database_name;

For example to create a database to store the tables: CREATE DATABASE stud;

2. To work with the database, type the following command.

USE DATABASE;

For example to use the stud database created, give the command USE stud;

 

 

Tags : Structured Query Language(SQL) , 12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL)
Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL) : Creating Database | Structured Query Language(SQL)


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2024 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.