sql - Are there any suggestions for replacing specific characters in MariaDB tables, and table columns? -
i'm having difficulty replacing " ". understand mariadb's sql syntax allows replacing characters (via string); i've attempted so, continues giving me same error of not recognizing structure of syntax.
on side note, aware of functions, triggers, , or modules allow autonomous alteration of table, columns, enable/permit/allow name changing, when table's created?
(from comment)
alter table xover_sao modify column 'abell object' 'xover_sao_object' varchar(255); -: alter table xover_sao modify 'abell object' 'xover_sao_object' varchar(255); -: alter table xover_sao modify 'abell object' replace('abell object', ' ', '' ); -: alter table xover_sao modify 'abell object' replace('abell object', ' ', '' );
modify
not allow changing name.
no expressions allowed col_name
.
so, closest possible:
alter table xover_sao change column 'abell object' 'xover_sao_object' varchar(255);
but sure include thing else in definition, such not null
, character set
, etc.
Comments
Post a Comment