Browsed by
Day: July 30, 2015

Difference Between ALTER and UPDATE in database ?

Difference Between ALTER and UPDATE in database ?

Comments 0 Comment

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

Comments 0 Comment

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