How to Build Lightning-Fast Web Apps: Database Optimization Techniques for MySQL & MongoDB
How to Build Lightning-Fast Web Apps: Database Optimization Techniques for MySQL & MongoDB Most “slow website” complaints are not actually frontend problems. In many real-world projects, the bottleneck lives in the database layer. Whether you’re using MySQL or MongoDB, understanding …
Import CSV File Into MySQL using LOAD DATA INFILE
In this post we are discussing on how to use LOAD DATA INFILE statement to import CSV file into MySQL table. The following statement imports data from c:\tmp\data.csv file into the discounts table. The field of the file is terminated …
Map integer to text string in mysql
We can use the functions CASE .. WHEN … to map integer to text string in mysql The example query is as shown below You can also use the ELSE clause to specify a default, e.g.
Remove rows with multiple duplicate columns
Some times we need to remove rows with multiple duplicate columns as shown in the table below,See the last two rows with same values. ID college courses 183 24 102 151 24 52 155 24 66 179 24 66 With …
