|
该用户从未签到
|
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 R% _0 {0 c! f: {* v
--
- o$ w/ j4 M& g8 `-- ---------------------------------------' at line 1; N6 A- m- T* h2 h
[Err] -- MySQL Administrator dump 1.4 ]* G, P$ F8 Q' e& I) y( S
--8 n. F. S) A* e; O
-- ------------------------------------------------------, G5 G& G' N/ f
-- Server version 5.5.15
/ u& f z a: L
4 A6 l* s. `& _- _; A3 F! t! \& ~7 V L, m% x, c, e: D4 \
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
' R$ P6 L. ~/ \1 z2 F& Q" j/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
$ Y; Z M- E& j2 @1 G3 R, ?/ g$ W2 u/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;9 G1 a6 Z% e# I3 a) r
/*!40101 SET NAMES utf8 */;
5 J9 }/ P5 `/ }, }! U; {# U7 |# g1 n, ~# w/ {
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;& ^% c& [5 t+ S1 S$ E/ z8 m
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
! E) V3 L* T2 Y- E, d- h3 y* r u/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
* _/ q, a- [9 w' w4 {- [& c; d" ~: J2 J: ]8 ^9 W# c
2 G9 O- S: G% a1 i7 ~5 Z--
3 n9 o1 E& @" R, o-- Create schema onlinexam( q, i% v+ Q/ R. D6 E
--% c/ t. e& [7 { s5 \- q6 q! J
: ^, w/ f0 M/ C; N3 v, |4 u! ^
CREATE DATABASE IF NOT EXISTS onlinexam;
! {% M8 z# A1 w* bUSE onlinexam; e, J5 {$ X6 E% n0 g* \- J6 H) F1 K
. d1 f: e5 @2 W& g, R
--
' T& g0 J$ C$ o) P& L- H-- Definition of table `admin`$ O! c8 Y5 l% q( z' z& P
--
7 D6 r) ]& W. R5 [. M$ O1 R0 t4 R& q" d' ?8 q1 D8 d
DROP TABLE IF EXISTS `admin`;
" k, z, j1 \. D3 E: D# F1 u. yCREATE TABLE `admin` (0 g: {2 ^4 \$ n# J/ v7 N
`adm_id` int(11) NOT NULL AUTO_INCREMENT,- j$ L& H2 n7 r: R. }. ?+ d
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,* _' G( m* B5 e) }0 y
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 `; `9 |9 J ]4 [" Z: X9 K PRIMARY KEY (`adm_id`)
2 N5 n7 u( b5 `( |& F/ n0 D0 ~) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;, S% X! c" A5 Y0 S
! ^/ S% @6 m# H+ d2 F$ B0 ?--0 e. j1 V3 J7 o9 ]1 H( v6 ^
-- Dumping data for table `admin`
$ Y" h9 U3 T& X- b. b--
6 |1 D/ k* o: c
) c5 x& c6 l( Y: E; L% e8 E! a/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
9 ~6 Z- P. r9 T B4 R# KINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES 6 L* O7 s8 A6 M% S
(1,'admin','52itstyle');. J4 F4 g5 ] l
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
2 ]6 [. ~" \2 o- \ `, i
) a' ~6 D8 Z% T, Z, w7 J- p; R9 M- J! {
--
% i5 i6 ~& T- M: N( c-- Definition of table `examtype`
3 C, n. ]' j7 @: D3 E3 a--
" M/ L3 P/ d! y. l& y8 T A) S9 l/ h
DROP TABLE IF EXISTS `examtype`;1 p' N% w% W: ^' J9 _% l3 |
CREATE TABLE `examtype` (
+ H+ S6 y1 l% ~4 d* z+ L `type_id` int(11) NOT NULL AUTO_INCREMENT,/ l) X! [% G1 _& s' B2 @
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,; ]. K% v) I4 p: y
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
* o1 @# J# h6 t8 h PRIMARY KEY (`type_id`)
0 J2 A2 d( ~1 g* B0 R& E2 }% k) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;3 J0 Y l, l- H; \7 D3 C3 x: W4 a
* t& b V$ C. W; k1 A6 A* u--' m; k0 q# y5 M4 J
-- Dumping data for table `examtype`
; E4 X: D* O) F6 w$ u, {3 X--
* n: C$ T5 ], Z0 O" N7 W
) D* @$ ?& M* j6 t4 v* c' Q/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
. j- h9 @6 h- GINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES 3 ^8 ~# {& S R8 C* `3 \
(1,'语文','6'),9 s% D, j) s* J: C
(2,'PHP','2011-10-26'),
: \3 E: t/ h* |" Q2 K4 I$ v5 @ (3,'ORACLE','120');
0 i9 h8 ~2 V0 o- Z0 g3 U: N/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;
+ H! Y3 g) d) x" B" ~- s* T- j. R
$ ^: t1 K+ G. }% H) l2 o6 H- m3 U& H3 ]
--; Y% r: q5 v* J. ^
-- Definition of table `question`: ?5 x3 w3 z: J E+ f$ p. ~# k n
--
; x% i5 K; s; F$ r% K& D9 ]8 e; o9 g8 S
4 H# v! S* |# |; lDROP TABLE IF EXISTS `question`;4 r! a1 v v/ ^# a$ z
CREATE TABLE `question` (: }1 ?: ~2 \, k8 U5 N! I
`qu_id` int(11) NOT NULL AUTO_INCREMENT,
2 Z3 v$ ]" j X3 U `type_id` int(11) NOT NULL,
. U" @" [) l6 \8 Z `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,$ V4 v5 v( N% o; \" h* q- q' y* c
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,% a. L) d- Q: `# T0 @ J9 K Y
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ p) M6 b1 C6 W; h8 V) B/ J `quScore` int(11) NOT NULL,1 R. y" l' Z. |' A3 O' e9 a
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL," p& Z3 m$ ^/ X) W( W! g" b
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL," j4 ?. U8 g: K- F7 H
PRIMARY KEY (`qu_id`),0 S( g6 n0 k: [8 W/ Q8 J3 H' O% E6 I
KEY `FKBE5CA00621011593` (`type_id`),2 T+ y- \+ X- a9 ^4 p }4 Q2 Q
KEY `FKBE5CA006B04D67C1` (`type_id`),* b' M6 w( ]# h2 [3 s0 Z7 Q; s- U' d4 x
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),: k. ^, p' x9 J- E6 O2 ]5 c5 b
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
4 }. S4 ~( L G CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)8 x$ a0 L& b2 ^/ N
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;" V, @ r, i1 h, o6 O$ T
/ g" @2 O# q' i: n" \/ a$ b--
8 l9 |) j% N9 f# c4 F& p-- Dumping data for table `question`' ?" N+ n* N. {" s6 P b
--9 s1 W% _6 ~' ?; Y5 E6 l
4 {9 ]( Z$ `9 W% I ]1 r8 T1 Z/*!40000 ALTER TABLE `question` DISABLE KEYS */;7 e, N/ _* k; I! N) S) Q8 J0 n X
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES 0 p5 ~3 w2 F/ T$ n
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),* a( d' k7 v: l0 p+ z4 L2 N
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
2 u3 r# Q) q( }2 w+ O9 _. i5 ? (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),4 R6 b, C7 ]& S+ A W+ |
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
7 ?/ }8 |' c3 _3 L- I6 p5 d0 I (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1')," n% H/ n( z* X# f5 R
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
& T6 E3 \! I2 i. `) l (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
8 S& X5 v& W! O0 p, @' I (8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
1 X( U" q. I ]( \- |& n5 N) S (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
) j: q( s. E1 K3 W (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
) Z) j6 e5 J) R8 S" M (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),( F, v3 y) s. v3 F6 l1 ^
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
# M; W7 V) ]4 Z3 Y( @" t' e4 t% ] (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),! o0 r- ~" {4 d& v* B, r' g" [" f
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');0 k( C: x4 I5 G& v3 r1 w( U
/*!40000 ALTER TABLE `question` ENABLE KEYS */;1 X5 H% p! O# U+ \2 |
2 [ G1 @- D6 o1 B Q' V, m
/ z# R( _; p% S g1 y3 X--
' Y) U) o n" P4 C-- Definition of table `student`
1 c! n; Y0 _! ^+ c3 l- f--
. ]+ i- p8 W" p' s7 a) Q* l5 a
5 m2 F q/ d9 D/ {DROP TABLE IF EXISTS `student`;- I9 }* k. L5 v y5 E
CREATE TABLE `student` (
. B# b' F( r2 G9 o `stu_id` int(11) NOT NULL AUTO_INCREMENT,
$ c$ S2 ~9 H" ^ Y4 E9 d `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,! F) V: a# k: A `- e3 q
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,8 E* [& x& k2 c! F
`className` varchar(255) COLLATE utf8_unicode_c
1 O8 u, g0 ~) X: h1 j$ p[Msg] Finished - Unsuccessfully |
|
[复制链接]
|Archiver|手机版|小黑屋|科帮网-Java论坛、Java社区、JavaWeb毕业设计
( 鲁ICP备19004528号-2 ) 
窥视卡
雷达卡
显身卡
