Learning PHP and MySQL
Example 08-01 The contents of the my_backup.sql file
-- MySQL dump 10.9
--
-- Host: localhost Database: test
-- ------------------------------------------------------
-- Server version 4.1.11-Debian_4-log
--
-- Table structure for table `authors`
--
DROP TABLE IF EXISTS `authors`;
CREATE TABLE `authors` ( `author_id` int(11) NOT NULL auto_increment,
`title_id` int(11) NOT NULL default '0',
`author` varchar(125) default NULL, PRIMARY KEY (`author_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `authors`
--
/*!40000 ALTER TABLE `authors` DISABLE KEYS */; LOCK TABLES `authors` WRITE;
INSERT INTO `authors` VALUES (1,1,'Ellen Siever'),(2,1,'Aaron Weber'),(3,2,'Arno ld Robbins'),(4,2,'Nelson Beebe');
UNLOCK TABLES;
/*!40000 ALTER TABLE `authors` ENABLE KEYS */;
Posted by on 08/07 at 05:10 PM
Next entry: Example 08-02 Book titles in CSV format
Previous entry: Example 06-10 Using extract with the EXTR_PREFIX_ALL directive