MySQL上机考试题(答案)
建表详情:
/*
Navicat MySQL Data Transfer
Source Server : root
Source Server V ersion : 50067
Source Host : localhost:3306
Source Database : product
Target Server Type : MYSQL
Target Server V ersion : 50067
File Encoding : 65001
Date: 2013-02-21 17:22:07
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `pros`
-- ----------------------------
DROP TABLE IF EXISTS `pros`;
CREATE TABLE `pros` (
`产品编号` varchar(20) NOT NULL,
`产品名称` varchar(50) NOT NULL,
`价格` decimal(10,2) NOT NULL,
`库存量` int(11) default NULL,