Monday, October 24, 2005

Update all empty string data in MySQL Database to null

Update all empty string data in MySQL Database to null

update
<table_Name>
set <table_Name>.<field_name>=null
Where
ASCII(<table_Name>.<field_name>) = 0

0 Comments:

Post a Comment

<< Home