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 […]
When you tried to connect to the MySQL database using PHP, you will find two types of functions for connection.
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.
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 […]
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.
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, […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]