Feeds, issues, packages and code source about emulation and pograming, of VENENUX proyects, Debian related distros and massenkoh!

mysql to sqlite: COMMENTS error near - SOLUTION

When export or try to run a sql script into sqlite and have the "COMMENTS" keyword usage, sqlite arent able to procesed the script, due stupid developers does not handle support since many years:
LOOK HERE: http://sqlite.1065341.n5.nabble.com/Feature-request-add-support-for-COMMENT-statement-td69401.html

so the solution its to grep and replace (take easy, u can made it in geany of venenux) using a regular expresion:

1) open geany
2) load the script
3) menu->search->replace
4) marks use regular expr
5) the word to search will be COMMENT \'.*\'
6) the word to replace it will be empty
7) pull down avanced "Replace all" and select Document
8) that's all

now at least COMMENT keyword was eliminated from script and sqlite can procesed the sql.

0 comments/comentarios:

Publicar un comentario

si vienes de guindo, winbuntu o parecido, limitate y escribe algo util...