data base question

data base question

View Answers

January 16, 2009 at 11:32 PM

Hi,

Query to create table "employee"

Create table employee(ID int,name nvarchar (10),salary int,start_date datetime,city nvarchar (10),region char (1))

Alter table "employee" with primary key :

ALTER TABLE Employee ADD CONSTRAINT PK_EmployeeID PRIMARY KEY (ID)

For any more information,Examples and Tutorials on Mysql visit to :

http://www.roseindia.net/mysql/

Thanks









Related Tutorials/Questions & Answers:
Data base related question
Data base related question  sir my table has only one element(that is pno),i am using ms-access as backend. i put only one element i want to retrieve that element .how can i retrieve that element,using jdbc technology. please
data base question - Java Interview Questions
data base question  first we create a table with out create primary kay,after that i want to create same record with primary key,but no duplicate record,no deletion and after creation.  Hi, Query to create
Advertisements
data base
data base  how to connect coding in data base ?   The given code connects JSP page to database. You need to import the mysql connection jar file to jdk as well as to the lib of tomcat. Moreover you need to set classpath
DATA BASE
DATA BASE  Create a program to establish a connection to the PCTBC... the data using a J Table.   Here is a code that connects to MySql... main(String[] args) { Vector columnNames = new Vector(); Vector data = new Vector
Data base Connectivity
Data base Connectivity  How to configure JDBC connection for Oracle data base.In configuring it is asking select Data server name and TNS.I typed Oracle for Data Server Name and IN TNS what to type? I pulled the list for TNS
JSP data base validation
JSP data base validation  please explain how to validate form input string with database n also how its notify that entered data exists already... bol = ps.execute(); out.println("Data Added Successfully
Data base - JDBC
Data base  I want to do this Inserting a record with Object type column using PreparedStatement but wht should b the column datatype this is te..."); con.close(); }//main }//class For this should i create a user defined data type
please send me the banking data base in swings
please send me the banking data base in swings  sir, please send me how to create the banking data base program in swings
ModuleNotFoundError: No module named 'odoo10-addon-l10n-br-data-base'
ModuleNotFoundError: No module named 'odoo10-addon-l10n-br-data-base' ...: No module named 'odoo10-addon-l10n-br-data-base' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-l10n-br-data-base' error
ModuleNotFoundError: No module named 'odoo8-addon-l10n-br-data-base'
ModuleNotFoundError: No module named 'odoo8-addon-l10n-br-data-base'  ...: No module named 'odoo8-addon-l10n-br-data-base' How to remove the ModuleNotFoundError: No module named 'odoo8-addon-l10n-br-data-base' error
Question about "Insert text file data into Database"
Question about "Insert text file data into Database"  Hey I was reading the tutorial "Insert text file data into Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader
Retrive the data from the table in data base using jdbc
Retrive the data from the table in data base using jdbc  Retrive the data from the table in data base using jdbc   JDBC Tutorials
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp   data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp with script of data base plz help me
for store data in data base - JSP-Servlet
for store data in data base  i want to a job site, in this site user can registered by a form.. in this form there are his information... i use..... and on 3rd form i use submit button... data of form 1 and 2 can also be store
when refreshing the page the data is stored in data base again
when refreshing the page the data is stored in data base again  Hi, In my application, I am adding form data in database on click of submit button.But the problem is, when user refreshes the page, the data added one more time
Retrieving data from data base using jsp combo box
Retrieving data from data base using jsp combo box  Hi guys please help me , i have on GUI page int that Server type(like apache,jboss,weblogic) one combo box is there and another filed is version of the server(like 1.0,2.0) like
retrive data from data base and print it in every page until logout
retrive data from data base and print it in every page until logout  suppose that a user login your website through user name & password. now after completion of login he goto home page.inside home page i want to print
question
question  Good Afternoon Sir, give me the source code to submit attendance to data base using System IP Address with system date and time.using JPanel+mysql+java
question
question  i need a jsp/html program which includes drop down menu for leave types and a button for apply leave.and need another jsp to validate types of leave and then insert in to data base using mysql
question
question  how to put every data base connections (selection,insertion ,updation and so on) in one jsp page and how to import that in other pages of one project
question
question  good afternoon sir, i need a jsp/html program which includes drop down menu for leave types and a button for apply leave.and need another jsp to insert types of leave which is selected by the user ,in to data base
question
question  good afternoon sir, i have a project in jsp which contains attendance marking.i could mark present successfully but i want to list absentees.i need a jsp code to insert absent,half day leave in to data base while user
What is the average base salary of a Data Scientist reported by The New York Times?
What is the average base salary of a Data Scientist reported by The New York Times?  Hi, I am beginner in Data Science and machine learning field. I... base salary of a Data Scientist reported by The New York Times?". Also tell
Struts2 and Hibernate Fetch Data Base Value
Struts2 and Hibernate Fetch Data Base Value  Hello Sir, I am...;AdminProvideLeave>(); try { > Query q = session.createQuery("from >...;AdminLeavePojo> adlp = null; > try { Query q = > session.createQuery
Struts2 and Hibernate Fetch Data Base Value
Struts2 and Hibernate Fetch Data Base Value  Hello Sir, I am...;AdminProvideLeave>(); try { > Query q = session.createQuery("from >...;AdminLeavePojo> adlp = null; > try { Query q = > session.createQuery
data fecth from data base in( sql 2000) htmlform and jsp
data fecth from data base in( sql 2000) htmlform and jsp  hi iam using jsp and html form data fecth from database display the textbox help me i want whenever select from dropdown list select the projectname to display
insert excel value in to oracle data base
insert excel value in to oracle data base  Hi All I am using...); System.out.println("Data is inserted..., You can read the data from the excel file using JDBC. For this you need
java code for threading example for connecting data base
java code for threading example for connecting data base  Write a program that has two threads First thread queries the database and fetches all the employee records from the emp table. Stores the employee objects
question
question   sir plz tell me what should i give in title box. just i want java program for the question typed in this area
question
question   sir plz tell me what should i give in title box. just i want java program for the question typed in this area
Question
Question   When there is an exception in my program how java runtime system handles
question
question  dear sir/madam my question is how to compare two text format in java..we are java beginners..so we need the complete source code for above mentioned question...we have to compare each and every word
question
question  Dear sir i had some typing mistake at previous question so its my humble request to let me know the steps to start the tomcat6 under the tomcat directory
question
question  how to insert data in to table using bean + jsp
question
question  sir, i need a jsp+mysql query to select data from two table for a perticular user eg:select data from employee and leave table for john.please help me
question
question  how do i select four late from data base.late represents 'L
question
question  I am doing a project using struts framework and spring jdbc .I have a issue that when data is inserted into database if we click the refresh button then the same data is again inserted in to the database.What
question
question  how to solve this problem com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect time value: ' 0:34:13 PM' for column 'afternoon' at row 1
question
question  i need a jsp and mysql program to retrieve data from employee table and attendance table using user name and password at a time
question
question  i need to select data from database using mysql+java script+html   Please specify some more details
question
question  Sir, Could You please send me Data Flow Diagrams(DFD) for " A DISTRIBUTED PROTOCOL TO SERVE DYNAMIC GROUPS FOR PEER-TO-PEER STREAMING
Question
Question  Sir, give me a Java program to read data from keyboard up to names , sort in alphabetical order using bubble sort
how to insert the bulk data into the data base from the table of jsp page to another jsp page
how to insert the bulk data into the data base from the table of jsp page to another jsp page  pls help i'm doing the project called centralized... to insert the marks details into the data base i have retrive the rollno and name
question
question  i need a jsp and mysql program to retrieve data from employee table and attendance table using user name and password at a time for a Sign in user
Question
Question  Sir, please help me to write a JAVA program to read data from keyboard up to names and sort in alphabetical order using bubble sort
question
question  how to retreive data from database of a particular user after login using jsp+hiberante+struts configuration.   Please go through the following links: http://www.roseindia.net/struts/hibernate-spring
question
question  Gud morning sir, I have asked u some question regarding jsp in saturaday for that i didnot find any answere in which u send me the some of the links.U have asked me the specify some details. There is a entity name
Question?
Question?  My question is how to: Add a menu bar to the program with a File menu. In the File menu, add a submenu (JMenuItem) called About. When the user clicks on the About menu item, display a JOptionPane message dialog
question
in data mining [7], to measure the interestingness of a particular keyword/phrase ci extracted from the web-snippets arising from q: interestingness of a particular keyword/phrase ci with respect to the query q: support(ci ) = sf (ci )·|ci
question
)); } for(StudentData data:list){ if(data.getMarks()>=60... record: "); int rec=input.nextInt(); for(StudentData data:list

Ads