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.
Post Top Ad
Your Ad Spot
2017/03/14
Home
error near
mysql
sql
sqlite
sqlite field COMMENT
mysql to sqlite: COMMENTS error near - SOLUTION
mysql to sqlite: COMMENTS error near - SOLUTION
Tags
# error near
# mysql
# sql
# sqlite
# sqlite field COMMENT
sqlite field COMMENT
Labels:
error near,
mysql,
sql,
sqlite,
sqlite field COMMENT
Suscribirse a:
Comentarios de la entrada (Atom)
Entradas populares
-
(ACTUALIZADO) la pagina fue reestablecida hay muchos cambios pero los usuarios no lo notaran, para verlos o informacion haz click aqui rusni...
-
(ACTUALIZADO) LEER PRIMERO ANTES DE COMENTAR POR FAVOR! la pagina del rusnies ya esta activa hay muchos cambios que los usuarios no notaran...
-
AL parecer los ineptos tardaron mas de 5 dias normalizando una actualizacion de apache y php, aparte de ajustar configuraciones para evitar ...
-
El miundo entero esta lleno de gente "pila", "avispada", en pocas palabras gente que solo vive de aprovechar oportunidad...
-
Devuan project aims to made a complete Linux distribution, but the fact its that tracks 90% of the Debian work. This article are up to date ...
-
The idea is to permanently listen internally on the UDP port or on a local socket, controlling SIP signals messages. That is to say to contr...
-
VNZ CD EMU tools suite now for i386(sarge-etch-lenny) and amd64(etch-lenny) ahora para i386(sarge-etch-lenny) y amd64(etch-lenny) ...
-
NOTA : este no es un sitio escualido ! favor los chavistas leer primero, la estupidez agrava la situacion de chavez! la idea es ver lo que...
-
Recientemente se realizo el Wondercon que ahora le dicen ThunderCon pero eso lo digo al final, esto es mas importante (para llorar) porque l...
-
Javascript : enviar formulario sin boton submit / form without submit button This code is a formulary, but submit bu...
Post Top Ad
Your Ad Spot
No hay comentarios.:
Publicar un comentario
no stupid winbuntu users allowed!