该用户从未签到
|
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
3 e- K; H8 X9 f/ P: @9 n3 R6 V& Y7 a--
: R7 Y5 _/ o) S& R9 t5 v-- ---------------------------------------' at line 1
5 C" e/ C- w5 ]. L/ C' n' o[Err] -- MySQL Administrator dump 1.47 K! J: }- o* t; I% q- y; ~
--* G) W* v5 v- c# K" D
-- ------------------------------------------------------
/ z# Y( Q, r( T" ~-- Server version 5.5.15" G* j$ S. d+ ?% G1 B' {4 L
9 c# w p# }& ~9 m
" v: V8 \1 A$ `3 d, C# P) Z/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;9 L8 C0 |9 J4 v" a9 d' r9 x
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;( U) M9 F8 u e
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;+ ^9 u! D( T+ G/ |8 w, O
/*!40101 SET NAMES utf8 */;* v9 m4 x2 K; p: b; \! P6 R: x
$ r- T! e% @& N8 D' d/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
' A% `7 z; U; R, r* M1 y7 x" _$ T/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;+ J4 @. E" }# j) F6 h1 Q/ [. v4 P
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;, ~7 |6 \7 A7 [7 @' I4 u, Z7 `
5 ?7 m+ D4 `3 l9 k; ]: I* T6 [; Q/ L; j8 L
--
7 o! o+ y- v2 L7 a2 H9 \8 T-- Create schema onlinexam. t; V e9 z$ _$ G
--
. @. ^ X+ u+ H* w6 W, b% p6 S5 N3 b/ q% u i8 d p8 v
CREATE DATABASE IF NOT EXISTS onlinexam;& f: p& j. d5 p: u6 H
USE onlinexam;
( ^- j! f5 `" L3 f% v0 f6 T. r& {8 g( }( ?, s& O
--
Q4 d6 W6 Y7 j2 b1 Z6 K* T. x' I-- Definition of table `admin`5 D. z! q1 G$ N# B# T2 i
--; }4 e; S$ B' @+ _8 V7 y1 M' ?
5 {. ?! }4 ] i3 K6 p; O+ I
DROP TABLE IF EXISTS `admin`;
) q: Q0 R& z/ KCREATE TABLE `admin` (' X0 r* k) J2 c' E- n) U
`adm_id` int(11) NOT NULL AUTO_INCREMENT,
6 K. D( c2 L1 Q6 \* L! U: q+ x& r; C `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1 j" D8 K. h5 x7 n `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,, D1 c& T$ q/ \! I5 s! E8 t
PRIMARY KEY (`adm_id`)# V r6 E- o* i/ O, x: G' v3 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;" k) U$ X/ A; o
" x; Y' f' I* h: U--" r9 j4 l" ` c$ n! u& m( P8 l
-- Dumping data for table `admin`
* y8 c; x; {" \/ C8 f* P--
" d- g6 r- l* F/ ^3 ^" ?: B1 B9 W6 q" _6 n% ]* Y1 d
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
( i- D/ l1 n& a o1 cINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES {8 R, r$ y0 l7 M8 V
(1,'admin','52itstyle');
% k/ E3 {# y* F: }# M/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
/ r* {! p7 O/ n* r! p1 O) i* ?8 D$ m# R7 ]1 @* ^
% n7 I" z: ?) a3 @' H: U7 U--. S& H% N$ V0 P* K4 w" e2 U" k
-- Definition of table `examtype`
. |: a9 u$ |4 j% ]0 o--
& b4 G8 b$ f) c* [+ v. ]# t- q, h1 K# p* s& b% Z
DROP TABLE IF EXISTS `examtype`;
2 o A1 v, U0 Q5 @8 t" D2 e. PCREATE TABLE `examtype` (
) C/ ~ c% n& P2 W `type_id` int(11) NOT NULL AUTO_INCREMENT,. _; T/ c) Q' Z! k+ e# J- R' y& U
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
( S: Y0 E; C. |7 _- C2 a `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,+ Y0 S9 Q- k* Z! l/ g, x0 q
PRIMARY KEY (`type_id`)+ o8 l9 T" d' u- O3 O
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
. p7 D F: H0 a
) B5 r; h( g) I) f% v--
$ l$ p2 ?4 ~+ c, b. e-- Dumping data for table `examtype`. E5 @9 A D0 |7 ?% v
--) s$ T# j9 ]; e
2 s) ?0 \( [; n, l! }& |/*!40000 ALTER TABLE `examtype` DISABLE KEYS */; d# Y. G; Y4 V( ]0 _
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
2 c i$ {$ n2 ] (1,'语文','6'),# o& P$ X8 f1 A- B
(2,'PHP','2011-10-26'),- a0 Z" B1 H8 \ }7 x7 b
(3,'ORACLE','120');' l* t' ^ `4 j" i+ D3 A, F
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;
. d* H; M9 D- H7 R9 r/ k7 K# ]+ y& Q
$ \6 A5 s- O6 g8 ?6 @
4 I2 h! P1 x8 i/ i0 @--! A( v: I* q0 P2 N0 [+ C
-- Definition of table `question`
/ G5 l8 T: ?4 w3 [. @4 w-- O1 F; y9 B4 [1 T
% T( p, y3 }; l: q6 |' X% \
DROP TABLE IF EXISTS `question`;: F/ _* P3 q3 J5 A
CREATE TABLE `question` (( Y& j5 a3 @8 C4 Z" q& x1 ?
`qu_id` int(11) NOT NULL AUTO_INCREMENT,( X* D! Y5 N& G) ]7 _& K: f
`type_id` int(11) NOT NULL,5 T9 B0 R( F+ W/ h
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
/ z1 o/ b! a, B9 S' h; ~# s3 Z& s `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1 x) T9 v* z5 ~& g `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; h2 X4 j V' b) y+ E `quScore` int(11) NOT NULL,
1 p# U# Q' f n) m `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) l0 L! i0 Z& N! K6 b$ l5 x4 _9 a `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
! H+ ] z- v5 ]2 }! |, \$ ~2 Y PRIMARY KEY (`qu_id`),$ D% G; B" v7 S; Y
KEY `FKBE5CA00621011593` (`type_id`),
0 C% Z ~. ]2 w7 t* b# I, l9 O7 A KEY `FKBE5CA006B04D67C1` (`type_id`),) H% c5 b0 \- |* q0 t P1 k! f
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
$ |- ~" z J/ V) B; I% t5 d CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),& ?- g' H+ @3 y
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
9 q; \( x- A2 E6 J k$ C% s) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;7 f8 R' t. H2 ?" I8 V0 h
0 M7 l ~6 y3 i, c. j
--
$ E6 H; F: M1 H8 Q-- Dumping data for table `question`. z; B2 _6 ~! W
--
8 w1 c5 {; |; a. P
/ `" A T! r" e2 b. h/*!40000 ALTER TABLE `question` DISABLE KEYS */;: [1 H5 q2 W. s9 @. {4 x! Y! I
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES 1 h3 ?5 V8 h P$ b! G
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
" j2 Q# ^4 o, ?! S: o" A. f$ R (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
0 l% g6 o0 I4 ^0 ^ (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),# ^4 O4 B- ^4 q) d. W; Q5 A
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),+ @2 }& b. Y. V- N9 p0 \) F
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
7 M5 Q0 G# c8 t0 {! Q; [+ c+ ? (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
: [( x/ r9 |9 `6 |# w: t) c8 w: g (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
' J" Y; |8 E) p6 J! \+ C w (8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),% @4 i& _; h7 b+ D1 e
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),* s+ d' N7 C! u9 b4 m; n7 C8 l& j) L
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),) P9 U( e# V2 Q2 [0 X/ f) y9 P
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
6 h `3 U: g! \' q; X (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
9 R- O1 f8 v) s. V/ D* B (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
2 [8 W: N5 N4 I8 p9 ~6 u$ Q8 w (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
# j5 G- x0 c) v! Z/*!40000 ALTER TABLE `question` ENABLE KEYS */;. {# o4 L* C! g. K8 g2 m* B6 n6 \( J
) o& t; r7 F3 o- s4 n$ {
# q! S' F" M6 m, X
--+ `; I, M# n2 _! S, a1 |
-- Definition of table `student`: K7 v# l' q0 n# N% z, ` e
--
& l" F# Q6 i+ ^8 b# {4 A, `# d0 g5 o2 D7 }0 y
DROP TABLE IF EXISTS `student`;- u$ B& `3 U! M/ N4 p( r5 J
CREATE TABLE `student` (
1 a7 T# r! f) p6 [5 } `stu_id` int(11) NOT NULL AUTO_INCREMENT,
. b& c4 W0 U: c `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- p3 s! ?0 L1 ^0 L$ [, K4 r/ d2 _ `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,1 c; G4 L6 M* |8 G; U
`className` varchar(255) COLLATE utf8_unicode_c2 r& M8 B- _6 {" ?: P
[Msg] Finished - Unsuccessfully |
|