Use NOT NULL if required
First of all think whether you require a NULL field or not.If having an empty string value can make any sense then use it otherwise use NULL value for a specific reason. So, Put NOT […]
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.
First of all think whether you require a NULL field or not.If having an empty string value can make any sense then use it otherwise use NULL value for a specific reason. So, Put NOT […]
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, […]
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 […]
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. […]
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 […]
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`) […]
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 […]