11-07-2019 12:57 AM
My Database have 7 columns in total.I want to delete row of other columns except the first column. In short I want the first column Unaffected when I'm doing delete operation. Is it possible to do?
If yes kindly help me with solutions.
Thanks in advance.
11-06-2019 11:01 PM
hey
I'm also doing the same exercise but here i want to delete a row of selected columns only..for eg:
if my table have 3 three columns col_0 = Sr no , col_1= Name and col_2= id number; so i have to delete only rows of col_1 and col_2 not col_0. Is it possible with database connectivity tool in labview. If so Please help me to find solution.
11-07-2019 09:46 AM
Are you wanting to modify the data in the database or modify the table structure to remove the columns? The only way that I know where you can delete columns of data is to set the value to NULL or 0 or ''(empty string), etc.
UPDATE table_name SET column = 0 (or NULL or "") WHERE filter_column = some_value