Daily news, white papers, tutorials and articles on databases.


The links below take you to the DevX: Latest Database Content web site. This is a free off site content service. We're not responsible for the linked content. If nothing displays below, the DevX: Latest Database Content blog or news channel is currently unavailable, please try again later.

DevX: Latest Database Content

www.DevX.com

Using COMPRESS in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate: See how to easily encrypt text in MySQL with the compress method.

Understanding INSERT IGNORE in MySQL

Fri, 17 Jan 2020 09:12:00 +0000 · Language: SQL, Expertise: Intermediate: MySQL supports something named IGNORE along with INSERT, which captures the error as a WARNING. See it in action.

Using the STRING_AGG SQL Server 2017 Function

Wed, 15 Jan 2020 09:02:00 +0000 · Language: SQL, Expertise: Beginner: Learn how to perform grouped string concatenation.

Using REPEAT in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate: See how to repeat a particular string a defined number of times.

Understanding UNCOMPRESSED_LENGTH in MySQL

Fri, 10 Jan 2020 09:17:00 +0000 · Language: SQL, Expertise: Intermediate: Learn how to get the compressed text results to be the exact length of the original text.

SQL Statistic Tests to Look Into

Wed, 08 Jan 2020 12:59:00 +0000 · Language: SQL, Expertise: Beginner: Check out these six tests if you want to explore statistics in SQL.

How to Set hibernate.format_sql in a Spring Boot Application

Wednesday, December 31, 1969 · Language: Java, Expertise: Intermediate: See how to format the SQL statements for a Spring Boot application.

Understanding sql_mode in MySQL

Mon, 06 Jan 2020 09:27:00 +0000 · Language: SQL, Expertise: Intermediate - See how to use sql_mode to set values in MySQL.

Understanding FULLTEXT Searches

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - In MySQL, there is a provision to search based on natural mode. Follow this example to understand the process in detail.

Connect to a Database in Spring Boot

Mon, 23 Dec 2019 09:11:00 +0000 · Language: Java, Expertise: Intermediate - See how to use application.properties to instruct Spring Boot to connect to a database.

Understanding MAX_USER_CONNECTIONS in MySQL

Fri, 20 Dec 2019 09:09:00 +0000 · Language: SQL, Expertise: Intermediate - Learn how to restrict the number of connections made from a user to the database.

Using CAST for Explicit Conversion in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - MySQL allows you to explicitly convert a number to a string with the help of CAST function. See an example of how to use this feature.

Using JSON as a Data Type

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - MySQL is a very robust database that supports JSON as a data type. See how to make this feature work for you.

Types of Engines that Are Supported in MySQL

Mon, 09 Dec 2019 08:12:00 +0000 · Language: SQL, Expertise: Intermediate - See how to use the query in the example to display the list of available engines that are supported in MySQL.

Working with Multiple Query Windows

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - Learn the best ways to work with multiple query windows in SQL.

Finding the TAN of a Given Number

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - MySQL provides numerous mathematical calculations that can be computed with inbuilt functions. Learn how to find the TAN of a number.

Using the SUBSTRING_INDEX in MySQL

Mon, 25 Nov 2019 09:49:00 +0000 · Language: SQL, Expertise: Intermediate - See how to extract a part of the given string using the SUBSTRING_Index in MySQL.

Selecting All Columns, Separated with Commas

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to get a nicely comma-separated list of column names.

How to Pass Parameters in @Query

Fri, 15 Nov 2019 09:09:00 +0000 · Language: Java, Expertise: Intermediate - Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.

Object Explorer Details

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to use the Object Explorer feature in SQL to find a particular stored procedure from a long list of available options.

Locking a User Account in MySQL

Mon, 11 Nov 2019 09:47:00 +0000 · Language: SQL, Expertise: Intermediate - MySQL provides a mechanism to alter the user properties, thereby allowing you to lock the user account.

Using Multi Edit Mode

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - When dealing with large lists of information, we, as developers, sometimes need to copy them, then add commas manually. See a neat trick to automatically add the required commas.

Get All Columns in All Tables of a Specific Data Type

Wednesday, December 31, 1969 · Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.

Set Up a Database Dialect in Spring Boot

Wednesday, December 31, 1969 · Language: Java, Expertise: Intermediate - Learn how to use the spring.jpa.properties.hibernate.dialect property to set the database dialect in Spring Boot.

Using MICROSECOND in MySQL

Wednesday, December 31, 1969 · Language: SQL, Expertise: Intermediate - Developers often work with time in terms of hours, minutes and seconds. Learn how to break it down to the microsecond level.


· Home

· Databases

· DevX

· Web Links

· Link to us

· Contact

· What's new

· Site map

· Get Help


Most popular:

· Site Feeds

· Database Design Guide

· Google Sitemaps

· smartDataPump

· Spider Support

· How To Link Properly


Free Tools:

· Sitemap Validator

· Simple Sitemaps

· Spider Spoofer

· Ad & Click Tracking



Search Google
Web Site

Add to My Yahoo!
Syndicate our Content via RSS FeedSyndicate our Content via RSS Feed



To eliminate unwanted email from ALL sources use SpamArrest!






Digg this · Add to del.icio.us · Add to Furl · We Can Help You!




Home · Categories · Articles & Tutorials · Syndicated News, Blogs & Knowledge Bases · Web Log Archives


Top of page

No Ads


Copyright © 2004, 2005 by Smart IT Consulting · Reprinting except quotes along with a link to this site is prohibited · Contact · Privacy