写SQL文件

 

/*
MySQL Data Transfer
Source Host: localhost
Source Database: wx
Target Host: localhost
Target Database: wx
Date: 2011-7-14 11:26:27
*/
SET FOREIGN_KEY_CHECKS=0;//此行好像不能少，必须有才行
-- ----------------------------
-- Table structure for tbl_body
-- ----------------------------
DROP TABLE IF EXISTS `tbl_body`;
CREATE TABLE `tbl_body` (
  `number` int(4) NOT NULL AUTO_INCREMENT COMMENT'编号',
  `name` varchar(20) DEFAULT NULL,
  `age`  int(4) DEFAULT NULL,
  `SEX`  VARCHAR(20) DEFAULT NULL,
  PRIMARY KEY (`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='成员表';

INSERT INTO `tbl_body` VALUES ('1001', 'w1','100','1');
INSERT INTO `tbl_body` VALUES ('1002', 'x1','101','0');
INSERT INTO `tbl_body` VALUES ('1003', 'w2','102','1');
INSERT INTO `tbl_body` VALUES ('1004', 'x2','103','0');