dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development

Database Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 384     Previous     Next
Understanding INSERT IGNORE in MySQL
by Sridhar MS
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
by Hannes du Preez
Language: SQL, Expertise: Beginner: Learn how to perform grouped string concatenation.
Using REPEAT in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate: See how to repeat a particular string a defined number of times.
Understanding UNCOMPRESSED_LENGTH in MySQL
by Sridhar MS
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
by Hannes du Preez
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
by Octavia Anghel
Language: Java, Expertise: Intermediate: See how to format the SQL statements for a Spring Boot application.
Understanding sql_mode in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate - See how to use sql_mode to set values in MySQL.
Understanding FULLTEXT Searches
by Sridhar MS
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
by OCTAVIA ANGHEL
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
by M S Sridhar
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
by M S Sridhar
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
by Sridhar MS
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
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn the best ways to work with multiple query windows in SQL.
Finding the TAN of a Given Number
by M S Sridhar
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
by M S Sridhar
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
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to get a nicely comma-separated list of column names.
How to Pass Parameters in @Query
by Octavia Anghel
Language: Java, Expertise: Intermediate - Learn how to pass parameters to an SQL query written with @Query via @Param or positional parameters.
Object Explorer Details
by Hannes du Preez
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
by M S Sridhar
Language: SQL, Expertise: Intermediate - MySQL provides a mechanism to alter the user properties, thereby allowing you to lock the user account.
1-20 of 384     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date