MySQL Archives - Page 5 of 17 - SQL Authority with Pinal Dave

MySQL – How to Generate Random Number

February 6, 2016

In MySQL, UUID() function returns Universal Unique Identifier that generates 36 characters long value which is 5 part hexadecimal numbers. If you want to generate random password, you can make use of this function which generate random number.

Returns the string 85aeb064-8f73-11e5-85ef-02fcc4101968 (Note that this is random, when you execute you will get different value). As the total length is 36, you can make use of the result to get a random password with any length.

Interview Question of the Week #056 – How to fix Installation Failure – Rule “Setup account privileges” Failed in SQL Server

January 31, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

Sometimes in the interviews I observe that users are able to answer all the theoretical questions correct but when it is about doing practical they fail. A while ago, when I was helping a large organization with interview, suddenly their DBA reported that one of their server has installation error.…

SQL SERVER – Script: Finding Cumulative IO Per Database File

January 2, 2016

Pinal Dave

SQL, SQL Server

MySQL, SQL Scripts

Sharing SQL Server related scripts is something I tend to do from time to time. At the SQLPass one of the attendees for my session around 42 tips asked, if I have any script that is handy to find the IO utilization per database file because they had couple of…

MySQL – Date and Time Related System Functions

December 19, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports lot of functions to get current date and time. The following are some of the system functions. There are two functions to get current date SELECT curdate(),current_date(); There are two functions to get current time SELECT curtime(),current_time(); There are two functions to get current date along with time…

SQL SERVER 2016 – Comparing Execution Plans

November 28, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Execution Plan, MySQL

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. After installing the CTP, I was pleasantly surprised to see this addition to help our DBA’s who are doing performance tuning and…

MySQL – Get Latest Identity Value by Inserts

November 16, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In SQL Server, whenever you add data to a table that has an identity column, you can get the lastly generated identity value using @@identity or scope_identity(). Similarly, in MySQL you can make use of LAST_INSERT_ID () function Let us create the following dataset Create table test(id int AUTO_INCREMENT NOT…

MySQL – Different Methods to Know MySQL Version

November 5, 2015

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In SQL Server, to know the current version of the server, you can use system variable @@VERSION How many of you know that the same can be used in mysql to know the version? Also there are many ways to know the version of MySQL Method 1: Select @@version as…