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.
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.
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