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

MySQL – How to Connect to MySQL Server on Command Prompt

March 25, 2014

I have so far authored 5 courses on MySQL at Pluralsight, and one of the most popular question, I keep on getting is how to connect to MySQL with Command Prompt. You may find it funny enough that people who are learning MySQL would know how to connect to command…

Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management

March 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, Professional Development, Software Development

I was just reading Dr. W. Edwards Demings 14 principles of Total Quality Management. It is indeed very impressive and interesting. I have tried to collect a few of the important resources related to the same over here. Dr. Demings’s 14 principles Create a constant purpose toward improvement Adopt the…

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

March 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

MySQL has an inbuilt function called FIND_IN_SET which will search for values within a comma separated values. It basically returns the index position of the first parameter within the second parameter. This can be alternatively used to replace the IN clause. Let us create the following tables CREATE TABLE items(item_id…

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

March 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL

Some conversations are very interesting and I would like to bring them to everyone’s attention. Here is one of the conversation happened earlier this week. Let us say the question was asked by Dustin. Dustin: Can we retrieve last 10 rows from a table? Pinal: Sure, just get the top…

MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP

March 17, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports pattern matching comparison using regular expressions with REGEXP keyword. In this post we will see how to use REGEXP in MySQL. We can use the patterns ^, $, | and sqaure braces to effectively match the values. Let us create the following table: CREATE TABLE items(item_id INT, item_description…

MySQL – How to do Straight Join in MySQL?

March 12, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In an earlier post, we have learnt a new type of join called NATURAL JOIN supported in MySQL. In this post will see another type of join called STRAIGHT_JOIN. STRAIGHT_JOIN is actually an INNER JOIN but it forces the order in which data should be processed. As per MySQL’s documentation…

MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join

March 10, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Joins

As you know MySQL supports ANSI JOINs like INNER JOIN, OUTER JOIN, CROSS JOIN etc. Do you know that it supports NATURAL JOIN?. A NATURAL JOIN is a type of JOIN which automatically maps the similar columns from both the tables. Let us create the following tables CREATE TABLE items(item_id…