CREATE DATABASE statement in SQL

-
The CREATE DATABASE statement is used to create a new database.

 Syntax:

 CREATE DATABASE databasename;

 CREATE DATABASE EXAMPLE

CREATE DATABASE test;




 Note: Make sure you have admin privilege before creating any database. Once a database is created, you can check it in the list of databases with the following SQL command: SHOW DATABASES;



Comments

  1. Unknown19 April 2018 at 12:36

    What is the basic difference between sql and mysql?

    ReplyDelete

Post a Comment

Popular posts from this blog

Hyperparameter tuning for machine learning models.

-
Image
When creating a machine learning model, you'll be presented with design choices as to how to define your model architecture. Often times, we don't immediately know what the optimal model architecture should be for a given model, and thus we'd like to be able to explore a range of possibilities. In true machine learning fashion, we'll ideally ask the machine to perform this exploration and select the optimal model architecture automatically. Parameters which define the model architecture are referred to as  hyperparameters  and thus this process of searching for the ideal model architecture is referred to as  hyperparameter tuning . Whereas the model parameters specify how to transform the input data into the desired output, the hyperparameters define how our model is actually structured. Unfortunately, there's no way to calculate “which way should I update my hyperparameter to reduce the loss?” (ie. gradients) in order to find the optimal model architecture; thu...
Read more

What is difference between Yield and return Keyword in Python

-
Image
Yield Keyword In Python : Return sends/return specific value back to its caller function whereas Yield can produce a sequence of values. we can use yield when we want to iterate over a sequence but don't want to store the entire sequence in the memory  Yield are used in python generator. A generator function is defined as a normal function but whenever it needs to generate a value,  yield is used instead of return. if any function contains a yield then it will automatically become a generator function 
Read more