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

MySQL – How to Write Loop in MySQL

November 12, 2013

Since, I have written courses on MySQL, I quite often get emails about MySQL courses. Here is the question, which I have received quite often. “How do I loop queries in MySQL?” Well, currently MySQL does not allow to write loops with the help of ad-hoc SQL. You have to…

MYSQL – Identifying Current Version of MySQL Server Installation – Part 2

November 9, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Scripts

Earlier I wrote an article about Detecting Current Version of MySQL Server Installation. After the post quite a few emails I received where various users suggested that there are many more ways to figure out the version of MySQL. Here are few of the methods which I received in the…

MySQL – How to Find mysqld.exe with Command Prompt – Fix: ‘mysql’ is not recognized as an internal or external command, operable program or batch file

November 8, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

One of the most popular question I get after watching my MySQL courses on Pluralsight is that beginning users are not able to find where they have installed MySQL Server. The error they receive is as follows when they type mysqld command on their default command line. ‘mysql‘ is not recognized as…

Big Data – ClustrixDB – Extreme Scale SQL Database with Real-time Analytics, Releases Software Download – NewSQL

November 6, 2013

Pinal Dave

Big Data, SQL, SQL Server, SQL Tips and Tricks

MySQL

There are so many things to learn and there is so little time we all have. As we have little time we need to be selective to learn whatever we learn. I believe I know quite a lot of things in SQL but I still do not know what is…

MYSQL – Detecting Current Version of MySQL Server Installation

November 3, 2013

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

Here is one of the most popular questions which I receive which is related to MySQL installation. The question is how do I know which version of the MySQL I have installed on my server. Here is the simple trick which works all the time. Connect to your MySQL engine…

SQLAuthority News – 7th Anniversary of Blog – A Personal Note

November 1, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MySQL

Special Day Today is a very special day – seven years ago I blogged for the very first time. Seven years ago, I didn’t know what I was doing, I didn’t know how to blog, or even what a blog was or what to write. I was working as a…

SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course

September 3, 2013

Pinal Dave

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

MySQL, SQL Index

Every year around September 1st, I have decided to do something cool. This is because September 1st is my daughter Shaivi’s birthday. In previous years, I have released my new books as well new courses on this day. This year I have done something similar for her. I like to…