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

SQLAuthority News – Great Time Spent at Great Indian Developers Summit 2014

May 9, 2014

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

The Great Indian Developer Conference (GIDS) is one of the most popular annual event held in Bangalore. This year GIDS is scheduled on April 22, 25. I will be presented total four sessions at this event and each session is very different from each other. Here are the details of…

MySQL – How to Create Stored Procedure in MySQL

May 2, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Stored Procedure

MySQL supports Stored Procedures which can execute set of codes by applying relevant business logics. In this post we will see how to create a stored procedure and execute it. Let us create the following tables CREATE TABLE items(item_id INT, item_description VARCHAR(100)); CREATE TABLE sales(sales_id INT auto_increment KEY,item_id INT, sales_date…

SQL SERVER – Presenting 4 Technology Sessions at Great Indian Developer 2014 – Contest

April 21, 2014

Pinal Dave

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

GIDS, MySQL

The Great Indian Developer Conference (GIDS) is one of the most popular annual event held in Bangalore. This year GIDS is scheduled on April 22, 25. I will be presenting total four sessions at this event and each session is very different from each other. Event Location: J. N. Tata…

Developers – Drive by Daniel Pink – Book Review

April 19, 2014

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

MySQL, SQLAuthority Book Review

I have been an avid reader of books. I read pretty much one or two books every week. I believe reading helps me a lot in my day job as well as well writing blog post. I am an evangelist and my primary responsibility is to spread the love for…

MySQL – Finding First day and Last day of a Month

April 9, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL DateTime

MySQL supports a lot of DATE and TIME related functions. If you want to find out last day of a month, you can make use of an inbuilt function named LAST_DAY. SET @date:='2012-07-11'; SELECT LAST_DAY(@date) AS last_day; The above code returns the value 2012-07-31 However, there is no inbuilt function…

MySQL – List User Defined Tables – Two Methods

April 1, 2014

Pinal Dave

SQL Tips and Tricks

MySQL, SQL Scripts, SQL Server, SQL System Table

There are different methods to list out user defined tables in MySQL. We will see two methods in this post.

Let us create the following tables in the database named Test

MySQL – Generate Script for a Table Using SQL

March 28, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In SQL Server, to generate the CREATE TABLE script for a table, you need to rely on the SQL Server Management Studio (SSMS) tool and there is no inbuilt function supported to do this using SQL. However, in MySQL you can generate the script for a table using SQL. Let…