Parameters in MySQL Stored Procedure

  • 2

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

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

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

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 […]

Store Unicode in MySQL

  • 6

This article will be useful when you are dealing with the multilingual site with database driven content. While dealing with multilingual website you may have faced the problem of data is not being either saved or retrieved properly. So what could be the reason for this? The reason is, you have not set proper Character […]

Change MySQL Database Collation and Character Set

  • 2

This article is about to explain how you can manage database collation and character set of your database. If you are working on website which covers only one language which is english then you may not worry about these stuff.

Repeating and Scheduling MySQL Events

  • 1

In earlier two posts we have learned to check for the Events status in MySQL server and then after we have learned to create a simple event, edit existing events, drop and rename evants. Also in the second article we have checked that normal events will gets deleted once executed, these events also called as […]

Creating Simple Event with MySQL

  • 5

This is the second article of this series and I am going to cover creation of basic mysql events and check the status of the same. If you are not sure what was covered in this series yet then you can have a look at the first article about MySQL Events. Creating a First Event […]