TECHYIELD

MYSQL - Drop Database

How to Drop a Database in MySql

1. Open your terminal. 2. Connect to MySql.If not use below link to know how to connect. How to Connect to MySql Database using MAC terminal 3. Once you logged into your mysql then type the below command to drop a database (OMS is database name).

mysql> drop DATABASE OMS;

4. To check whether Database OMS dropped or not type below command.

mysql> USE OMS; ERROR 1049 (42000): Unknown database 'oms'

Which says Database 'OMS' no more exits.

***********Happy Learning*************

MYSQL - Create Database

How to Create a Database in MySql

1. Open your terminal. 

2. Connect to MySql.If not use below link to know how to connect.

How to Connect to MySql Database using MAC terminal

3. Once you logged into your mysql then type the below command 
to create a database.
mysql> CREATE DATABASE OMS;
Query OK, 1 row affected (0.00 sec)   
1 row affected means Database is created successfully.

4. To use this Database OMS type below command.
mysql> USE OMS;
Database changed

5. Check which database you are using by using below command.
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| oms        |
+------------+
1 row in set (0.00 sec)


***********Happy Learning*************

How to Connect to MySql Database using MAC terminal

1. Open your terminal. 2. Check your current directory by typing pwd.

$ pwd

Output :

/usr/local/mysql/bin

your directory should be the bin folder of mysql else go to that directory by typing.

$ cd /usr/local/mysql/bin

3. When you are in mysql bin folder login to your mysql database using below command and enter password.

$ ./mysql -u root -p Enter password:

Output :

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 93 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>

If you see above welcome message then you are logged in to your mysql database.

Java - JDBC Connection Example-1.

Java-JDBC Connection Example-1. Problem Description
How to connect to a database using JDBC?

Assume that database name is OMS(OrderManagementSystem) and it has table named orders which has 5 records.

JAVA INSTALLATION ON MAC

Java Installation on Mac OS

Download the Java from Oracle official site.
You can download from here : Oracle Site
Double click on the file that is downloaded to launch it.
Double click on the package icon to launch install Wizard.
Click Next and Finish.

Basic Enum EXAMPLE

<b>Basic Enum EXAMPLE</b>

An enum type is a special data type that enables for a variable to be a set of predefined constants and the names of an enum type's fields are in uppercase letters.

In the Java programming language, you define an enum type by using the enum keyword.

Project Structure

OrderStatus.java

Test.java

OUTPUT

Download SourceCode From Github

ClickToDownload