Browsed by
Category: database

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

Phpmyadmin Not Working After Installing In Linux

Phpmyadmin Not Working After Installing In Linux

Its easy to install phpmyadmin in normal case but in some case you have to go through the following command. For normal case sudo apt-get install phpmyadmin but in some cases although the installation is successful, you can’t access phpmyadmin panel by localhost/phpmyadmin on browser. For that case just add one line below in apache2.conf file. gksu gedit /etc/apache2/apache2.conf Then add the following line to the end of the file. Include /etc/phpmyadmin/apache.conf Then restart apache…

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