mysql - how to enter the record with only whitespace
I want to enter the record with white-space as a record in MySQL. I had tri开发者_如何学编程ed to enter it through shell and phpmyadmin, the record enters but when I try to retrieve the record it returns as null. I had also set the column null = no even then returns nothing.
code is below through shell and php:
insert into first_replace(to_replace, with_replace) values(".", " ");
when creating mysql table row enable NULL or edit row and enable NULL
精彩评论