MySql Feed
MySql
MySql

MySql is an open source database and being managed by Oracle team.

How to save Arabic in MySql database?

To save an Arabic text into your MySql database table, you first check the table column is set to "utf8" or not. If...

Get MySql Query to show messages, username of a ch...

Suppose there are two tables `chat` and `users`. `chat` have four columns id, sender, receiver and message and `u...

Latest Interview Questions and Answers of PHP, jQu...

Please find below the Latest interview questions and answers: jQuery: 1- What is event capturing and bubbling? ...

How to change your mysql root user password?

To update the mysql root user password you will need to follow below steps and it will be updated without any probl...

How to connect with MySql database and execute que...

You can connect with MySql database in Python using mysql connector python. You will need to install it first usin...

How to calculate date interval between two dates i...

I'm going to share how to calculate the date intervals between two dates like calculating 1 month before, two w...

How to connect python with MySQL database?

Before using mysql, you need to install mysql.connector module. Use the below command to install it: $ sudo apt-ge...

How to connect django with MySql database?

Django comes with sqlite as database backend but you can use any of the database as per your need. To use MySql as...

How to get records from certain offset up to the e...

To get the all records from a specific offset up to the end of the result set, use the below MySql query and will s...

How to update mysql user password using command?

I assume you have already a mysql user which password want to update or change. You will need to login into your my...

How to import and Export large Database in MySql u...

You just need to login to your server where mysql is installed and start using below commands. It is very easy ...

How to solve mysql query error when using table na...

In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds t...

How to export and restore few tables in mysql data...

We can export some/partial number of tables from mysql database and below are the commands which you can use and pu...

How to check which mysql version is available to i...

If MySQL is not installed, you can check the available versions in the Ubuntu repositories using the following comm...