i will be glad if i could be given any advice or example coding to delete a column from a table
eg this is the table
unique field fieldcolumn1 fieldcolumn2 feildcolumn3
111 <somedatat> <somedata> <somedata>
some if fieldcolumn1 is checked with a checkbox only that part should be deleted from the table without affecting the rest. more fields could be checked as well.
so the resulting table will look like:
unique field fieldcolumn1 fieldcolumn2 feildcolumn3
111 <deleted from table> <somedata> <somedata>
thank you
delete check colum
Moderator: General Moderators
- hawkenterprises
- Forum Commoner
- Posts: 54
- Joined: Thu Feb 28, 2008 9:56 pm
- Location: gresham,oregon
- Contact:
Re: delete check colum
ALTER TABLE table_name
ADD column_name datatype
ALTER TABLE table_name
DROP COLUMN column_name
Taken from w3schools.com
ADD column_name datatype
ALTER TABLE table_name
DROP COLUMN column_name
Taken from w3schools.com