创建数据库、创建表实例 08.11.6

mysql -u root -p

Enter password: 123456

 

注意：Commands end with ; or /g

           Type 'help' for help

 

创建数据库stu

create database stu;　　
Query OK, 1 row affected (0.00 sec)

 

展示所有数据库

show databases;

4 row in set (0.00 sec)

 

打开数据库

use stu;

Database changed 

 

CREATE TABLE `stu_info` (
  `ID` int(6) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`ID`)
);                     ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

 

INSERT INTO `stu_info` VALUES (350001,'001');
INSERT INTO `stu_info` VALUES (350002,'002');
INSERT INTO `stu_info` VALUES (350003,'003');
INSERT INTO `stu_info` VALUES (350004,'004');
INSERT INTO `stu_info` VALUES (350005,'005');

 

create table `lsn` (
  `LSNID` int(6) NOT NULL auto_increment,
  `math` int(3) default null,
  `chinese` int(3) default null,
  `english` int(3) default null,
  `physics` int(3) default null,
  `chemistry` int(3) default null,
  `biology` int(3) default null,
  PRIMARY KEY  (`LSNID`)
);                   ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

 

INSERT INTO `lsn` VALUES (350001,48,96,91,34,51,65);
INSERT INTO `lsn` VALUES (350002,48,48,79,94,81,94);
INSERT INTO `lsn` VALUES (350003,79,89,78,59,58,79);
INSERT INTO `lsn` VALUES (350004,48,79,79,98,100,79);
INSERT INTO `lsn` VALUES (350005,97,85,97,82,79,95);

 

create table `teacher`(
  `SJID` int(2) NOT NULL auto_increment,
  `subject` varchar(16) default null,
  `teacher` varchar(20) default null,
  PRIMARY KEY  (`SJID`)
);                     ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

 

INSERT INTO `teacher` VALUES (1,'math','AAA');
INSERT INTO `teacher` VALUES (2,'chinese','BBB');
INSERT INTO `teacher` VALUES (3,'english','CCC');
INSERT INTO `teacher` VALUES (4,'physics','DDD');
INSERT INTO `teacher` VALUES (5,'chemistry','EEE');
INSERT INTO `teacher` VALUES (6,'biology','FFF');