songs

Songs can be downloaded from the link
www.song.pk

Utility softwares

Many software which are required day to day  life can be downloaded from the link
http://www.filehippo.com/

creating MySql tables

 

mysql> CREATE DATABASE BANK ;    

  Query OK, 1 row affected (0.00 sec)   

mysql> USE BANK ;

Database changed

mysql> CREATE TABLE EMP

    -> (

    -> EMPNO INTEGER,

    -> ENAME CHAR(15),

    -> JOB CHAR(15),

    -> MGR INTEGER,

    -> HIREDATE DATE,

    -> SAL INTEGER,

    -> COMM INTEGER,

    -> DEPTNO INTEGER ) ;

Query OK, 0 rows affected (0.07 sec)

mysql> INSERT INTO EMP VALUES(8369,'SMITH','CLERK',8902,'1990-12-18',800,100,20);                                                                            

  Query OK, 1 row affected (0.04 sec)         

                                 

mysql> SELECT * FROM EMP ;

EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
8369	SMITH	CLERK	8902	1990-12-18	800	100	20
8499	ANYA	SALESMAN	8698	1991-02-20	1600	300	30
8521	SETH	SALESMAN	8698	1991-02-22	1250	500	30
8566	MAHADEVAN	MANAGER	8839	1991-04-02	2985	200	20
8698	BINA	MANAGER	8839	1991-05-01	2850	400	30
8839	AMIR	MANAGER	8840	1991-11-18	3000	200	10
8993	TAJINDER	SALESMAN	8888	1992-03-11	3300	210	10
8999	HARPREET	CLERK	8878	1992-03-20	300	100	20

Prime Number series

public static void main(String[] args) {

int f,i,j ;

    System.out.println("LIST OF PRIME NUMBERS FORM 1 TO 50/N");

    for(i= 2;i<=50;i++)

    {

    f = 0;

    for(j=2;j<i;j++)

    {

 

      if(i% j==0)

            f=1;

    }

    if(f==0)

        System.out.println(i);

    }

   

    }

}