3:53 pm - Wednesday March 25, 9936

Tag Archives: Jdbc mysql database

Statement SUM() Example program in java Jdbc mysql database

Create Table and  Insert values: Mysql>Create table EMP (name varchar(12),id int(5),salary int(10)); INSERT INTO EMP(name,id,salary) VALUES("Arun",1,2500 ); INSERT INTO EMP(name,id) VALUES("Dinesh",3...

Statement MIN() Example program in java Jdbc mysql database

Create Table and  Insert values: mysql>Create table EMP (name varchar(12),id int(5),salary int(10)); INSERT INTO EMP(name,id,salary) VALUES("Arun",1,2500 ); INSERT INTO EMP(name,id) VALUES("Dinesh",3 ); INSERT INTO...

Statement MAX() Example program in java Jdbc mysql database

Create Table and  Insert values: mysql>Create table EMP (name varchar(12),id int(5),salary int(10)); INSERT INTO EMP(name,id,salary) VALUES("Arun",1,2500 ); INSERT INTO EMP(name,id) VALUES("Dinesh",3 ); INSERT INTO...

Statement LAST() Example program in java Jdbc mysql database

Create Statement: Mysql> Create table EMP (name varchar(12),id int(5),salary int(10));<strong></strong> INSERT INTO EMP(name,id,salary) VALUES("Karthik",3,5000 ); INSERT INTO EMP(name,id,salary) VALUES("Tamil",4,2500...

Statement FIRST() Example program in java Jdbc mysql database

Create Statement and insert values in the table:   mysql>Create table EMP (name varchar(12),id int(5),salary int(10)); INSERT INTO EMP(name,id,salary) VALUES("Karthik",3,5000 ); INSERT INTO EMP(name,id,salary) VALUES("Tamil",4,2500...

Statement ORDERBYASC Example program in java Jdbc mysql database