While doing database programming, we mainly focus on SQL statements that do 'select','insert','update','delete' operations with some conditions 'where','like' and some orders 'group by', 'order by'. For a little complex goal, use join operations. MYSQL database is a very popular name in web applications development, specially for small and medium scale applications. Moreover, … [Read more...] about Beginning With MySQL Stored Procedure Programming
Database
Codeigniter Active Record Class Overview
In this article, I will give a small overview of the Codeigniter Active Record class, show the basic way to use it, its drawbacks and potential solution of a common problem(union operation with it, which isn't directly supported) that developers face often. I will be using a few possible PHP code examples for demonstration purposes also, wherever applicable. So, you are … [Read more...] about Codeigniter Active Record Class Overview
Database-Driven Desktop Form Tutorial Using C#.NET
.NET Platform has provided a lot of extra advantages to its developers compared to other platforms. It provides a rich set of tools, libraries etc, that makes the work of developers a lot easier. One of those features is to help developers create a desktop form-based application very easily just by following a couple of steps, without writing a single line of c# code, not even … [Read more...] about Database-Driven Desktop Form Tutorial Using C#.NET
Primary/Foreign Key Constraints On MySQL
We, software developers, sometimes take the headache to solve such problems which actually has very easy/integrated solutions, we just don't know that it does exist and don't know how to use the solution. In this tutorial, I will try to discuss such an issue on database management. For small/medium scale applications, developers usually take care of the database part also, … [Read more...] about Primary/Foreign Key Constraints On MySQL
Basic MySQL Best Practices
Software developers, now a days, usually use to work in various fields of programming and development. Such as UI design, server-side programming(even in various languages like PHP, Asp.NET etc) and database management as well. In each area, if we use and follow some traditional best practices. Then they always be organized and easy for keeping track time to time among other … [Read more...] about Basic MySQL Best Practices