PROCEDURE ANALYSE()
If you want to analyze the columns structures of a MySQL table and want to view the actual data in your table with certain suggestion then you can get help from PROCEDURE ANALYSE(). For example, […]
Category: MySQL
MySQL in Namaste UI focused on mysql dbms, mysql tools, mysql database, mysql software, mysrl app, mysql server, learn mysql online, sql tutorial and mysql tutorial.
MyISAM vs Innodb
MyISAM vs Innodb – both are commonly used engines on MySQL servers and they both have their unique advantages and disadvantages against each other. MyISAM is the default storage engine type for MySQL 5.0 but […]
Referential integrity
It is relational database concept in which multiple tables shares consistent relationship based on the data stored on tables. For example, a school X has 2 tables, a student table, and a student fee table. […]
MySQL INDEX
For improving the speed of operation in a table we use MySQL INDEX. We can create more than one field as a index field in a table. This is basically use for searching process so […]
Mysql Query tips & tricks
Few Mysql queries that will help you develop websites and resolve complex codes. Here are few Mysql Query tips: Finding 2nd highest salary in employee table SELECT MAX(`salary`) from tbl where `salary` < (select MAX(`salary`) […]
Mysql update fields with random sentence
Sometimes we need to add demo text in a website for checking whether it working fine or somewhere we test website with demo text. So on this case unwanted text inserted into database and you […]
Search from serialized field in mysql database
Suppose you have a serialize string that have various values in different position and you need to search from serialized field. You want particular key’s value using MySQL query. It is very easy with MySQL […]