该用户从未签到
|
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 Y: q0 F/ g# O) Z$ Z
--0 h% D) R- s0 C0 I
-- ---------------------------------------' at line 14 h- y$ r0 p0 G) {' o3 B: z
[Err] -- MySQL Administrator dump 1.4
- E! r$ g9 i7 S4 Y3 G--0 b4 @0 f* W1 P+ m6 V+ @. i
-- ------------------------------------------------------
* _& ` e/ O. s1 K# x7 ~-- Server version 5.5.15
1 Y' ]* v9 v7 E+ B2 V% Q/ [$ Z! A# X' C( w( l; n B/ l! C3 t" G
* R7 l K/ G( q* m% l! {/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
: T: @1 r# \9 p6 l+ g/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
4 E1 ?- d* t) H5 P6 r: r C) m3 g+ I/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;4 D+ p: U& l; o2 Q* Y
/*!40101 SET NAMES utf8 */;
: C) |+ b% W* }9 i$ g6 ^4 @, m+ {! \1 f5 B& K) G
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;7 X5 X$ o6 z$ V7 y3 I6 n/ G! ^
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
$ }2 a0 y1 B/ B" m) G. ^0 h/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;" w5 e m) h' {; S) v. s, v
/ s% ?' S3 `+ Z$ R8 k I) @
: V! l8 E( r; T
--
7 P: Q* n- a, j8 }-- Create schema onlinexam
0 I3 B! t* Z% R--6 ^5 y) F+ G* @6 G" G3 X% O! Y2 K
4 N- ] |" c, v5 o: l. r
CREATE DATABASE IF NOT EXISTS onlinexam;
$ j* |3 O( J. m$ o5 h6 \5 q4 Z& {USE onlinexam;
( [3 j* `8 a' Z# I) m
( y5 s" Z: F5 M--
9 X! p4 P6 S% k6 u-- Definition of table `admin`9 A% [3 u" d/ {
--
9 t' A( t( f7 {2 A5 N
4 b( Q4 y' m, f) s, j) ?DROP TABLE IF EXISTS `admin`;" W+ U8 C D8 v) ?9 x+ ^
CREATE TABLE `admin` (
; H4 I; y( e$ W( ~7 \. ~+ K `adm_id` int(11) NOT NULL AUTO_INCREMENT,
/ N" l- _; x2 C0 ^3 Q+ @7 W `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,6 [7 y& {% L' u9 F4 q+ B
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,. o+ C$ h7 I" q# y/ W
PRIMARY KEY (`adm_id`)
8 \* V" i9 K. r/ Q7 E" [* d( q. @) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
; Z5 ^( A! a% s; _- g Z1 K1 W$ Y( M) I. t% ~, \: C7 L; x
--
9 ~+ b: {! s1 ?3 v6 A. f-- Dumping data for table `admin`
- \& d/ h1 |, R5 n1 z--
' N) d e+ \" Z1 K* G$ \+ E$ [$ _% F( d" G5 f
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
6 ?% Q! R9 G0 A# {3 e' M! MINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
7 l, g% H9 B% ~4 f9 ~. z0 U (1,'admin','52itstyle');
* u# c0 W6 P9 ` G2 G Q: T/*!40000 ALTER TABLE `admin` ENABLE KEYS */;4 n, \, p X. Z, e
2 m% g7 k7 R4 w4 c8 E
* Y4 ^! c$ z2 j$ ~3 b--
$ L2 K4 s6 g" x" i4 T& t-- Definition of table `examtype`
% e/ s& E; d( e* B% _; z" R% w--8 m7 E# s* B6 H+ @$ v- E: N- g
3 {2 F4 @0 S6 _
DROP TABLE IF EXISTS `examtype`; b' o4 K* u! W. f+ _7 J
CREATE TABLE `examtype` (
$ S; M0 ?3 m! e1 g: f+ A* v0 c `type_id` int(11) NOT NULL AUTO_INCREMENT,
. \, S4 @8 k. d* r9 x- f4 C3 q/ W `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,* K0 G7 u# ~7 F4 l) i
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 S1 |, ~9 z( Q; Y1 R* F' j% G2 d: m& L
PRIMARY KEY (`type_id`); i% x% X4 ~+ ]- S- g4 Q
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;, y* X* L4 }% ?3 G- Y* r
6 z+ A' F8 |% k- d! L% v. _! [0 f4 f--
( @. X5 t& E" m M7 `- b, p% D. [1 O2 g-- Dumping data for table `examtype`. a3 U& r% U" U' v1 Z
--! M9 X9 r% B( f1 p' Q- ~
; d' V; _6 i( G% k4 y g4 l, W/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
/ H( q: s/ o9 F o1 W" oINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES % D0 M( m8 Z" |
(1,'语文','6'),
. E4 {9 V, U# m4 A' N (2,'PHP','2011-10-26'),
$ l5 L0 l6 h2 ` (3,'ORACLE','120');
- ]- Y9 b$ h+ r, J4 L' n% c/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;8 {' _" g9 @- T) z4 x
; @. U* O+ ]! i9 T) c8 A) a# c3 ]- X, ^: t
--
4 d( p4 M, r$ @, j# h-- Definition of table `question`
4 k9 |) T% Z1 k) o$ @--( h4 T4 }* y6 {5 R4 n2 G; Q9 ]
1 T @1 S9 Q1 ?$ ^
DROP TABLE IF EXISTS `question`;6 @. y4 G3 T E+ T
CREATE TABLE `question` (
( X8 G) u4 H1 @, V _. _ `qu_id` int(11) NOT NULL AUTO_INCREMENT,# m& m1 e1 Q3 F8 `$ i' I+ R
`type_id` int(11) NOT NULL,
4 g% C$ k2 p9 k1 z$ L {% s1 b `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,: V8 |: A: \$ [0 [/ W! @ f
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 L# e+ f$ z% W+ E( c `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; r* t9 H" Y7 s2 i `quScore` int(11) NOT NULL,
4 s: x5 r+ I3 u- m# k1 W# { `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
. ~' W# Y* |1 W2 o4 ^8 r* [ `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 u. Q8 a: m$ a& N5 n PRIMARY KEY (`qu_id`),
" }5 Z% | `% C! T% v B KEY `FKBE5CA00621011593` (`type_id`),
' l" k$ @: x* s5 P KEY `FKBE5CA006B04D67C1` (`type_id`),. l7 y7 k9 Y- s" w# ?7 f
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),5 p2 z4 @# J1 g4 z5 P, Y5 t7 D
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
( h6 o) ?3 d, M2 Q5 {7 o2 p CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
( ~6 A# f; k F7 p7 ~) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;8 p n% e: L# j" `- y
, n6 G5 E& Q+ A--. X. w2 C) h6 z4 Q/ @) j
-- Dumping data for table `question`
: M! Q, g6 J! E4 x3 W" C--
/ U# _2 u8 ]7 l) ?" p' o- Y x+ O3 E) [ L/ H. j
/*!40000 ALTER TABLE `question` DISABLE KEYS */;! _+ l5 T0 z8 X8 M/ z; Y; R0 V+ Y
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
7 d9 H$ a. W2 [$ ~# Y (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),1 n( W% p: k9 P6 n# `- h
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'), }+ |0 i/ X. l! v ?
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),: ? c9 x, i7 O5 B. u. L5 W6 ]
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
+ o' z. K9 L. |0 i' P- B- K0 q (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
# d" m! _+ i8 N( I4 N3 M (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
6 y7 J8 E+ M' a" _9 Z* B (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
: x" g% i3 v3 ~/ l (8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),' T8 ?" p8 w, Q- z
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
6 u/ d0 q* e6 r- {3 K0 S (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),1 X& p6 w0 h+ I# p5 }# W
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
% e0 y2 m6 w) G/ D (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),1 v# ^! _/ R& I, r# H! Z
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),( J5 K7 U- s h e% H2 t/ W
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
* J/ Y4 X! n; ?. ^* z- M9 K& w/*!40000 ALTER TABLE `question` ENABLE KEYS */; X- h! G- V9 q5 ^! k0 q0 j
0 S, g, v/ w; I: y! @# [
5 h3 |+ a+ ]* w6 l--
! B% k# [9 c! ~. [1 C. D-- Definition of table `student`9 E+ M* P( C' {( N$ x
--
" f* x8 j- r: s6 S5 o
# X$ O: ^# t) u; m2 CDROP TABLE IF EXISTS `student`;
9 Q8 _# P% ^4 J. h nCREATE TABLE `student` (
( d6 r$ p& S# n' W. Q; d- ` `stu_id` int(11) NOT NULL AUTO_INCREMENT,
7 a" i1 L% p$ U6 z5 [3 i0 l5 j `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) d$ m! ]- e# _% B! o% p9 S; B `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 r5 {0 ], W, r- E8 g2 w
`className` varchar(255) COLLATE utf8_unicode_c6 \7 z$ t: l( a* u
[Msg] Finished - Unsuccessfully |
|