same data inserted 2 times in database

pls help me, i have table studentmaster(firstname,lastname,fathername,phone,address). i am inserting data into database 2 times the data will be inserted. forexample: firstname lastname fathername phone address mithu tum vinay 80055 ban mithu tum vinay 80055 ban

View Answers

March 14, 2011 at 1:03 PM

Post the sql query which you have used.

Anyways, try the following:

insert into studentmaster(firstname,lastname,fathername,phone,address) values('aaaa','bbbb,'cccc',1111,'delhi');

Ads

Advertisements

Display error message if data is already inserted in database
Display error message if data is already inserted in database Display error message if data is already inserted in database Pls help me Thanks

displaying data based on criteria from 2 tables having same type of data - Java Beginners
displaying data based on criteria from 2 tables having same type of data ... my code. Basically, I have 2 forms already. One for tutors and the other.... it enables me to enter the ID of the parents. 2. based on the ID of parents I will know

Can u print in turbo c 9 8 7 6 5 4 3 2 1 0 using pre increment operator Only use print ++a in the same printf() command ten times)
Can u print in turbo c 9 8 7 6 5 4 3 2 1 0 using pre increment operator Only use print ++a in the same printf() command ten times) Can u print... ++a in the same printf() command ten times

Can u print in turbo c 9 8 7 6 5 4 3 2 1 0 using pre increment operator Only use print ++a in the same printf() command ten times)
Can u print in turbo C Can u print in turbo c 9 8 7 6 5 4 3 2 1 0 using pre increment operator Only use print ++a in the same printf() command ten times

show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access
show null point Exception """ while trying 2 load a JComboBox"" data is fetch from database ms-access import javax.swing.*; import java.awt....,"connected to database"); stat=con.createStatement(); String ss="select name from data

generating mock data class of times (start and end time and value)
generating mock data class of times (start and end time and value) Using the timertask function want to generate a set of mock data of times using the random DATE class and values for plotting on a graph using java. How

insert data into database
and studentmaster is the database table name. i am using same details. Now give the data into the jsp page that data stored into the database.Here the error...insert data into database hi,thanks for reply just i am doing

inserting same data to different tables in oracle
inserting same data to different tables in oracle Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can

how to show data in database ?
how to show data in database ? how to show the data in the database to the user in the textbox so that user can modify it and save it again

database is connected but not insert the data
database is connected but not insert the data hi, i am getting connected to database.Retrive the data also but cannot insert the data into database...); if(i!=0) { msgsuccess=" Record Inserted Successfully

how to restrict user against marking same event more than one times - JSP-Servlet
how to restrict user against marking same event more than one times ...(event) is stored in final database. Now how can I restrict the student against giving multiple time same test. Is it possible that once user marked particular

insert and delete data in database
insert and delete data in database insert and delete data in database from servlets through JDBC Hi Friend, Please visit the following links: Insert Data Delete Data Thanks

Saving data in database
Saving data in database hello i m facing a strange problem if i am submitting data form database then i can see it in database but if am submitting from app then it is not showing in to database but when i fetching form

database data in xml format
database data in xml format HI, i want to display the database data in the xml format(not as xml file ) on the console using DOM. help will be appreciated. THANKS K.K

value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing. <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8

Retriving data stored in database
Retriving data stored in database Hi, How to retrive data from my sql database using Hibernate,Spring and tapestry please give me an example.I am new to this Hibernate and Spring

selecting data from database
selecting data from database how to select data from database using Dao in struts Hi, You have to load the data from database using hibernate and send the data in a Java file object to jsp page. Please read at http

Transfer Data to Sql Database
Transfer Data to Sql Database Hey guys, how to Transfer data to SQl database using Java? Transfer data already stored in excel to Sql databse using Java? Looking for an easier method so i can comprehend

retrive data from database
retrive data from database hi.. i made a application form. it's have attribute s.no,name,roll no and i enter a few records. now i want to view all record not in database access sheet i want to view it at any another

unable to insert data into database
unable to insert data into database hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based

Ads