Browsed by
Category: mysql

Error While Installing mysqlclient in virtualenv

Error While Installing mysqlclient in virtualenv

While trying to connect MySQL database with Django 3.2 in my Ubuntu 18.04, I encounted this error.  I was not able to pip install mysqlclient in my virtualenv. This short tutorial is about how to fix this issue. If your MySQL setup is running perfect and you are unable to install mysqlclient in virtualenv then first check if there is no installation error outside the environment. If mysqlclient shows no issue then try with the…

Read full Article Read More

Fix: The file size exceeded the maximum size permitted by your PHP configuration

Fix: The file size exceeded the maximum size permitted by your PHP configuration

You might have encountered this error while uploading database using phpmyadmin dashboard. The default size is 2MB in php.ini for “upload_max_filesize“. Change the value of upload max filesize to your desired size say 20MB. And also need to change post_max_sizeif you have changed upload_max_filesize greater or equal to upload max filesize.  post_max_size must be greater or equal to upload_max_filesize. If you are ubuntu user then first locate your php.ini. Use bash  command “locate php.ini” to locate…

Read full Article Read More

Difference Between ALTER and UPDATE in database ?

Difference Between ALTER and UPDATE in database ?

ALTER is a DDL (Data Definition Language) statement. Whereas UPDATE is a DML (Data Manipulation Language) statement. ALTER is used to update the structure of the table (add/remove field/index etc). Whereas UPDATE is used to update data. Example of ALTER: ALTER TABLE Persons ADD PRIMARY KEY (P_Id) Example of UPDATE: UPDATE table_name SET column1=value1,column2=value2,… WHERE some_column=some_value;

Installing and Running mysql in Linux/Ubuntu

Installing and Running mysql in Linux/Ubuntu

This is short article to give basic instruction how to install mysql in Linux from terminal. First open terminal and use this command: sudo apt-get install mysql-server During the installation process you will be prompt to install root password. After the installation process is completed you can check whether mysql server is running or not by using following command. sudo netstat -tap | grep mysql When you run the above command you may see the…

Read full Article Read More