How to update table data?

Results 1 to 2 of 2

Thread: How to update table data?

  1. #1
    Martin, Sweden Guest

    Default How to update table data?

    I have an Access db, with one table that contains just one field!<BR><BR>table name = news<BR>table field name = data<BR><BR>I want to use the SQL statement UPDATE to replace information in the table field, with some new information!<BR><BR>Now I have to delete the first row in "data", and then insert a new row!<BR><BR>Are you able to use the UPDATE command to replace the information i the "data" field with some new information?<BR><BR>Please help me out dudes!<BR><BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: How to update table data?

    Hi, it&#039s Leonardo from Argentina.<BR><BR>Sure that you can use the UPDATE statement to update the field contents. The syntax is the following:<BR><BR>UPDATE table_name<BR>SET field_name = new_value<BR>[WHERE field_name = some_value]<BR><BR>The WHERE clause is optional, if you don&#039t put this, all the rows in the table will be updated.<BR><BR>Bye men.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts