Java Techies- Solution for All
MySQL Database
1.1 Understanding on General Database concepts
A database is an application that organized a collection of data to store in particular way.
Learn More... |
1.2 Feature of MySQL Database
MySQL is a free, open-source database engine available for different platforms.
MySQL represents an introduction to modern database technology for high-volume application.
Learn More... |
1.3 Install the MySQL Server on windows
To install MySQL database, follow the given below options and setup MYSQL -
Learn More... |
1.4 Starting MySQL Database
Before start the MySQL Server, you should set the path for MySQL Server. To set the path of MySQL Server, you need to follow some steps given below -
Learn More... |
1.5 Retrieving Information from a Table
This content provides introduction of various queries to retrieving Information from table by using where and like clause .
Learn More... |
1.6 Retrieving Information from two or more Table by using MySQL Join
Normally we are retrieve information from one table ay a time. This is correct for simple application, but in real time application MySQL uses queries to get data from multiple tables in a single query.
Learn More... |
1.7 MySQL Functions and Grouping query data with aggregate functions
In MySQL you can create own function to return specific data. Function are normally used for computation.
The retutn clause is mandatory for a function. It indicates the return type of the function, and the function body must contain a RETURN value statement. Learn More... |
1.8 MySQL Stored Procedure
A stored procedure is a procedure that is used to store data into database and retrieve data from multiple tables.
Stored procedure has a name, a parameter list, and an SQL statement, which can contain many more SQL statements. Learn More... |
1.9 Import/Export mysql Data
To import and export data from table to text file using command line you can use some queries which will further given ahead -
Learn More... |
1.10 MySQL Storage Engines
A storage engine is a software system that stores, handles, and retrieves information from a table.
MySQL supports several storage engines that act as handlers for different table types.
Learn More... |
1.11 MySQL Queries
A storage engine is a software system that stores, handles, and retrieves information from a table.
MySQL supports several storage engines that act as handlers for different table types.
Learn More... |