java - Moving particular row from one table to another in mysql -


I am developing a web application ... which will be the list of users requesting registration ... We accept that all the details should be taken from the register table to enter the table ...

  created space ps = conn.prepareStatement ("Login (id, first Name, last name, gender, category, date of birth, age, address, country, state, city, postcode, email id, contact No, mobile number) * Select * from the register; I have to insert all the data from the register table, when I accept it. But when I copy the entire table from the register to the log in table to run it. When I click, only details of that particular user should be taken .... ID should be obtained from that particular user ... How to do this Please help me please ... This advance You must add a WHERE clause to the SQL statement:  

  log in login (id, first name, last name, gender, ...) SELECT * registers where id =?  

Then bind the ID parameter to the created location :

  created locations Ps = Conn.prepareStatement (...); Ps.setInt (1, id); Ps.executeUpdate ();  

In this way you are limiting your choice only to return the line you are interested in and feed it in INSERT.


Comments

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -