该用户从未签到
|
198#
发表于 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
& |! b: O, b" r/ u D. E2 x--4 R# r6 [' m$ _8 L7 W: ]
-- ---------------------------------------' at line 13 \4 N5 f& B b. R: W! O Y
[Err] -- MySQL Administrator dump 1.40 [" E8 k, C5 t2 _8 A2 [. Z
--2 W' X1 a0 u; t# w; h
-- ------------------------------------------------------
3 @9 r' F2 V1 d-- Server version 5.5.15
! s$ P3 y+ P9 g; j9 F0 b E/ ~, ^7 }% F' H0 y. M3 [
- L9 F. a2 ]* k$ o3 m9 ?2 p5 Q/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/ e4 b9 N0 n' H5 Z. C& y+ r
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3 S* j! O. t, }" Q/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;: f6 [' ?% s- _8 N! F5 Z2 e9 w8 E2 ~
/*!40101 SET NAMES utf8 */;% S8 \9 K& C1 S/ B- r: c" C$ O& t& J
9 m1 p W A% J3 Y$ ^/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;3 U& b/ E. _$ `% y
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; x4 e: m2 r/ I8 [
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
9 k# q8 e2 D1 j5 [) f" D1 o
* N$ y) G L0 T
* n1 H& |3 Q6 N# O6 K4 @! G5 i0 _--
T( U; E! c- S. b! X-- Create schema onlinexam& ~* x" ]: F+ ?4 W
--% q" I. y$ V0 R* ^
8 H8 i7 `! r# r1 f) V+ g
CREATE DATABASE IF NOT EXISTS onlinexam;
8 @/ q# n! {" A3 M bUSE onlinexam;
" }7 a! \. k3 I5 [& S# f0 Y; \. c6 Z! V: _0 e( Z4 z
--
, E1 B( h8 Z7 t7 G# P: `$ b N-- Definition of table `admin`
: {# g5 {0 i. a0 O6 }" r--4 k$ f9 o# J0 I1 y0 V
% x' g/ ?; d8 j9 p8 q; A& Y
DROP TABLE IF EXISTS `admin`;" _& h R/ S$ @# B1 }
CREATE TABLE `admin` (" F: j l& p2 B& P; t/ ]7 T: K! N% h
`adm_id` int(11) NOT NULL AUTO_INCREMENT,
% W# h. Y; ^" K7 z& @& N3 l `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,3 L1 v$ }7 N( E; w& V7 t" }
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- g- a2 u5 E: _; D) w# u PRIMARY KEY (`adm_id`)
' _9 b& }( N. t3 H) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;: A% K9 [6 e& P( J' b
# V6 H( r2 ^, ], x8 M
--" A8 ?8 y+ r5 u5 o! J
-- Dumping data for table `admin`. A. c) ?9 Z4 D8 u, H B5 N; p
--
, f% N7 @+ Q& w) _8 R2 p+ y. e: C) r! s% ] J
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;4 D8 W7 ` O) f4 c
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES 6 v$ F) D! `" w! }8 H: I$ @' w
(1,'admin','52itstyle');% G, r; Z2 K' c1 g6 i
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;8 k! n% S- S" N3 a& x
9 a# H5 ~$ |, O& _; k% `
& M$ X9 [. B, n) E! o* R1 ^--2 A! S, h3 b& k3 m3 m
-- Definition of table `examtype`
0 F( W$ J5 E, ?% K--
3 V$ E* l: |2 L/ p) ]5 ^' E- G/ X8 r4 F$ L6 N: i( I
DROP TABLE IF EXISTS `examtype`;1 }: y6 u1 d' ~6 e
CREATE TABLE `examtype` (
1 U( u. Z/ E% y4 K7 [6 i5 T `type_id` int(11) NOT NULL AUTO_INCREMENT,0 P+ r8 U! L$ G- P u) `' ]" S; Q
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,& ]' e* g+ Z. _, K; ]
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
/ ]1 a; F$ B4 \0 w' H, m# c PRIMARY KEY (`type_id`)
5 r" x% Q7 P d, ~) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
' m" }+ l1 L6 l9 g( R9 ]) S. w) [3 ^& H% T( E7 a, C2 [
--9 q% ]0 V0 m4 D5 u7 s
-- Dumping data for table `examtype`4 O5 O7 n# p- U( V2 j
--, \( [5 u. j9 ~% W) S5 `
3 L, R& l0 X! l. n- L3 f# Z9 N
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
; n! [" v8 W! ~, ~INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
3 u2 \2 R6 ?# K% B5 S$ ? (1,'语文','6'),& W9 I1 o; }0 { l, \& ^
(2,'PHP','2011-10-26'),; C1 X7 \1 Z8 n% K% \
(3,'ORACLE','120');, p' z# I. A+ R& e6 j3 X5 ]
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;* E3 y; t8 f, s Q* a9 S" M
- i9 _5 X# V4 ]9 K0 |
0 t: s: j% f/ P" t--
/ L0 E5 t* G3 S' H& u-- Definition of table `question`4 A6 K+ F* I, j, Q8 E; ?, I, N
--. Q3 a3 p* A) H
$ i0 i) ~* a; v4 ^# r
DROP TABLE IF EXISTS `question`;5 L9 @% v) w: T- W3 E/ c
CREATE TABLE `question` (* c' M# w! A( x' s) O7 k( C
`qu_id` int(11) NOT NULL AUTO_INCREMENT,
) b& F8 Q8 C; r: E1 |+ m `type_id` int(11) NOT NULL,/ }4 @5 i- X* ~4 w- j" K/ D
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,+ O; ]+ w$ @( M
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
$ n- s! W' X$ x0 m; \+ J `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
# K1 K# N) S+ | `quScore` int(11) NOT NULL,
[# A7 V$ @6 c0 y3 K4 k `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 P, G& X3 H% P3 ?: B V0 u# m: r `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
# \0 p7 l4 d: z6 G0 w4 M X PRIMARY KEY (`qu_id`),
+ B1 ^. m) w% A9 E2 P KEY `FKBE5CA00621011593` (`type_id`),
) F( E) d2 z- o0 H; t5 {& |. n KEY `FKBE5CA006B04D67C1` (`type_id`),; ?; w6 U$ R, P( ^! i
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
" P8 I1 A% d9 j6 J/ {2 b CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),+ _0 D8 S; t/ A6 K- T4 Q! G
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
& Z2 _5 A1 ?. {; I3 S) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;! R" M1 G- i% J2 f7 I
1 L2 p' n& J+ V) J--
7 A( w; ^' Y+ |: K* z4 K, }-- Dumping data for table `question`
: i% n7 e- }. p--
0 u P& Z2 m9 m$ L; m- l
) q$ A6 ]- [" R: ]3 x2 u, [/*!40000 ALTER TABLE `question` DISABLE KEYS */;
5 R% u" m* X% f, ]' H# K0 l( AINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES ( G3 W3 `0 _2 ]' {# U% O+ s
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
4 Y- K: J- c9 K1 d( ^ (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),% @; x ^1 |3 `( j) O( [7 K
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
8 u5 H4 v$ z! N (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),' U4 x0 n# d0 K: }
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),: }/ J3 K& e& ~# G: C' L1 a0 R
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
( L% y) g" U, }) Z (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
" U* d" Q& V# q# U8 i0 h (8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),7 C( v& Z5 b* ]
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
. m: L4 y4 D0 O* Q9 Z (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),9 j0 W6 x8 ^* F! e$ o
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
2 z3 V4 ]* N2 e$ T) N# G R; Y, x (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),( z O: T( K& \' ~
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
) E# c/ u% L9 i# ^6 X( P (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
8 q2 |. y3 L. R' d/*!40000 ALTER TABLE `question` ENABLE KEYS */;& c, `! ?9 x+ z) I% I: p& _
1 }% ~0 K+ p) _9 e+ Z) _' T: k" Z z9 s8 d' |1 y) i
--. Z( F% P& p/ B& g* |! n
-- Definition of table `student`% W5 M" q; I& K9 i/ H3 Y5 `) c
--, D0 u& o& R5 g) i7 a" O, a
! g6 |2 ^9 u9 Y
DROP TABLE IF EXISTS `student`;
& a- j) l/ k6 Y0 dCREATE TABLE `student` (
4 e: v2 g7 S+ l3 y) A" U2 c `stu_id` int(11) NOT NULL AUTO_INCREMENT,- N. i& G8 q# k- k; {; _" V2 [
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 A' v% G1 T/ }: g& {; W: W! \, ?4 q `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,; g0 U& L9 s/ E
`className` varchar(255) COLLATE utf8_unicode_c, B" D, b$ f. s+ h2 y
[Msg] Finished - Unsuccessfully |
|