I want to insert userid of a customer,order time,etc in a
table called ordermaster with orderid as primary key.Same
time the product codes and required quantities (a1,2 and a2
4 and so on)inserted in another table orderdetails with same
orderid reference.How the code will be in JSP using MySQL?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

How to use regular expression in pattern match conditions?

0 Answers  


Is oracle mysql free?

0 Answers  


I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

0 Answers  


Differentiate between FLOAT and DOUBLE?

1 Answers  






What is sql vs mysql?

0 Answers  


How many tables will create when we create table, what are they?

2 Answers  


What is heap table in mysql?

0 Answers  


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

0 Answers  


What language does mysql use?

0 Answers  


What are the steps required to view your mysql database?

0 Answers  


Is mysql a free database?

0 Answers  


Categories