wirelessr
10/12/2017 - 7:21 AM

sql common uses

Add a column

echo "ALTER TABLE tname ADD column INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER insert_column ;" | mysql dname

Delete a colume

echo "ALTER TABLE tname DROP column ;" | mysql dname