Deleting a Table from Database
This section describes how to delete a table from database. Java provide the facility for deleting a specific table from a given database with the help of some specified methods.
Retrieving Tables from a Database
This section provides you a facility for retrieving tables from a specific database through an example. You have to know about a database that is a collection of data or information.
in MySQL database table
Here we are going to see, how we can insert values in the MySQL database table. We know that tables store data in rows and column format. After creating a database table, you insert the values in it.
Retrieving All Rows from a Database Table
Here, you will learn how to retrieve all rows from a database table. You know that table contains or stores the data in rows and columns format. If you want to access the data from a table then you need to use some APIs and methods.
Getting Column Names
from a database table in Java
Here, providing you an example with code that retrieves all columns name in a specific database table. Sometimes, you need to know the number of columns and the names of the columns of the table then you can retrieve it with the help of this example.
Rows from a Database Table
Consider a case where we have been given one database table, now we have to delete all the rows from the table. This section describes for deleting all rows from a specific database table.
Specific Row from a Database Table
Consider a case where we are creating a table and we have add some data in it. It may happen that we might add a wrong data in a row, now we need to delete that particular data. This can be done very easily , and in this section we are going to do the same that is, how to delete a specific row from a specific database table.
Join tables in
the specific database
In this section, we are going to consider how to join two or more tables in a specific database. For this you need to have two or more table in the database. If two or more tables are available in the database then Join operation is performed otherwise not.
with the NATURAL LEFT JOIN operation
This section describes the NATURAL LEFT JOIN operation and how to retrieve data through it. In this operation we are going to retrieve data according to match the field name of another tables.
with the NATURAL RIGHT JOIN operation
This section describes the NATURAL RIGHT JOIN operation of table in a specific database. This operation join tables on the basis of matching fields but priority will be given to the right table field values.
Tables in a Specific Database
This section introduces you to the cross join between two tables. The cross join operation retrieves data between two tables as a Cartesian product of set theory in mathematics. All data show to multiply by each rows.
Write Text File to Table
In this section, you will learn how to read the records of a simple text file and write (insert) into a simple table in MySQL database. All records are written in the simple text file and again, if you need to insert these records in tabular format the following example will provide the facility for writing this content.
Table in a MySQL Database
In this section, you will learn to copy one table to another in a same MySQL database.
One Database Table to Another
In this section, you will learn to copy one database table to another database table. That means we copy one table to a different table but it contains a similar type of field or column.
Liked it! Share this Tutorial