Re: Execute more sql statments in one step.
- From: Daniel Dittmar <daniel.dittmar@xxxxxxxx>
- Date: Tue, 12 Apr 2005 12:10:12 +0200
PdG wrote:
I've this script:
DROP TABLE IF EXISTS `rivenditori`;
CREATE TABLE `rivenditori` ( `id` varchar(255) NOT NULL default '', `ragione_sociale` varchar(255) default NULL, `licenza` varchar(255) NOT NULL default '', `ultimo_accesso` timestamp NULL default NULL, PRIMARY KEY (`id`,`licenza`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
INSERT INTO `rivenditori` VALUES ('101010','aaa','blabla',NULL); INSERT INTO `rivenditori` VALUES ('101010','aaa','bbbb',NULL); INSERT INTO `rivenditori` VALUES ('333','ccc','333-223',NULL); INSERT INTO `rivenditori` VALUES ('partita','ragiones','s',NULL);
and i need to execute it into a mysql database in one step.
But i obtain an exception: "You have an error in your SQL syntax;", and, cutting and pasting the same script inside a mysql front end (mysqlfront for example) it's executed with no errors.
Have i to use a specific method to run multiple instructions? I've tried execute, executeBatch() but the results are the same...
Please be more specific about what 'execute it into a mysql database in one step' actually means. Why are several stmt.execute () not an option?
Daniel .
- Follow-Ups:
- References:
- Execute more sql statments in one step.
- From: PdG
- Execute more sql statments in one step.
- Prev by Date: Execute more sql statments in one step.
- Next by Date: Re: Execute more sql statments in one step.
- Previous by thread: Execute more sql statments in one step.
- Next by thread: Re: Execute more sql statments in one step.
- Index(es):
Relevant Pages
|
|
