Optimize a MySQL database
One of the important thing for achieving MySQL database performance is indexing that allows faster gathering of data to optimize MySQL database. Here is the list to Optimize MySQL database: Indexing in MySQL will create […]
One of the important thing for achieving MySQL database performance is indexing that allows faster gathering of data to optimize MySQL database. Here is the list to Optimize MySQL database: Indexing in MySQL will create […]
When migrate data you need to compare two tables and identify the unmatched results records. Suppose you have two tables table1 and table2 with same columns and values. If any one table has any extra […]
Using MySQL ORDER BY Clause you can sort table columns by ascending or descending. Suppose we have a table ‘tbl’ with column ‘name’ and a row like below values: 1 1B 10 2 10C 2A […]
MySQL provides an easy way to export table result set into a CSV file. Suppose we have a query like: SELECT name, email, age FROM users WHERE status = ‘Active’; So if we need to […]
Based on patterns regular expression is a powerful tool which gives you a flexible way to identify strings like email, IP address, phone number etc. Use Regular Expression in Mysql: For example, you want to […]
You can show the null values which represent the concept of missing or inapplicable information, with other values for better data representation. Suppose we have a table as below: Name Country John India Jane Australia […]
It is very useful to copy table data from a old existing table to a new table when you need to back up data and replicating the production data for testing. To copy data from […]
You can add a sequential number as a custom row number of a row using SET clause and increment at next row. Suppose users table has columns name and age. When you want to show the […]
When you assign one field as a primary key you can use auto-increment attribute to that field. It generates unique identity for the row inserting a unique auto increment value. You can also reset auto […]
A database view is a virtual table which is defined as a SQL select query with JOIN statement. Same as database table it consists of rows and columns. When any data of a tables changes, […]