It may happen times to times you need to delete duplicate rows from a table. There are many options to do that. I will write on my blog one of my option that I am using often to remove duplicate rows from a table.
Let’s say we have a…readmore →
Many time I had problem to update or delete rows from one table depends from another table (inner join). Like we make select from two or more tables with inner join in the same way we can make also update or delete.
Let’s take an example where we have…readmore →
In this article, I will try to demonstrate what a relational database is, and how to properly design your database to store informations in it.
A database stores data in an organized way so that it can be searched and retreived later. A database is collection of one or more…
During a project that I’m doing now, I saw that many programmers have their photos or any document to keep them in the database and whenever they need to open it. In the project I’m working for my company we need to save our documents (images, word documents…readmore →