|
|
| SQL error |
Expert:Jagadeesh
Hello friends,
Can we update a column with referrence to that column value. For example, the query
-----------------------------------------------------------------------------
"update feedback set msgid="+id+" where msgid="+inc+""
-----------------------------------------------------------------------------
can work properly. Here, id and inc both are integer values. inc is the incremented value already existing in the database and id is the value to be replaced. This modification is neccesary one for my project.
If it is not possible please send me an alternate option to solve this. Help me. |
| Answers |
Hi friend its possible...
Here is the solution..
import java.sql.*;
public class CreateTable{
public static void main(String[] args) {
System.out.println("Table Creation Example!");
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "jdbctutorial";
String driverName = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";
try{
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(url+dbname,userName,password);
try{
Statement st = con.createStatement();
String table = "update feedback set msgid="+id+" where msgid="+inc+"";
st.executeUpdate(table);
System.out.println("Updated successfully!");
}
catch(SQLException s){
System.out.println("Error occured while updating!!!");
}
con.close();
}
catch (Exception e){
e.printStackTrace();
}
}
}
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
