drop database if exists mondial create database mondial use mondial - Table structure for table `borders` - DROP TABLE IF EXISTS `borders` /*!40101 SET = */ /*!40101 SET character_set_client = utf8 */ CREATE TABLE `borders` ( `Country1` varchar(4) NOT NULL DEFAULT '', `Country2` varchar(4) NOT NULL DEFAULT '', `Length` int(11) DEFAULT NULL. It looks something like this: - MySQL dump 10.13 Distrib 5.5.25a, for Win64 (x86) - Host: localhost Database: mondial - Server versionĕ.5.25a /*!40101 SET */. Have a look at the mysql-dump of the mondial database to get the idea. Some additional non-data statements like table locking are bracketed around the data inserts. Zero ore more extended INSERT statements.Each table is represented by the following sequence of commands: I decided to try option 2 first.Ī MySQL dump file contains a header with preliminaries like a CREATE DATABASE statement, followed by all tables of the database. Setting up a local MySQL instance would entail jumping through some hoops.
0 Comments
Leave a Reply. |