Migrating from MYSQL 5 to MYSQL 8 (AWS) – Java
Below document contains steps for migrating from MYSQL5 to MYSQL 8 in Java application. Java_MigratingMysql5ToMysql8
Read morePosted In: Database
Important Commands Of MySQL Database
Database Connection Example: [crayon-68a68fe1beef3004390828/] SQL: Required − SQL query to create or delete a MySQL database Data Type: Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use. For example, do not define a
Read moreSQL Commands
SQL Commands: The standard SQL commands to interact with relational databases are CREATE, SELECT, INSERT, UPDATE, DELETE and DROP DDL - Data Definition Language: CREATE: Creates a new table, a view of a table, or other object in the database ALTER: Modifies an existing database object, such as a table DROP: Deletes an entire table,
Read moreMS SQL connection using JDBC in Selenium
To connect MS SQL database using jdbc driver in java, we need to download jdbc driver for MS SQL server. Refer below link to download MS SQL jdbc driver file. Add external Jar file to project: Right click on project, Go to properties → Java Build Path → Click on Library tab Add external
Read moreCROSS APPLY and OUTER APPLY in SQL Server
In this article, we are learning the use of the CROSS APPLY and OUTER APPLY SQL Server APPLY operator has two variants: CROSS APPLY and OUTER APPLY The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table
Read morePerformance Test for Cursors in Stored Procedures
In this article, we will test the performance of the cursors with the help of the client statistics that shows the different statistics like Network statistics, Time statistics, Query Profile Statistics. Step#1: First reset client statistics by click on Query >> Reset client Statistics. This will clear the client statistics Step#2: Click
Read moreHow to get all disable-enabled trigger from database
just we need to fire a query [crayon-68a68fe1bf63d265379642/]
Read moreHorizontal and Vertical Joins in SQL
Join is the most easiest thing that could ever happen to a table, may it be a horizontal or a vertical join. Though the word vertical is not common in terms of joins but it is a common type of join that is applied in day to day SQL queries. A horizontal
Read moreSQL NULL Value – Simplified
In SQL, NULL approximately represents an unknown value.An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero and NULL plus NULL is NULL as well.A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL's three-valued
Read moreBlock IP Addresses in MS SQL Server
In most cases when we make API calls from a web application hosted on a Server or a VM. We want to make sure that the database is secured and only accessible to a particular group of individuals. In this case we can allow or block particular IP addresses as
Read more