Category Archives: Database

Delete/Truncate data from all Tables in SQL Server

We usually use a dummy database for testing. It gets filled with a lot of unwanted temporary data. At the time of deployment we replicate this database into Live Database. While doing so we need to delete all data from … Continue reading

Posted in Database, MySQL | Tagged , , , | Leave a comment

A brief about MongoDB

Success of any application depends on database scheme. More normalized form of database leads to faster performance of application. To design database schema with normalization is not a piece of cake. Sometimes programmers need to change code according to change in requirement which changes … Continue reading

Posted in Database | Tagged , , , | Leave a comment

Export MySQL Data in CSV File Through External URL

As you know, many of your clients need MySQL data stored on a daily, weekly or monthly basis from you. But if there is no option to share this data through web application or any other medium, then it will be … Continue reading

Posted in Database, MySQL | Tagged , , , , , | Leave a comment

MySQL storage engines

MySQL supports the following the table types or storage engines: 1. ISAM 2. MyISAM 3. InnoDB 4. BerkeleyDB(BDB) 5. MERGE 6. HEAP While considering the table types you have to mainly focus on the following factors: 1. Transaction safe 2. … Continue reading

Posted in MySQL | Tagged , , , , | Leave a comment

How to prevent your application from SQL Injection?

Avoiding auto generated queries is best method to protect your application from SQL injection or you can use parametrized queries or stored procedures. For example, a login form has two basic form elements, a text box for accepting a user … Continue reading

Posted in Database, Security | Tagged , | Leave a comment

Database Indexing Techniques

Indexes are database objects associated with database tables and created to speed up access to data within the tables. Indexes are part of constraint mechanism. When we insert data in table and if a column has primary key constraint, then database checks … Continue reading

Posted in Database | Tagged , , , | Leave a comment