该用户从未签到
|
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
; ~8 P# ]: Z& Z( \; I2 \3 t" V4 M& W( k0 Y--$ {+ D/ C. B6 @- Q: R; f
-- ---------------------------------------' at line 1* u( p/ Q4 R5 T5 R. h: b/ I/ C
[Err] -- MySQL Administrator dump 1.4
4 ?1 ?" L* G: K4 F--
; O) i, H5 g7 {# e-- ------------------------------------------------------' e4 O& f1 O/ N. e; X" ^9 c
-- Server version 5.5.153 ?" n, d/ O6 {* Y5 m
" K) A1 A! E. b- j9 g0 w
( k; v+ k6 R- j, M: Q% {8 l' j/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
& e- y5 ]- v7 ]/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
& ^0 S( K/ _; Y2 S( x$ g8 q/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
. L2 J, a1 T9 F, v" c/*!40101 SET NAMES utf8 */;
! \* x3 o c7 U: Q2 l6 _+ U' U1 x( j6 R4 G$ q6 \9 g/ _+ x
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+ E, M. E$ [$ t+ x6 K4 X/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;5 J- O# L i ~. x j
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
# @5 @: R" d" v# w7 x4 B7 q, a7 }) s
) ^. l4 P$ N% W, ^8 o/ Q5 t--
$ E. ]0 p& ]' w! J% C' O-- Create schema onlinexam
! I/ {) e- |. J& [) O% t7 k--
( A6 I% z0 }& U! [4 \, H5 h8 ^
3 A5 e6 k1 R T( m' r7 H4 L/ MCREATE DATABASE IF NOT EXISTS onlinexam;% D* X8 H0 w9 R; v3 j, W6 I% t+ K/ \
USE onlinexam;# e' \- U7 L3 K7 K/ w
) p$ W9 o. x" [7 w. N: ^& l. ^5 k: z
--* l- v2 M Z# o2 } C( k
-- Definition of table `admin`
K, G- H0 x( |5 h+ s, k--
* {% o5 v$ M# Y9 ~! Z/ V3 ^
3 v6 S( r' ?% ^. EDROP TABLE IF EXISTS `admin`;
5 S, u4 F6 q* i5 X8 [4 [) T$ w9 OCREATE TABLE `admin` (6 i8 @4 B% y' B8 N
`adm_id` int(11) NOT NULL AUTO_INCREMENT,
+ a1 U* V$ q4 n8 k% B8 q( N8 r `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
% F1 q/ e L! r+ w `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
: N/ T; h: X) Y' D% X# R PRIMARY KEY (`adm_id`)
H$ j' v- _, M& g+ u0 b+ N9 O. }9 E) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; B, r1 s. y' v2 }. l
8 K" n6 v; A0 W. E: | Q-- v; I+ ~- J2 s3 F3 A2 r3 G5 N
-- Dumping data for table `admin`
2 p1 J/ D& T6 F2 b& A" |--& Y( p) |0 O% B
8 x+ `- y. A- l
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
: }% b! J' W& q8 v% Y' N" R, ~6 E1 ~INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
3 J1 u& @4 ~$ p (1,'admin','52itstyle');$ H) b8 W6 M7 z9 r4 e
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;1 A: k; {. ^: E* j. i1 y0 r1 ~
. S8 f" f3 @& m: j: H* o7 N O$ @
% |: ~4 c! r1 p C- V
--
0 [1 G! t4 x/ b- I-- Definition of table `examtype`& ~6 X7 M& d9 E/ ^5 e
--4 n. h- A: r, R* G2 ^6 a
1 ^7 D0 \2 B/ n
DROP TABLE IF EXISTS `examtype`;
0 ~- b9 S3 f' i/ q4 I- u$ SCREATE TABLE `examtype` (
5 o8 w6 s6 P% D/ o7 Y1 Y: `( @ `type_id` int(11) NOT NULL AUTO_INCREMENT,* a/ x" X/ g& R/ e. l! J) ^. M
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,2 z4 U a. O* `3 e5 }# o* M7 l
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
( Y4 H4 c* x: H4 |+ w PRIMARY KEY (`type_id`)
% T* v, G7 X$ c/ o8 g) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;$ z* k' m, ~2 p* @% }; i
& \! c+ s0 e8 b9 i8 Q# R' O: ?
--
' X. w5 Y6 m- s$ T! _-- Dumping data for table `examtype`8 m: A+ W4 B& U+ O7 w
--+ Q$ _+ c- F( x% O' d% T- d# D
( L1 s. U9 Q) k) i4 L5 w* M
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;" H5 d' Q9 p! `
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES $ X! `; P" n$ \& {
(1,'语文','6'),
/ P! E: a K( k' j% J7 C. B (2,'PHP','2011-10-26'),
* [) E' h- B, ~: _ ^5 C1 s+ Y (3,'ORACLE','120');
8 g9 v: @8 E2 Q$ d) k) R/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;. C3 C" l$ I; r, T
3 p% n- ` q* e( f7 H
3 A5 @9 c) q/ V$ U4 \& w# g8 q$ s
--
! b" E" L% @8 T& S) W-- Definition of table `question`6 W( }! i7 I) U# I6 Q
--
" n0 R5 S: |/ c, T+ w. r
% n1 o4 C( g' JDROP TABLE IF EXISTS `question`;: L1 N Q$ w, {* C
CREATE TABLE `question` (! @ z- l0 V8 W; V. M5 d0 h
`qu_id` int(11) NOT NULL AUTO_INCREMENT,
4 c9 F3 ], @. A `type_id` int(11) NOT NULL,0 y# ]$ V$ g% I& y
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3 J& {2 s; Q2 _! O) d `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ t. H/ v3 ?# g+ O `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,) r' {4 j, o& i! j1 ]
`quScore` int(11) NOT NULL,
4 E/ z* N4 n+ q, Y5 E/ s `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 H( T* y* l$ y- q. f. {8 O- w0 f8 z1 I `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 V" r- W1 a) u ^3 O5 P# U PRIMARY KEY (`qu_id`),
: u4 S( b+ Q7 b" ? KEY `FKBE5CA00621011593` (`type_id`),7 Q# |& B1 S8 g6 s+ {
KEY `FKBE5CA006B04D67C1` (`type_id`),9 Z7 ]( l h. T. `' L6 \8 c l
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
/ ~- u5 y0 j5 A6 g+ `5 A- w1 D9 u CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
4 E, _* r; ^! ]. M; Y5 Q CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
% N9 g% M1 m8 j, I4 V$ o) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
. w7 t6 H3 T9 v& Q% a0 H# v( W
" o; A4 R1 ]; V( {--: M z) C3 V* {; \7 O$ e
-- Dumping data for table `question`
8 V; d/ C% s( Q0 h' `! C8 d--
9 q) K( @( w+ y E' K1 w; ^% e" _& ?( }% w7 y( m) [' d
/*!40000 ALTER TABLE `question` DISABLE KEYS */;$ v& T- ]0 o- Z, X+ G2 P8 `
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
2 A8 M2 c d4 I L" G1 C+ I ^ (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),$ H6 [8 F# s+ p% o7 F
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),1 n" {$ M4 q' e
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),& x R$ V! R ]% H1 W
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
) S$ D4 d, \3 K/ ~ (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
l. V5 T$ P$ P v (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),+ }/ `9 } b9 G! M7 ^& P! p0 v% ~' Z% L% E
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
" o/ a* J4 e1 c& ?" M (8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),
% x- K- h) t( P% } (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),* e$ k4 t+ t9 i) ^
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
0 N- A7 D* @0 b- i (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
1 |) y) g t! n/ m Y2 b( X3 u (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),& l% F! f1 H$ O) q
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
3 f v, y0 J- z: B. i" A/ R (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');/ W }1 o6 s, T8 N
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
8 {* O# q& |3 q z
9 [+ r* i y1 j3 m# U0 W+ Y
! [ b. Q5 T3 g$ A! R* @--0 `: o+ Z+ k1 B2 i+ Y7 Y) o g
-- Definition of table `student`
8 Y5 B. E5 \( [* m0 O7 [--
9 @6 w( i' s* p" l2 R, j* k$ _/ k/ u& a
" h7 U! F4 N8 ~4 f+ H" kDROP TABLE IF EXISTS `student`;
8 E7 a, O/ v; i/ a$ S- X* cCREATE TABLE `student` (
+ _& w$ y) j5 Q: u& O; h `stu_id` int(11) NOT NULL AUTO_INCREMENT,
" |. f; f/ U6 \% v" m1 I' Q `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,% }3 @) _4 z9 h. i
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
* F+ q n" j! [3 T3 S* K `className` varchar(255) COLLATE utf8_unicode_c7 D: E* c3 M, l+ w" h
[Msg] Finished - Unsuccessfully |
|