|
该用户从未签到
|
199#
发表于 2017-07-09 11:32:57
|只看该作者
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- MySQL Administrator dump 1.4
9 {4 z9 o% {& n- K6 A--0 X( N5 L' k% ~1 c. q
-- ---------------------------------------' at line 1
K1 p$ J: z# T6 [3 f$ r, I, q k* Q[Err] -- MySQL Administrator dump 1.4' O6 K% ` i4 I' d- B- w
--
' e; i7 k, @* j1 H; Z" D, Q$ M# ]-- ------------------------------------------------------( c4 N/ ]( X+ |7 A% N& ~
-- Server version 5.5.15* \$ L% @) m4 G; z" Y
/ `* m2 b- z; Y2 y% e1 ~9 m
, C7 o, D. _4 E _- T8 z/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7 V: o& _' ^: L+ n; z/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
0 U5 ?( w% v* d( J- I" ^/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
' N y2 p; H$ M% ^" A: h/*!40101 SET NAMES utf8 */;, R6 M2 ]2 x* b
0 d# Z1 V3 }) \5 D) n' x- K5 T/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;! K( b0 V. T5 c, z% @
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
% w0 _& J/ n! E0 B/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
% a% e3 a) Y& t- Z9 b4 K9 m, S( q2 P) ^+ _
2 C4 S2 q6 Z8 S/ E2 d; L
--
0 {" D0 g' w$ i1 _-- Create schema onlinexam
5 U5 V- H- o4 P( U u--
( S/ A0 ^ c. p3 P: F4 K; W; u7 b2 q M: N+ l2 Z# k
CREATE DATABASE IF NOT EXISTS onlinexam;
3 k; ?1 Y \: _USE onlinexam;/ K/ E0 _; S+ y7 y) ?/ p
5 N0 t& ^# u# z+ n--7 p* g5 ]) P' r3 o" B
-- Definition of table `admin`
) q1 x' i( Y" E5 r b4 u& r2 I--
6 e& @( q+ X0 J0 X/ N3 C: \! {9 E M
DROP TABLE IF EXISTS `admin`;# Y1 B; G5 p% j( a( q
CREATE TABLE `admin` (
1 O( k+ n! }; Z: g# Y `adm_id` int(11) NOT NULL AUTO_INCREMENT,
; s3 I& F, N" F h [# |3 \( I3 G `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,. n( A) _( `7 `1 Q/ ~0 q
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
( `- z: i& [3 h- g0 e( b. R PRIMARY KEY (`adm_id`)" B) L& o- V1 N
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;8 L7 x# Y" N" R( ]: w
' [# o3 X1 [! W. v6 I- I7 I$ |& l--2 o) {) C! ^# S; g4 P$ U" @
-- Dumping data for table `admin`, U0 U% Q* C- N$ v4 f5 u
--3 D) _- g" I: |* ?, ] c
* g! H" l, d+ M" l
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;' e& b- Z* O+ I: G% E
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
$ X6 G6 r1 k, Z9 H: L7 e (1,'admin','52itstyle');
' U z4 T: o" M5 m% V/ {9 C/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
0 f9 k7 s0 s: E2 j' _/ f2 ]/ M2 t, P7 C3 k0 m
& t$ h% A, `4 j& l' y: E6 |
--
8 n) k& \9 R. ~, d1 d-- Definition of table `examtype`, q1 y- z9 A! d, Q) A, y2 u
--
1 F9 {3 x5 r9 l( U0 g
% o, O8 k1 K7 Y0 V% HDROP TABLE IF EXISTS `examtype`;) }/ Z' {; a3 O' M" E
CREATE TABLE `examtype` (
6 m P' A% f3 V' `: k( S( G `type_id` int(11) NOT NULL AUTO_INCREMENT,! @* J+ c2 a% I$ ?2 A
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 p- C" o Q" H( D5 B+ x0 T6 H `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1 |9 s& g) B* o( w+ ? PRIMARY KEY (`type_id`)
- \' H% `! N$ t" D) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- N( W1 z+ ?% K) u* M. x; Q# N) H; M; C @) C6 O) |) g$ S
--
4 {4 o6 ~6 k( { q: W-- Dumping data for table `examtype`8 p4 j( m8 [6 p I- P' M8 A1 R
--
/ ~ E! _% k5 Q3 q. P+ |8 ]7 K1 o q f9 D H0 l
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
( |" V2 V$ w0 r- dINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES 6 l7 a3 }# j# W; h
(1,'语文','6'),! Q; A3 z( x0 a
(2,'PHP','2011-10-26'),' S% }7 |: p* ^0 o/ H5 h! {
(3,'ORACLE','120');: F& R0 }/ V; N4 ~
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;+ O, z4 `0 I& S3 j, N9 A- [
. s3 e1 p$ J; U
" m0 v' [. H1 n m2 E2 Z$ Y--3 k! J& H6 U* ^* C
-- Definition of table `question`# F' e' C d3 @6 S; V! T" y/ ?0 J3 ?2 A
-- W0 u# F1 ~5 v+ k; c0 I
1 P+ a- ~% A+ }5 W u" L2 Y" o
DROP TABLE IF EXISTS `question`;
3 I% {3 @+ A3 \/ o/ v6 s( Y- I# OCREATE TABLE `question` (
' X |- Q% L! G. M `qu_id` int(11) NOT NULL AUTO_INCREMENT,2 Q, {5 |7 f# M6 R# i. C4 A
`type_id` int(11) NOT NULL,
, }" i. z+ W/ ^0 C `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,& v+ l) @$ N( V" l
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,0 [& A5 }% a% k/ r: h" L$ q3 k
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL, i+ J% u6 t& S8 X; E
`quScore` int(11) NOT NULL,
- g3 u: s' b H `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,: Q$ X' `9 T$ g5 y) \, J" k% S
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,0 K4 P: N1 O) B+ I, c8 B
PRIMARY KEY (`qu_id`),; S. \- {! t9 U% q! b+ P
KEY `FKBE5CA00621011593` (`type_id`),
6 J/ W Q4 B6 G6 S; I- p# c KEY `FKBE5CA006B04D67C1` (`type_id`),
U# i4 G+ s2 m/ z" S3 f7 p CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),. F$ J% H: H/ e: H' x
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),, D$ C( f! r |
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)5 T1 R, F3 N. P% u1 J% O
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;" |8 \. e8 R! d% s, H
w0 \* |. e2 J( q. A--, Y& G# E5 B- e m, X: X' G |
-- Dumping data for table `question`# b% Q- H R. H3 L9 O2 C6 G
--
! g0 t) n1 s# |. L4 q% A- v6 g: U0 }5 p& Q, M; J
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
" u0 t X9 L) W# _+ KINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES 5 q6 N3 q8 a7 Y) Q2 e! N
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
' F# u& Q4 ?4 r+ | (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
$ s0 n8 o1 m- p) d (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
2 I# j/ J$ Q# I+ i% q( c (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
7 s" t/ ~1 q0 I' w (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
6 i, I: r8 P* b W/ ~ (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
3 ]! e# I# J# p$ }1 w (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),2 ^. D, P; A6 X/ z$ w8 S! E: K
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),% |: p& e) m4 o x5 x# z
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),7 J$ F* u. l6 [4 g/ m' d- G3 M' E1 g
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
+ F2 t p& G" `. Z- y! {- J (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),# z+ G4 x+ {6 H' k+ ^/ a6 C/ ?/ _2 O/ `, w
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),; t( m3 T3 D% } |; F; e) ?
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),2 H# @3 ^' T! o" ^: E" x! t
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');/ q9 \7 z; Q1 H. z" c. C. e0 [* p
/*!40000 ALTER TABLE `question` ENABLE KEYS */;% W5 i4 ~" b1 g% J [! i
6 h8 D. a7 d, ]4 G W! S
& K$ \- m# \) L, j b--1 M% k( m8 L2 `; n _, a: s4 J
-- Definition of table `student`
@+ o4 B. t3 c! L9 `--/ P0 H- E* \+ p @, P3 L
2 t* Y$ a( o( T8 S t7 b
DROP TABLE IF EXISTS `student`;
% m* w+ `/ I+ ]% u/ kCREATE TABLE `student` (8 V3 c6 ~+ M7 j" |
`stu_id` int(11) NOT NULL AUTO_INCREMENT,( W( y g3 g3 M
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,3 T4 s3 b8 B2 ? m2 [
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,4 A: f! M( Q N/ U7 P+ K1 v& T: u; i
`className` varchar(255) COLLATE utf8_unicode_c6 a, i; f! w$ C
[Msg] Finished - Unsuccessfully |
|
[复制链接]
|Archiver|手机版|小黑屋|科帮网-Java论坛、Java社区、JavaWeb毕业设计
( 鲁ICP备19004528号-2 ) 
窥视卡
雷达卡
显身卡
