You might inspect: http://www.monetdb.org/Documentation/SQLreference for general advice. The manual contains a short description for the specific challenge:. http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto regards, Martin On 6/1/11 9:03 PM, Lowterm wrote:
Hi Jennie,
could you say me please, how can I import tables in a database with a file. I have a .sql-File and the content is for example like this:
data.sql
DROP TABLE IF EXISTS `actor`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `actor` ( `actor_id` int(8) NOT NULL, `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) NOT NULL, `initials` varchar(10) DEFAULT NULL, PRIMARY KEY (`actor_id`) )
LOCK TABLES `actor` WRITE; /*!40000 ALTER TABLE `actor` DISABLE KEYS */; INSERT INTO `actor` VALUES (1,'Mack','10',NULL),(2,'Highway','101',NULL), ... INSERT INTO `actor` VALUES (33350,'Nicholas','Pasco',NULL),(33351,'Richard', ... INSERT INTO `actor` VALUES (66434,'Joseph','Roman',NULL),(66435,'Garry', ...
This file contains nearly by 20 tables with data sets.
Thanks