|
该用户从未签到
|
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
2 m/ F; b+ W" L U; G5 w--$ W/ E2 j6 u5 ?, N6 d
-- ---------------------------------------' at line 1- t+ |, d. v* i3 h( v6 x
[Err] -- MySQL Administrator dump 1.4
+ g2 a3 `5 q" d2 M$ P--* ?) m2 ^6 Z5 k9 ~" R& p
-- ------------------------------------------------------' Q0 @$ }$ e9 o7 d; t d* p, f) w
-- Server version 5.5.15
# ?/ ^* u9 H7 r% V5 x6 @' t3 G. `% m5 N' F% t* S8 Y
# ]5 s. K, @. W7 n$ U! b9 N
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+ {% J1 C, N! t9 e: M" c/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/ a9 I. h2 w4 f& B+ w3 M$ `/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
$ ^4 ~" S: m: g0 M3 T& \7 ?9 D/*!40101 SET NAMES utf8 */;2 T. l) C& x6 {/ k& i0 Z; c3 }
3 \4 Z% j* g; t' {: ^9 C/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
. a4 Y* q# |& \/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
6 `! ^: G6 W( ?' D( h' S' n$ y8 ^/ U& N/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;# t5 k( E4 ^; p4 v9 F% O9 h
, {5 ^5 }( l. y: h# K# K7 A5 j* S# S
--: ^7 b* d* C6 q0 a! F7 v
-- Create schema onlinexam
" I4 u4 L8 s. C% ^. o--
9 f- O. _ d p9 Z/ q6 y3 q% s1 A% V
8 v. j" |/ r$ D) C1 j( o' HCREATE DATABASE IF NOT EXISTS onlinexam;; q( C9 `5 D& ^
USE onlinexam; `8 g, T' W8 ~# w2 Z" L
# E2 x4 w. b, I& N" \--
4 n, C( i1 \0 U, z7 u8 d, @-- Definition of table `admin`
# f( L. a2 D# o--& t+ _2 Z" C3 D4 ~+ g; V' N2 M
! r( C3 u2 Q) ^2 EDROP TABLE IF EXISTS `admin`;/ M5 t6 X5 q- ~
CREATE TABLE `admin` (
- \; d! g9 K+ L: x3 z `adm_id` int(11) NOT NULL AUTO_INCREMENT,
/ R, t, ^' X1 f% X `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,5 g" v8 v* W' e' c0 Y0 i% L, I" T* ]
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 ]) _) k* W2 v* @8 Q' y. @ PRIMARY KEY (`adm_id`)
9 \0 m+ Z+ w" M8 m( g) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# H+ J4 I6 |- {' P8 f6 i; O7 P5 {, @* e
-- u: ]4 S% l3 H2 \3 `/ V: X. u
-- Dumping data for table `admin`
. F2 Z0 @) h8 A5 k; `" i--) O+ v+ g& n: @/ B, v" }: t2 e
+ @/ y& ?+ H8 I$ j
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;# z. j6 J) h6 y s
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
/ i- e' F C/ V: S (1,'admin','52itstyle');3 Y4 {9 X: k v# b, f
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;7 W& J4 y0 _% c+ m7 a) w
5 F8 S# ^ B/ x
; X; N* p; T( k& B" ]--
: W2 p8 r: `7 a+ ~-- Definition of table `examtype`1 s0 G+ x0 t5 q
--
$ {! D+ d Y, k* X5 f' T' U% S( W3 }6 N) E
DROP TABLE IF EXISTS `examtype`;
8 U( a; ?. a4 x# U @CREATE TABLE `examtype` (8 V0 u- H6 B% t) H- D% m: `1 G
`type_id` int(11) NOT NULL AUTO_INCREMENT,/ j: u- R3 r2 y4 b+ |
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,; Q7 N8 c- E% M( L5 `4 `. Y0 s2 j$ j
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
0 q8 j3 f, U4 B3 k PRIMARY KEY (`type_id`), T& \3 ^, a6 s: ]0 |1 c- _ ]
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; t3 v8 Z% ^/ J, @' q% x) J, I) e
: ?$ P" h$ S# ^--( a: ~5 K3 S- F$ [4 w2 ^$ ?
-- Dumping data for table `examtype`- m' g) ?5 [6 E, L
--' i, f \7 Y Y5 o2 X) V
* \9 S+ |4 m( z7 w* y* s/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;$ X0 p4 m& W4 C" G F
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
7 [5 g6 U9 ^$ k (1,'语文','6'),- |8 Q+ G5 V8 m
(2,'PHP','2011-10-26'),
6 K1 t5 r) p1 `9 C. L( n# ~! X (3,'ORACLE','120');0 ]! z7 r8 D. A$ @+ j2 X& ^; e
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;
9 o/ j( B9 b" D8 x& q( n2 D4 l$ p1 s: h( e+ T, C" F
: E% v2 g6 S7 n: f--6 p$ C4 j# b" X! o5 N$ d
-- Definition of table `question`& A2 x2 I3 Q6 L: m5 ]( X8 N2 N
--
) t0 F5 x& U* I4 i1 \5 g
$ U$ R# k, t& P0 R4 N. N& ]" o( ~& }DROP TABLE IF EXISTS `question`;1 P3 Q/ z. @, h) `0 U
CREATE TABLE `question` (, L: l* n8 U2 h% B f& g* H
`qu_id` int(11) NOT NULL AUTO_INCREMENT,$ _5 N9 v4 V- J0 Q
`type_id` int(11) NOT NULL,( B: K( q3 h. L: k% N: d0 O
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 k$ Y. Z, o) Z( A& V7 h8 l4 `/ u1 h& g3 J `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,8 G! i2 Y( o( h$ p. u. z
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,5 Q$ Q6 e9 b% E: @+ L
`quScore` int(11) NOT NULL,5 o5 `7 n9 R2 u* V1 v: y
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
& A/ ]3 Y9 {- G `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 K! B& E% y: a/ O: S% |# ?! v PRIMARY KEY (`qu_id`),( t2 s3 Z2 b! h. O
KEY `FKBE5CA00621011593` (`type_id`),
7 U, }0 a& T/ {9 ]. n KEY `FKBE5CA006B04D67C1` (`type_id`),4 Y. ]* |5 H7 N0 d5 W2 |7 g
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),: L' U: U/ G6 y1 O
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
^& y7 m7 k7 G1 ^ CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
% q1 Y* _3 X$ m+ `" m2 Z4 c) U) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2 ~! T% ]- g. c8 x5 Z
' W, q8 g3 J9 ^--
! Q/ @2 w# K5 _- ]+ J$ h, E-- Dumping data for table `question`
# t4 n4 F3 {- z9 [--
' N' ~5 N' d4 R3 p" ^) g! o- d* M3 u/ o7 b" p
/*!40000 ALTER TABLE `question` DISABLE KEYS */;+ B5 G0 d' f( f
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES / a p! Y; K7 i
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),7 e/ F" e; Y# _. d, Q4 D
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),3 i M `$ x3 g# I! F- d7 {7 X
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),$ }1 x; L l7 D
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),4 D; p" K+ a( H3 Z, K7 r' N4 c) j2 U
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
( ^! J- e1 K9 i' V5 p. i" e (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),! ~# q- A% {2 m( y, B( v3 t1 ?
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),9 B v) {$ v: g$ W$ N4 Y' a1 l
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),) `4 k1 m9 ^+ F' m
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),+ V) M; S5 V2 S9 W, a) ^
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),6 B6 c5 k- s" i B8 g- ]
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),1 u' ^8 v; P' A: h% R
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),3 A9 K% x& F4 J P
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),5 A5 b9 y/ H3 T) b' m9 n
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');; h; a, S. Z: K- i% I/ ]5 H$ W
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
; b! S1 m4 I$ B0 ~& l( J3 ]0 T
8 S( s, E+ c* K2 a% x3 o9 v, h& c
* V7 ?: `8 K8 a: h! T/ p6 D--
5 }3 C; j/ I4 o% w. r( \9 v) M-- Definition of table `student`/ b0 A& n4 K8 S8 P6 J
--
3 x6 W0 P# }+ K8 V
4 S c+ x/ t8 W3 zDROP TABLE IF EXISTS `student`;; V% L. z4 l* p: {; l3 y
CREATE TABLE `student` (; H6 r0 a- M1 h4 G/ ~4 n, B+ s
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
. t+ T5 |' Q. K7 h. ? `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
/ H3 G- g* S5 g1 i) C* W5 n `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
" |8 v5 S- B; w* R4 j `className` varchar(255) COLLATE utf8_unicode_c% X. S8 p9 p; g z4 E$ ^2 L
[Msg] Finished - Unsuccessfully |
|
[复制链接]
|Archiver|手机版|小黑屋|科帮网-Java论坛、Java社区、JavaWeb毕业设计
( 鲁ICP备19004528号-2 ) 
窥视卡
雷达卡
显身卡
