[MySql] How to add/delete a column from commandline

Following command is used to delete a column from a table:

ALTER TABLE <table_name> DROP COLUMN <column_name>;



Following command is used to add a column in table:

ALTER TABLE <table_name> ADD <column_name> <datatype> ;


No comments:

Post a Comment

Scheduling Repeating Local Notifications using Alarm Manager

Learn about Scheduling Repeating Local Notifications using Alarm Manager in this post .