... Unfortunately, the MS Excel software adds tab characters to delimit the columns...
How?
UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`));
Source: Stack Overflow - How to ...
... `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'À', 'A');
UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'Á', 'A');
UPDATE `myTable` t SET t.`myColumn`=REPLACE(t.`myColumn`, 'Â', 'A');
UPDATE ...
...
-- return all records that contain non-alphanumeric characters
SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$';
-- return all records that are non-alphanumeric but ignore underscores
SELECT ...
...
All SQL
-- Add a column to an existing table (giving it datatype char(2) and allowing NULL)
ALTER TABLE myTable ADD myColumn CHAR(2) NULL
-- Delete a column
ALTER TABLE myTable DROP COLUMN ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.