Re: varying results of sql-send-buffer

[Martin Mueller <mmueller@pdbq.de>]

Andreas Zielke <Zielke.ng@oktapos.de> writes:

> I'm using Emacs 20.7.1 to build a MySQL database. I wrote a series of 
> queries which creates a db, tables and puts in some data (db is dropped 
> in the beginning to provide a clean start for each run). This file works 
> fine if used directly with mysql: mysql < file.sql
> 
> But if I send this buffer via the sql-send-buffer command to mysql in the 
> interactive-buffer, the final state of the database is different almost 
> each time. 
> 
> It seems as if some of the queries get lost along the way. This is 
> curious, since I did some previous tasks where everything went smoothly.
> 
> The Emacs environment is set as follows: 
> sql-mysql
> sql-set-sqli-buffer

It is the same here.
I can avoid the problems when I remove the comments from my
sql-script. Do you have comments in your file?

Martin