alter table remove not null constraint code example

Example 1: mysql remove unique constraint

ALTER TABLE tbl_name DROP INDEX index_name

Example 2: space not removing from column in sql

update thetable set thecolumn = rtrim(replace(thecolumn, char(160), char(32)))