Problem with local host and server...

Hi,I am facing a problem, I want to update tables that is in my local host server which is now I m using Access , and i want to update my values in server database which is MySQL, is dere any option to do dat...please help me out of dis problem...thanks

[267 byte] By [nitin.vatsa] at [2007-11-27 6:14:43]

«« Storing database values
»» problem with MySQL SERVER

# 1

Hope this works...

Connection conn = java.sql.DriverManager.getConnection(url, username, password);

Statement stat = conn.createStatement();

int numberOfAffectedRows = stat.executeUpdate("UPDATE table_name

+ " SET column_name = new_value"

+ " WHERE column_name = some_value");

tk393a at 2007-7-12 17:24:29 >