Category Archives: MysQl

SQL Optimization Techniques

Optimize access structures: Database design and normalization. Tables: heap or index-organized tables, and table or indexed clusters. Indexes. Constraints. Materialized views. Partitioning schemes. Statistics, including a comprehensive refresh strategy. Rewrite SQL statements: Exclude projections that are not required. Minimize the … Continue reading

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

what is difference between oracle & mysql ?

Key difference: The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). MySQL is the world’s most used RDBMS, and runs as a server providing multi-user access to a number … Continue reading

Posted in database, MysQl, oracle | Tagged , , , | Leave a comment

What is token based authentication ?

Source: Explianed here.. The general concept behind a token-based authentication system is simple. Allow users to enter their username and password in order to obtain a token which allows them to fetch a specific resource – without using their username and … Continue reading

Posted in API, MysQl, PHP | Tagged , , | Leave a comment

Differences between procedure and function in mysql ?

Procedure: Procedure which works like one process and can return back  multiple values so its a procedure. Function: Function is same user define function (UDF) which takes argument as a parameter and able to return back one output value which generated … Continue reading

Posted in MysQl | Leave a comment

What’s the difference between MyISAM and InnoDB?

The main differences between InnoDB and MyISAM (“with respect to designing a table or database” you asked about) are support for “referential integrity” and “transactions”. MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign … Continue reading

Posted in MysQl | Leave a comment