Search This Blog

24 August, 2012

Trimming all fields in MySQL database

UPDATE `table1` SET `tbl_column1`= trim(`tbl_column1`);

The above SQL query  will trim all the fields in the tbl_column1


at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

tmux enabling mouse interaction

Add the below line to the ~/.tmux.conf setw -g mouse on save the file and exit from the tmux shell, you should be able to use your mouse to ...