Subscribe: DevX: Latest Database Content
http://services.devx.com/outgoing/databasefeed.xml
Preview: DevX: Latest Database Content

DevX: Latest Database Content



www.DevX.com



Published: Tue, 16 Jan 2018 10:17:56 -0800

Last Build Date: Tue, 16 Jan 2018 10:17:56 -0800

 



Knowing the Version and Supported Engines in MySQL

Fri, 12 Jan 2018 06:06:00 -0800

Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.



Extract All Numbers from a String in SQL

Mon, 08 Jan 2018 02:34:00 -0800

Language: SQL, Level: Intermediate: - Learn this easy way to extract numbers from a string.



Disable Indexes with SQL

Thu, 21 Dec 2017 05:36:00 -0800

Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.



Purging Binary Logs in MySQL

Mon, 18 Dec 2017 05:14:00 -0800

Language: SQL, Expertise: Intermediate - Stay out of trouble regarding reaching maximum disk space by purging old logs in MySQL when they are no longer needed.



The sp rename SQL Stored Procedure

Thu, 14 Dec 2017 14:22:00 -0800

Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.



Understanding Null Values Returned in MySQL

Thu, 07 Dec 2017 01:23:00 -0800

Language: MySQL, Beginner: Intermediate - Learn why the null value often needs special attention in your code to work effectively.



Pass Comma Separated Values as a Parameter to an SQL Stored Procedure

Wed, 29 Nov 2017 02:35:00 -0800

Language: SQL, Expertise: Intermediate - There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn't support this. See how to get around this issue.



Limiting the Rows Returned in MySQL

Tue, 28 Nov 2017 13:21:00 -0800

Language: SQL, Expertise: Intermediate - In MySQL, LIMIT is a feature that helps fetch a certain number of records matching the criteria provided.



Using the SQL FORMAT Function

Thu, 23 Nov 2017 02:31:00 -0800

Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.



Using BETWEEN in MySQL Queries

Wed, 22 Nov 2017 02:49:00 -0800

Language: SQL, Expertise: Intermediate - See how to filter a column based on dates and time using BETWEEN.



Create and Schedule an SQL Job

Thu, 16 Nov 2017 10:06:00 -0800

Language: SQL, Expertise: Intermediate - Sometimes you want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis. Learn to create an SQL Job and schedule it.



Making a Column Autoincrement the Value Itself in MySQL

Wed, 15 Nov 2017 02:47:00 -0800

Language: SQL, Expertise: Intermediate - Learn how to make a column auto-increment the value every time a record is inserted in that table.



Check if a Primary Key Exists on a Table

Fri, 10 Nov 2017 02:27:00 -0800

Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.



Updating a Column with the Current Time Stamp in MySQL

Fri, 27 Oct 2017 02:05:00 -0700

Language: SQL, Expertise: Intermediate Learn how to add the current time from the database when updating a column.



Identifying Unused Tables with T-SQL

Thu, 26 Oct 2017 02:47:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.



Identify Tables with Large Column Counts

Thu, 19 Oct 2017 03:22:00 -0700

Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.



Find Out the Column Name Using the COL_NAME() Function

Thu, 12 Oct 2017 03:03:00 -0700

Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.



Summing a COUNT Aggregate SQL Function

Thu, 05 Oct 2017 03:09:00 -0700

Language: SQL, Expertise: Intermediate - See how to sum the result of a count aggregate function.



Using TRY and CATCH Blocks in T-SQL

Thu, 28 Sep 2017 03:41:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to handle errors in T-SQL.



Using FILEPROPERTY to Check for Free Space in a Database

Thu, 21 Sep 2017 03:38:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to use FILEPROPERTY to check for free space in a database.



Using the Replace Command in MySQL

Wed, 20 Sep 2017 03:03:00 -0700

Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.



Identify All the Foreign Keys in Your Database

Thu, 14 Sep 2017 03:35:00 -0700

Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.



Import Large SQL Files into MySQL

Wed, 13 Sep 2017 03:06:00 -0700

Language: SQL, Expertise: Intermediate - Follow these steps to import large SQL files into MySQL.



Get All Tables Referenced by at Least One View

Thu, 07 Sep 2017 03:30:00 -0700

Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.



Disabling AutoCommit in JDBC

Tue, 05 Sep 2017 01:16:00 -0700

Language: Java, Expertise: Intermediate - Learn why it is unwise to commit after every insert.