PostgreSQL : Truncate table with restart PK Auto increment value

  • 0
  • Nov 25, 2016

It’s very easy to truncate table in any database but all database have some uniqueness in each of them. I have written this quick tip to show how we can truncate table in PostgreSQL with restarting primary key auto increment value. Here is the simple command to truncate table but it won’t reset the autoincrement […]

mysql_connect v/s mysql_pconnect

  • 0
  • Jun 10, 2013

When you tried to connect to the MySQL database using PHP, you will find two types of functions for connection.

Order By with Group By in MySQL

  • 8
  • Nov 09, 2012

Its a post after so long time, actually very busy schedule. But today I got something to learn to I have managed spare some time for the same and consider sharing with all my readers.

Connect to MySQL Server on Linux From Windows

  • 0
  • Jun 22, 2012

Here I come with quick tip. This is about when you find problem when your MySQL Server is running on Linux machine and you are trying to connect from Windows Machine. You might think its should not be a problem, but the fact is that, you will face problem when you have such condition where […]

Transaction in MySQL Stored Procedure

  • 1
  • Jun 13, 2012

Here I come with the second last article in the MySQL Stored Procedure Article Series. In this article we will learn about Transactions in MySQL Stored Procedure. But first let’s have a flashback of the articles now.

COALESCE in MySQL

  • 0
  • Jun 01, 2012

Here I come with the quick but very usefult tip for the MySQL queries. I will explain COALESCE function of the MySQL. COALESCE is used to get the first NOT NULL value from the passed arguments. This function can takes any number of arguments. Let’s see how you can use this function. SELECT COALESCE(NULL, NULL, […]

Loops in MySQL Stored Procedure

  • 2
  • May 30, 2012

Hi all, Here we reach to the Loops in MySQL Stored Procedure. But before starting, I hope you are aware of previous articles. If not let me give falshback first. Flashback Upto now we have covered the basic Introduction For Stored Procedure in MySQL, then we have compeleted the Types of Parameter in MySQL Stored […]

Conditional Control in MySQL Stored Procedure

  • 1
  • May 23, 2012

Hello guys, here goes the third article of this series. If you are not sure about this article series then I would recommonded you to start from the first article in this series. Now let’s have quick flashback of the past articles. Flashback In first article we have covers basics of the stored procedure which […]

Parameters in MySQL Stored Procedure

  • 2
  • May 17, 2012

Just to remind you about my article series for MySQL Stored Procedure. So here comes the second article in the series. If you are not aware about the previous one then it would be great if you have a look at that article and come back here after completing that article. Let’s have flashback of […]

Starting with MySQL Stored Procedure

  • 4
  • May 11, 2012

Stored procedure is a great feature to write the reusable queries, I mean write once and use as much you need. Generally Stored procedures contains the bunch of queries which runs one after another. I would like to inform you that I am starting the Article Series for MySQL Stored Procedure. In this serier I […]

Create Packed Indexes with MySQL

  • 1
  • Apr 24, 2012

I am pretty much sure that you are aware of indexes which we are creating on database fields. Indexes are very useful to make your query search faster and improve the site performance. But the fact is that Indexes which we are creating on database tables also require some additional space on your hard disk […]

File Per Table Mode in InnoDB

  • 2
  • Apr 22, 2012

After very long time a tutorial on MySQL, earlier I have written few articles on MySQL in sequence so I have taken a break from MySQL and was concentrating on other section to write new articles. Now again its time for MySQL and in this article we will discuss about the storage pattern of one […]