Update All records
-
Hi, I use MS Access 2003 database and I want to Update all records in 1 column. How to make this in once? I use VB.NET
I would try a regular update statement without a WHERE clause, as in:
UPDATE table_name SET column_name=value
:)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
-
I would try a regular update statement without a WHERE clause, as in:
UPDATE table_name SET column_name=value
:)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
-
In this column have numeric data from 1 to 12 and I want to increase them with 1 e.g. 1->2 etc
Have you tried
UPDATE table_name SET column_name=column_name+1
? :)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
-
Have you tried
UPDATE table_name SET column_name=column_name+1
? :)
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.