Though you can import the CSV directly in DB, but importing it with an importer gives you more control over the data manipulation while importing.Below is the Script you will be needing for that.<pre class="ql-syntax" spellcheck="false">&lt;?php
/**
 * importer for CSV in MySQL DB.
 * pleas keep the CSV file in the same directory and run :
 *
 * &gt; php ./import.php
 */

$host = "localhost"; // Host name.
$db_user = "root"; //mysql user
$db_password = ""; //mysql pass
$db = ''; // Database name.

$con = mysqli_connect($host, $db_user, $db_password, $db);

// Check connection
if (mysqli_connect_errno()) {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$file = fopen('filename.extension', "r");
while (($data = fgetcsv($file, 100000, ",")) !== FALSE) {
 $sql = "INSERT into hs_codes(col1, col2, col3) values('$data[0]', '$data[1]', '$data[2]')";
 mysqli_query($con, $sql);
}

fclose($file);
echo "CSV File has been successfully Imported.";
</pre>

Though you can import the CSV directly in DB, but importing it with an importer gives you more control over the data manipulation while importing.

CSV Importer script for PHP

there might be other ways but, i find this one the easiest<pre class="ql-syntax" spellcheck="false">where user_type COLLATE utf8mb4_0900_as_cs = 'p'
</pre>the above query will bring up all the users with user_type 'p' in lower case.

How to make a where query in MySQL with Case Sensitive query string

In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky. you can find more about associations <a href="https://sequelize.org/master/manual/assocs.html" rel="noopener noreferrer">here</a>Before getting any further, if you want to get a setup for fully function code setup <a href="https://github.com/msamgan/expressjs-api-boilerplate" rel="noopener noreferrer">here it is</a><h2>Preface</h2>For the sake of understanding, lets consider two Models please inside the model directory, models/author.js and models/post.js. Models will look like as follows respectively.<h2>Author Model (models/author.js)</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="2221063348">'use strict';
const {
 Model
} = require('sequelize');
module.exports = (sequelize, DataTypes) =&gt; {
 class Author extends Model {
 /**
 * Helper method for defining associations.
 * This method is not a part of Sequelize lifecycle.
 * The `models/index` file will call this method automatically.
 */
 static associate(models) {
 // define association here
 }
 };

 Author.init({
 slug: DataTypes.STRING,
 name: DataTypes.STRING,
 }, {
 sequelize,
 modelName: 'Author',
 tableName: 'authors',
 });


 return Author;
};
</pre><h2>Post Model (models/post.js)</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="3112237828">'use strict';
const {
 Model,
} = require('sequelize');

module.exports = (sequelize, DataTypes) =&gt; {
 class Post extends Model {
 /**
 * Helper method for defining associations.
 * This method is not a part of Sequelize lifecycle.
 * The `models/index` file will call this method automatically.
 */
 static associate(models) {
 this.belongsTo(models.Author, {as: 'Author'});
 }
 }


 Post.init({
 slug: DataTypes.STRING,
 title: DataTypes.STRING,
 excerpt: DataTypes.STRING
 }, {
 sequelize,
 modelName: 'Post',
 tableName: 'posts',
 });

 return Post;
};
</pre>As shown in the post model, a belongs too association is made between Post and author. But as the comment suggest, associate method is not a part of Sequelize lifecycle. we have to call it manually.To achieve that, we need to create models/index.js with the following content.<h2>models/index.js</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="3338581372">'use strict';

const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';
const config = require(__dirname + '/../config/database.json')[env];
const db = {};

let sequelize;
if (config.use_env_variable) {
 sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
 sequelize = new Sequelize(config.database, config.username, config.password, config);
}

fs
 .readdirSync(__dirname)
 .filter(file =&gt; {
 return (file.indexOf('.') !== 0) &amp;&amp; (file !== basename) &amp;&amp; (file.slice(-3) === '.js');
 })
 .forEach(file =&gt; {
 const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);
 db[model.name] = model;
 });

Object.keys(db).forEach(modelName =&gt; {
 if (db[modelName].associate) {
 db[modelName].associate(db);
 }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

</pre>Ones you are done with this you can access all you models vie models/index.js<h2>Accessing Models</h2><pre class="ql-syntax" spellcheck="false" data-cacher="true" data-cacher-block-id="4182884854">const {Post, Author} = require('../../models');
</pre>You can find more about hoe to use association in accessing data <a href="https://sequelize.org/master/manual/creating-with-associations.html" rel="noopener noreferrer">here</a>GitHub Repo for the <a href="https://github.com/msamgan/expressjs-api-boilerplate" rel="noopener noreferrer">above code</a><div class="inline_html" contenteditable="false"><iframe width="100%" height="500" src="https://www.youtube.com/embed/ctdMkbwHBU0" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen=""></iframe></div>

In the very initial days of my work in Node JS if faced this issue. Though Sequelize provide a great ORM for MySQL but the association within the models is a bit tricky.

How to create model association in Sequelize - express JS / Node JS

How to create model association in Sequelize 
 - express JS / Node JS

As you know regular backups of DB for a running site are very important. Most of the hosting providers do this for you, but sometimes its also expected from you to do the same.The easiest way is to create a Replica of the current DB through the command line and download it.Below is the command for doing the same. I am assuming that you are already logged in your server through ssh.<h2>Command</h2><pre class="ql-syntax" spellcheck="false">mysqldump -u DB_USERNAME -p DB_DATABASE &gt; FILENAME.sql
</pre>It will ask for the password but you can handle it.Moreover, if you want to take backup of particulate tables from the database you have to pass the name of the tables separated by space.<pre class="ql-syntax" spellcheck="false">mysqldump -u DB_USERNAME -p DB_DATABASE TABLE_1 TABLE_2 &gt; FILENAME.sql
</pre>Feel free to ask in the comment section in case of any doubt.

How to take MySQL DB back up from the command line

upload your SQL file to the serve through FTP. Ones the file is on server you can user the following command.<h2>Assumptions</h2><ul><li>you have created a DB</li><li>you have already create a DB user with privileges as per required.</li><li>you have ssh access to the server</li><li>you know how to log in through ssh into your server.</li></ul><h2>Command</h2><pre class="ql-syntax" spellcheck="false">mysql -u db_user_name -p db_name &lt; /complete/file/path.sql
</pre>If you are using amazon RDS, you need to alter the command by adding the host to the command<pre class="ql-syntax" spellcheck="false">mysql -h host -u db_user_name -p db_name &lt; /complete/file/path.sql
</pre>Queries and comments are welcome.

Command to import DB through the command line in MySQL

Although the development has taken a great deal of up-gradation in the last few years with DevOps, frameworks, automation etc. etc. etc. but still there are a number of people who still prefer the old way. Moreover, if you are starting new of just creating a college project or something like that it’s still cool to use the core PHP.The inputs in Core PHP are venerable to what you call “SQL Injection”, to before putting them to use it’s a mandatory practice to sanitize them. Below is the function you can use for the same. It’s simple, straight forward and easy to use.<h2>Benefits:</h2><ul><li>It reduces the threat of SQL injection by removing the SQL (if there is any)</li><li>It also removes the HTML tags from the data passed as some bad guys pass &lt;scripts&gt; too for some undesirable works.</li></ul><h2>Uses:</h2>Using the function is simple all you have to do is make sure that it needs&nbsp;mysql_connection&nbsp;links to function. Please make sure you provide it. Remaining is nothing to worry about.<h2>Function:</h2><pre class="ql-syntax" spellcheck="false">/**
 * protecting the input form the SQL injection and script injection.
 * @param $data
 * @return mixed
 */
public function sanitizer ($data)
{
 if (!empty($data)) {
 foreach ($data as $key =&gt; $dataValue) {
 if (empty($dataValue)) {
 continue;
 }
 $dataValue = strip_tags($dataValue);
 $data[$key] = mysql_real_escape_string($dataValue, $this-&gt;link);
 }
 }

 return $data;
}
</pre><h2>Function Call:</h2><pre class="ql-syntax" spellcheck="false">$object = new Class();
$sanitizedGetArray = $object-&gt;sanitizer($_GET);
$sanitizedPostArray = $object-&gt;sanitizer($_POST);
</pre>If you have some other things to add to this function feel free to comment, I am still learning too you know.

The inputs in Core PHP are venerable to what you call “SQL Injection”, to before putting them to use it’s a mandatory practice to sanitize them

How to sanitize Input in PHP  - Code By Samgan

How to Sanitize Input in PHP

There are a number of MySQL client but so far&nbsp;phpmyadmin&nbsp;is one of the popular MySQL client used. It’s simple to use, effective and provide almost all the required features for day to day development.Connecting to remote is something you don’t need so often but when you need it, I can bet it’s a critical situation. Here below we will discuss 2 simple steps to add a remote connection to your&nbsp;phpmyadmin.<h2>Step 1: Updating the configuration</h2>Open your&nbsp;phpmyadmin&nbsp;installation, if you are using XAMPP, you will find it the XAMPP installation directory. Once you are in the&nbsp;phpmyadmin&nbsp;installation, open “config.inc.php”<h2>Step 2: Copy and Paste</h2>In this file, you will find the configuration for the localhost, copy and paste the same with the remote details.And we are done.Now you will be able to see remote details in the drop-down

There are a number of MySQL client but so far phpmyadmin is one of the popular MySQL client used. It's simple to use, effective and provide almost all the required features for day to day development.