Skip navigation
Currently Being Moderated

Question for David Powers re file 'quotations.sql'

Mar 4, 2007 10:28 PM

It would appear from the first few lines of this file (shown below) that it
first checks if a table "quotations" already exists, and if so deletes it. Then
it creates a new version, and populates it with the following data.

Is this correct?

Clancy
...................................
-- Table structure for table `quotations`
--

DROP TABLE IF EXISTS `quotations`;
CREATE TABLE `quotations` (
`quote_id` int(10) unsigned NOT NULL auto_increment,
`quotation` varchar(255) NOT NULL default '',
`first_name` varchar(30) NOT NULL default '',
`family_name` varchar(30) NOT NULL default '',
PRIMARY KEY (`quote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quotations`
--

INSERT INTO `quotations` VALUES (1, 'My disability is ......'




Clancy
 
Replies

More Like This

  • Retrieving data ...

Bookmarked By (0)