Pages

▼
Showing posts with label Database and SQL. Show all posts
Showing posts with label Database and SQL. Show all posts

MySql get full name from last first mid name

›
Using CONCAT_WS to extract full name from first , middle and last name.  It also handles the case that the mid_name can be empty or null ...

mysql hibernate unicode support - character set, collate

›
I just did following configurations to achieve Unicode support in my Java+Hibernate+MySQL project. Configuring MySQL to support Unicode - ...

What's the difference between a primary key and a unique key?

›
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index...

What is de-normalization and when would you go for it?

›
As the name indicates, de-normalization is the reverse process of normalization. It is the controlled introduction of redundancy in to the d...

What are clustered index and non clustered index

›
With a clustered index the rows are stored physically on the disk in the same order as the index. There can therefore be only one clustered ...

SQL basics- complete reference guide - part8 SQL System Commands

›
Part8: SQL System Commands Reference guide TOPIC TEXT SYNTAX Example ARRAY_GET Returns one element of an array. ARRAY_GET(arrayExpres...

SQL basics- complete reference guide - part7 - Date Time Functions

›
Part7: SQL Date Time Functions Reference TOPIC TEXT SYNTAX Example CURRENT_DATE Returns the current date. { CURRENT_DATE [ () ] | CUR...

SQL basics- complete reference guide - part6 - String functions

›
Part6: SQL String Functions Complete Reference TOPIC TEXT SYNTAX Example ASCII Returns the ASCII value of the first character in the ...

SQL basics- complete reference guide - part5 - Mathematical Functions

›
Part5: Mathematical Functions in SQL- Complete Reference Function Description SYNTAX Example ABS Returns the absolute value of a numb...

SQL basics- complete reference guide - part4 - Aggregate Functions in SQL

›
Part4: Aggregate Functions in SQL- complete reference sheet Command/Function Description SYNTAX Example AVG The average (mean) value....

SQL basics- complete reference guide - part3 - Data Types in SQL

›
Part3: SQL Data Types Reference TOPIC TEXT SYNTAX Example INT Type Possible values: -2147483648 to 2147483647. INT | INTEGER | MEDIUM...

SQL basics- complete reference guide - part2 - DDL

›
Part2: DDL -Data Definition Language Reference Command Description SYNTAX Example ALTER INDEX RENAME Renames an index. ALTER INDEX in...

SQL basics- complete reference guide - part1 - DML

›
Part1: DML-Data Manipulation Language Command Description SYNTAX Example SELECT Selects data from a table or multiple tables. SELECT ...