User:Feixie/SQL

Tips
Example: kfsql -SXX -DXX -c 'update Table set field="blaa blaa; blaa"' the semicolon in field will be omitted. you can fix by: kfsql -SXX -DXX -c 'update Table set field="blaa blaa" + char(59) + "blaa"'
 * semicolon is command terminator by default, so you can't simply set it as part of sql statement. You may need to escape it.