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: MySQL
Important Commands Of MySQL Database
Database Connection Example: [crayon-68a68fc386da2994567081/] 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 moreHow to get all disable-enabled trigger from database
just we need to fire a query [crayon-68a68fc3871a4797662485/]
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 moreDDL, DML, DCL, DQL and TCL Commands – Meaning and Keywords in SQL
SQL - Structured Query Language is further categorized on the basis of various commands and functionality types done by a particular set of keywords and the overall impact on a particular set of database objects. They are as follows:DDL - Data Definition LanguageDML - Data Manipulation LanguageDCL - Data Control
Read moreWhy Database testing is required
Why Front-end application testers should also know the basic Database testing in order to better test the applications:-What is Database TestingIn Database testing we validate:-Exactly the same data that is in database is retrieved by web or desktop application (front-end applications).The data which is inserted/modified from front-end application the same
Read moreLeft outer join in LINQ
we can implement left outer join in LINQ as wellsuppose i have 2 tables 1. product 2. order. In the order we have foreign key named as productId reference to product tableNow we want to achieve left or left outer joinvar q=(from pd in dataContext.Products join od
Read morehow to order by number and string in SQL Query
If you want to apply order by on column which contains data likes numbers, string..etc Then here is the solution [crayon-68a68fc3873c4770253807/] Input:- a ba ab 1 as 2 Output:- 1 2 a ab as ba :)
Read more