That is why Java has defined its own API (JDBC API) that uses JDBC drivers (written in Java language). But, ODBC API uses ODBC driver which is written in C language (i.e. A list of popular interfaces of JDBC API are given below:Ī list of popular classes of JDBC API are given below:īefore JDBC, ODBC API was the database API to connect and execute the query with the database. The java.sql package contains classes and interfaces for JDBC API. It is based on the X/Open SQL Call Level Interface. It is the stable release since 21st September, 2017. It is like Open Database Connectivity (ODBC) provided by Microsoft. By the help of JDBC API, we can save, update, delete and fetch data from the database. We can use JDBC API to access tabular data stored in any relational database. We have discussed the above four drivers in the next chapter. JDBC API uses JDBC drivers to connect with the database. It is a part of JavaSE (Java Standard Edition). JDBC is a Java API to connect and execute the query with the database. RIGHT JOIN SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition 4.JDBC stands for Java Database Connectivity. LEFT JOIN SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON condition 3. INNER JOIN SELECT * FROM TABLE1 INNER JOIN TABLE2 where condition 2. How to delete stored procedure DROP PROCEDURE sp_name Joins 1. How to call Stored procedure CALL sp_name 3. Create a Stored Procedure CREATE PROCEDURE sp_name(p1 datatype)ĮND 2. Drop a Trigger DROP TRIGGER trigger_name Stored Procedures 1. Create a Trigger CREATE TRIGGER trigger_name trigger_time trigger_event Deleting a View DROP VIEW View_name Triggers 1. How to call view SELECT * FROM View_name 3. DROP INDEX DROP INDEX index_name ON table_name Views 1. CREATE INDEX CREATE INDEX index_name on table_name(column_name) ĬREATE UNIQUE INDEX index_name on table_name(column_name) 2. DELETE DELETE FROM table_name where condition Example DELETE from EMPLOYEE where empId='0001' Indexes 1. WHERE condition Example UPDATE EMPLOYEE SET dept = 'Sales' WHERE empId='0001' 4. Example SELECT * FROM EMPLOYEE where dept ='sales' 3. Example INSERT INTO EMPLOYEE VALUES (0001, 'Ava', 'Sales') 2. INSERT INSERT INTO table_name (column1, column2, column3. COMMENT Single-Line Comments: -Line1 Multi-Line comments: /* Line1, RENAME RENAME TABLE table_name1 to new_table_name1 6. ALTER ALTER TABLE Table_name ADD column_name datatype Example INSERT INTO EMPLOYEE VALUES (0001, 'Dave', 'Sales') 3. Supports many operating systems like Linux*,CentOS*, Solaris*,Ubuntu*,Windows*, MacOS*,FreeBSD* and others.High productivity as it uses stored procedures, triggers, views to write a highly productive code.Reliable, very fast and easy to use database server.Open-source relational database management systems.MySQL is a open-source, free and very popular relational database management system which is developed, distributed and supported by Oracle corporation. The editor shows sample boilerplate code when you choose language as 'MySQL' and start writing queries to learn and test online without worrying about tedious process of installation. Getting started with the OneCompiler's MySQL editor is really simple and pretty fast. ![]() It's one of the robust, feature-rich online editor and compiler for MySQL. Write, Run & Share MySQL queries online using OneCompiler's MySQL online editor and compiler for free.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |