该用户从未签到
|
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) M! ~- R+ J/ p9 {6 x
--5 A' O0 A3 ]1 V) x `
-- ---------------------------------------' at line 1
' {' v: C& J( ?: {[Err] -- MySQL Administrator dump 1.4
" r2 u/ B9 M+ d--
6 I" I' L) }$ s6 Y7 @! v0 [-- ------------------------------------------------------
* O+ v9 N. a2 [-- Server version 5.5.15" m3 J4 t7 n3 G/ i$ @' ~4 w
; X) @! B4 @* j
* J9 [' X2 e! f4 l/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;" x! d- v2 ~6 y/ y+ _
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;4 h5 W/ y3 [+ e/ X5 j
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;$ Z6 o6 O- ]/ v/ S
/*!40101 SET NAMES utf8 */;+ Z! s' E9 V! M, ?& ?7 I/ t5 _3 ^. U: R
: ^( @/ d5 X6 |4 M6 P# x/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;) D2 a" C1 e- x l! Q
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
" ]: Q4 K1 }0 ]/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; Q1 p; X+ n/ I+ G% i: H8 M
* I" X/ K9 D x0 H/ g- @
1 `% F; ?5 t/ i7 N8 P1 \8 ?' q--
6 P$ A6 Q+ N/ R' S; J3 ?6 ]-- Create schema onlinexam
8 y* k3 V( f. t0 D7 N7 \. ?--4 i* f2 N: R6 K; b/ G5 A" i" G
/ ~- N' a2 N$ a: m! DCREATE DATABASE IF NOT EXISTS onlinexam;
# V/ k+ C6 |1 P: T/ Z& @USE onlinexam;" y% k1 Y D0 t/ \5 l
0 m1 m& @. c! F2 [. \8 G( L--8 y2 v5 F8 C. \& r$ s8 F1 N( b
-- Definition of table `admin`
. D$ }- m1 u0 D/ b--0 N. p% A4 n: E6 M* x3 `$ ]) f
, o4 l! x; h$ r! b @. o+ A9 A, a
DROP TABLE IF EXISTS `admin`;
* p& a6 [( s% vCREATE TABLE `admin` (
I# X7 E4 w% \! ]! D! h; } `adm_id` int(11) NOT NULL AUTO_INCREMENT,
5 J) _. L. p7 R( W2 F+ l4 f `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,, V l y# g9 i& P
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; a m. a( l* z9 ]7 F) C PRIMARY KEY (`adm_id`)
! o8 ^6 m8 d; h# I) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4 s: L2 u$ F, i! X
4 r1 B/ r6 n( [5 D7 ~1 f7 K--
. b# w& b& W$ u/ I-- Dumping data for table `admin`
, [% q6 }2 p& [: P2 E--
( u, ]4 {( @" Q8 E) }% K" A" `
5 z0 u8 f7 ]5 ~& M/ ]6 s4 D/*!40000 ALTER TABLE `admin` DISABLE KEYS */;3 K @! V+ w3 K9 y3 q, q
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
8 g& @# P. N3 R% {! _ (1,'admin','52itstyle');
& z1 Z, g' V) y9 x0 }* ]/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
8 x; F* g* w8 j/ t K4 G4 L
u5 L+ R/ R) r {: j" C6 r! I4 P5 ~" [) A5 ]8 |9 H( k
--. E" p" ^& y, L: W, W3 |
-- Definition of table `examtype`' L* k& z% Q2 y1 M
--
% i$ d5 N1 r7 {+ f
8 W: h( v8 N3 ~+ o3 U: w4 G8 T JDROP TABLE IF EXISTS `examtype`;, i/ x& ^- L4 |, w/ S$ |# Y0 \% W" A
CREATE TABLE `examtype` (
& u/ \/ T' N) g$ |6 j `type_id` int(11) NOT NULL AUTO_INCREMENT,
- Y+ ^1 v' P- ^ `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,9 [' V! v# t( P) I- {
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,' f; T$ G( O9 L$ A0 W/ b& l2 F
PRIMARY KEY (`type_id`)0 ~0 C0 r; S: W% K9 V K e7 z
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; E" M2 i/ O' Q/ R$ u
3 O, j( d' k1 u7 D7 p1 ?- W--. b; P+ H. i, |6 G* g, M
-- Dumping data for table `examtype`1 d. O4 {0 T: ^, y! Z( U( m
--- B6 o7 B# ~- ~( L! T
$ G4 W2 q v3 j' i/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
( K) _. N1 A: N5 Z2 hINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
) k. T( Z4 c$ r+ x+ g2 @4 u (1,'语文','6'),5 F! |$ F+ h5 ~$ ~
(2,'PHP','2011-10-26'),3 }) m* k, t% m1 _# Y3 J
(3,'ORACLE','120');
, e+ y- ~5 r/ y3 f) K8 S/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;2 V2 [9 b* x0 R4 E5 H4 j' g8 T
0 [( ~" U0 X' x' w) g8 `# q, o
, ]8 D- u' d" z$ u6 d# c; g
--) h7 ~ y8 X% |5 k
-- Definition of table `question`
6 ]) _7 V/ `, }1 G1 x--/ N& X9 I6 a* s* [: U
/ A5 m" R* {( |5 ]7 U0 ^5 dDROP TABLE IF EXISTS `question`;$ w$ D$ F! \7 J+ W
CREATE TABLE `question` (# O) s" L0 U+ B1 M$ }
`qu_id` int(11) NOT NULL AUTO_INCREMENT,
, z+ {" y& m E9 ~ `type_id` int(11) NOT NULL,
0 G6 o% V% h: f% c2 [4 V `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,/ {9 q7 T9 k' X" V m& t) i
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,# p* R) ] f* p+ W: ~2 x
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
/ n5 X4 {9 N: R `quScore` int(11) NOT NULL,/ V& p( z: ^& O5 V
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
0 @6 k9 P" b8 O `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 X& h; P/ f/ I, k9 _1 E$ S2 Z& F PRIMARY KEY (`qu_id`),
# _# V* Z( O2 p KEY `FKBE5CA00621011593` (`type_id`),
$ u- l! X( t+ M. k+ G) M3 Y( J' x KEY `FKBE5CA006B04D67C1` (`type_id`),
) | X) a- w0 C( F CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),' l" K+ B! K) Y) Y# ]- }8 s. U7 Y8 N
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),' Q6 C2 L( M5 N
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
4 W7 P6 S& u1 i! {! V7 k2 q) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;6 e/ B* D* B/ ~
# Y7 ~6 u7 c- A& z5 ~8 w) T2 L
--
8 ^# w1 k. \* q( @* j-- Dumping data for table `question`
' i T- i& W6 _- m- [) B--
|5 v. N; V" d4 W# ?, g4 f
6 C% j! B* K6 h( `# |7 }/*!40000 ALTER TABLE `question` DISABLE KEYS */;7 e; X! ]- A+ p: L
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES ) H& L. S f9 U( p5 S n$ ]3 b
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
- @# K5 R9 p6 I e (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
* B4 j3 V6 y+ K# Q (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),4 }( s# t7 O+ Q0 U* G
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),. Y9 u; V* z' W& Z
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
9 r6 }6 A# S* f" }8 Y# a7 J (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
7 ^: i/ p0 H& ]. B; w9 L (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
( [1 ?- o: _: s, ]8 F (8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),
# p7 ^; t1 ?" F" } \$ Z (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
$ _/ }# K# [4 T5 w/ ] (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),# g* c: S, d1 c5 R9 F! Y2 j3 k
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
/ j/ a1 y2 u4 x: O# Y: L5 j (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
3 \; C6 Z" X6 y- ]' Y/ D (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'), p7 \$ Q% _* J. G/ e2 B. S
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
4 q3 Z4 [& h& ?* a$ [+ \# {/*!40000 ALTER TABLE `question` ENABLE KEYS */;& p0 j* Z; d( `/ f7 t5 s2 M
( |" Q2 \2 z" D% W$ P% R" P. B
5 y" A7 ^6 D) U! V: k
--
! Q x0 M# j- s$ S3 n1 q. X; w-- Definition of table `student`
& Y- I. d; f# z5 w# \% `--
" J: t- |5 |+ J+ Y* h1 V; S! Z% O
DROP TABLE IF EXISTS `student`;
5 t" a p/ w4 q) r, ?CREATE TABLE `student` (0 h/ A) K" `, Z" I, T. [, e
`stu_id` int(11) NOT NULL AUTO_INCREMENT,! u. A2 p; o; ?8 b8 A" v
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,, f/ K% o; [! @# e* D6 t2 [2 G5 A6 l
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,5 I( q9 R7 V( C
`className` varchar(255) COLLATE utf8_unicode_c
- B- R ?6 X, p' |/ y$ w: Y[Msg] Finished - Unsuccessfully |
|