Re: Execute more sql statments in one step.

Daniel Dittmar wrote: 
PdG wrote:

Daniel Dittmar wrote:

Have i to use a specific method to run multiple instructions? I've tried execute, executeBatch() but the results are the same...

[...] 


OK, sounds reasonable.

I guess you have to break the file into individual statements in your java program. I assume that the mysql client does this as well rather than sending the whole input as one command to the database.

I think that the best way is to call the mysql client using an exec command, and tell it to load the database using the received .sql file.

Thank you
.

Relevant Pages

  • Re: DB Space
    ... > "Hari Prasad" wrote: ... >> Can you execute the below command to ghet the actual database size. ...
    (microsoft.public.sqlserver.msde)
  • Re: C# command doesnt time out appropriately...why?
    ... record in our database that matches the search criteria, ... only by increasing the timeout in our VB application, little by little, ... I'm basically trying to execute the command, which of course is a call ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Set Restricted_User
    ... to the database, the connection may drop as the database ... the other users but for the app that executes the command to ... Then execute the command and then try ...
    (microsoft.public.sqlserver.security)
  • Get Table and Field Names
    ... To get a list of available tables in current database, ... execute the following command: ... EXEC sp_msforeachtable @command1='print REPLACE(REPLACE ... properties for a table, execute the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DB Space
    ... Can you execute the below command to ghet the actual database size. ... use dbname ...
    (microsoft.public.sqlserver.msde)