Create Two Table
First Table : employees
CREATE TABLE employees (
employeeNumber INT(11) ,
lastName VARCHAR(200),
firstName VARCHAR(200),
extension VARCHAR(200),
email VARCHAR(100),
officeCode VARCHAR(100),
reportsTo INT(11),
jobTitel VARCHAR(100)
)
Insert value in the 1st table employees
insert into `employees`(`employeeNumber`,`lastName`,`firstName`,`extension`,`email`,`officeCode`,`reportsTo`,`jobTitel`)...
Popular Posts
-
Export word file using jsp Here is jsp file word.jsp <%@ page language="java" contentType="text/html; charset=ISO-885...
-
Hello friends today I am telling about generate random number in java using UUID, UID and MessageDigest. Here is program RandomNo... -
when using the GET method, parameter names and their values get submitted on the URL string after a question mark. Different parameter name... -
Javascript provides an easy way to Base64 encode and decode a string, using which we can encode decode a string to base64 on the fly.... -
Create Excel File in java In this example I select data from database and write that data into a Excel file. import java.io.File; im...
-
In this tutorial we will go over all steps in details to delete Files and Folders on Windows OS, Mac OS X and Linux . Here I Cre... -
In this tutorial we show how can you read the contents of an XML File using a DOM parser. This xml contains list of employees (id,na... -
A shallow copy would copy the object without any of its contents or data, In copied object all the variables are passed by reference from t...
-
Disable right-click using jQuery $(document).ready(function(){ $(document).bind("contextmenu",function(e){ retu...
-
Export Excel file in jsp Here is jsp file excel.jsp <%@page import="java.text.SimpleDateFormat"%> <%@page import=...