该用户从未签到
|
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
! D6 Y1 E8 P4 w) @# y- s--
8 w( O" u( V' Y) ^' B4 S5 t-- ---------------------------------------' at line 1
+ @, s0 N: q& ?- b2 j" v1 a) \! p[Err] -- MySQL Administrator dump 1.4
+ B" ?% k6 S% R6 G; _( `--
- x! c7 a4 W0 m; E# T, s-- ------------------------------------------------------( d* ], S* q5 d2 H0 u
-- Server version 5.5.15
- ~& d9 v/ I `" k8 Y, _
$ T9 J- E% t! T2 C" m- q# G2 h* f' u+ Q
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;6 H! o, ^9 U9 n4 P: S, m! a/ o
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;$ Y5 @5 E- b u* M5 f Y
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
. d& r( e- K- O2 {. z9 k$ P/*!40101 SET NAMES utf8 */;
$ @$ t4 C& u% R( E+ ~2 c4 U: @ Y6 A) h9 m5 F% E
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;9 G$ l5 ?' f6 m" Y* s* X$ e
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2 s2 M. h8 W' `1 a/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/ S& b: Y* [" s5 p: D$ T
% l9 k" ?4 i: J# S& i9 d% T
" E9 @$ w; ^6 \6 X$ \% d' l5 s--
4 B$ n H0 Q4 ]7 G }# \1 e-- Create schema onlinexam
, j1 f* k" o g8 _--
& w5 O- w6 c% i. e) U5 ^: \9 N7 S K2 d' }
CREATE DATABASE IF NOT EXISTS onlinexam;
~: N1 c) p6 c8 b" pUSE onlinexam;
# d0 M0 E ]9 I1 t, Q
! v( M u5 |; e+ y# h8 m--3 C! z4 w( U; n p
-- Definition of table `admin`
! C: i0 ?4 J& k: T--' B2 _- m! G. W& B/ _8 U9 P0 k
7 `% e. o2 F0 n. b% C( `1 [0 JDROP TABLE IF EXISTS `admin`;
4 c8 H% e. @- ^- Z' FCREATE TABLE `admin` (
+ Q3 c1 Q3 _. }% N) c; z `adm_id` int(11) NOT NULL AUTO_INCREMENT,' q& z; D: ]+ y5 c
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,& @* _+ E# G" [# w* O% i8 J" P
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
% o: g# p+ z, a PRIMARY KEY (`adm_id`)" o/ d' e( a& c8 i
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;8 @8 Q4 z, Z# f" P9 q& y. v
0 X: h4 K# s+ A# i. F--4 d5 ~8 s5 y9 i, `4 O
-- Dumping data for table `admin`
$ z9 C: V! C. N5 X& r* |. M* f--
* g* x; h! q# v% s
) ?1 u6 @8 F1 _* p1 n' K/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
' e5 V4 d' ~, K6 C) o- aINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES * @8 x+ F$ N% \1 i2 w6 P: G, h$ P, Z) F
(1,'admin','52itstyle');8 a! i( x1 z. T6 D$ k# v& @( b* q
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
6 B3 d9 W) n+ k# w3 R
. F+ m* R4 G! a) {$ w! q5 Z
2 V6 C) v7 M5 j--' J+ `' f$ d4 F5 {, c
-- Definition of table `examtype`0 K: Z7 t8 M7 j
--3 N+ i3 U7 [2 c9 Z2 C
% v9 g. |" g3 o: @. g3 W+ P/ aDROP TABLE IF EXISTS `examtype`;7 [4 Y' u, p# ]. E5 E2 v4 u
CREATE TABLE `examtype` (
4 v# v, Q2 e- S; a* a' a% ^1 i `type_id` int(11) NOT NULL AUTO_INCREMENT,7 e. l! L& G* P6 F6 r' E2 i. d
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 S7 Z3 g7 Y1 Z) [9 N, D4 s, G0 e `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,1 B, ^; o1 u& _; E4 ^# J8 {
PRIMARY KEY (`type_id`)
: s3 @7 K. N, @7 T/ L) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
% z+ w& N+ l2 E, X9 }7 |. g O0 E' |: B2 \& f* Q) w6 G I) s) Q+ r: V
--
# k1 B0 }' Y. V6 l+ w-- Dumping data for table `examtype`, {% m4 c. H: o# D$ k0 N) B
--
: I7 O, g' F W0 l; S' L* }3 M3 q- _ {7 q4 j. C
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;& S( Y9 \6 y; t; d
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES 3 J8 T* o5 w5 q4 |2 e3 |, \
(1,'语文','6'),
) f' Z" z% I' H# e6 M2 C3 y (2,'PHP','2011-10-26'),
* w m! X* n2 P7 |$ e! y- V0 C3 f (3,'ORACLE','120');
, r- Y. ^% \5 _, _/ P( |/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;' Y9 E' U. B4 @# p! {9 c
Y5 ^% k. M; W! C ]' Q c7 _' s# C3 s6 G; [! }' f7 u9 u
--
6 H4 q) t L7 ]# z! e' v-- Definition of table `question`- @7 @3 C4 H' N
--& g' C$ R8 d- q# I
! H. k% Q, V/ H d% G) Z6 G% @( b; BDROP TABLE IF EXISTS `question`;& F9 J- r, \4 b# s% Q
CREATE TABLE `question` (
1 Z1 X: l2 a# }! W9 ` `qu_id` int(11) NOT NULL AUTO_INCREMENT,
( k1 Q4 J7 u: P% n: m' a0 S1 { `type_id` int(11) NOT NULL,
" S% m+ s, d4 ?* j4 v `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,: c/ Q _% _& ^+ C. P
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,4 ?* c# ]" H; t& o- h/ u9 ?. J
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,. |1 O& b5 ]& z* T, K4 v4 Z& M' f
`quScore` int(11) NOT NULL,
3 L h' W! T8 ]2 P7 c `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL," T M6 F7 M8 u ~7 ~# ^* m
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
& \. _/ E D& L7 F PRIMARY KEY (`qu_id`),) |' j! P2 F- _$ v+ a$ b9 z, M# x9 j
KEY `FKBE5CA00621011593` (`type_id`),
9 G! I0 a+ M/ h4 A8 e8 V KEY `FKBE5CA006B04D67C1` (`type_id`),
- y0 E, ?3 h8 Z$ Y- X1 [ CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),! T6 z* U8 |4 l0 x: I. k! @
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),$ c/ t: e6 W5 A, J, D
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)4 h2 L1 F( Q- w9 g( [% c
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# V' P! ~# }. Y, b a) [1 B
, I: {# ^4 {5 \--
: \( r- C. d j- ^! {; w1 J/ W-- Dumping data for table `question`" L3 K9 {; F, G6 b( @' F, ]0 V( G
--
8 ^1 v& t& S% z1 F/ p. C! h4 v6 `2 K! C& e/ w( L+ W* j/ S
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
) B* i4 [. R" w" e+ wINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES & @. Z4 H+ |, [0 g
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
0 L5 l/ |8 }3 |( S+ E* g3 q (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
' z3 b t6 ?9 l2 q (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),) B4 z+ }# G1 U {
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
+ d; z/ J, w0 U% x (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),1 f) T( ]# \; T
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),' s. o' e, i7 \( r6 h, I
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),! d$ \/ ?/ V1 j4 H; g( ?! t, C
(8,1,'欧的拼音','简单','单选题',1,'ouw:you','1'),9 a6 Y* q6 j# }- r* B( ^5 y* z2 |, D
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),& R" b7 M$ r% `% D. a
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
. b; j. W" @3 U; w' s (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),( T0 U; [1 K) x6 j
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),! W; ~+ r% K( T% E9 z$ c! g
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
' ]4 D5 v9 [1 [ R M6 x7 w (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
! Y2 J8 G& e) h. c/*!40000 ALTER TABLE `question` ENABLE KEYS */;0 W" R) x; s% r
& Q) Z. U& B" S0 \# v( X$ b$ ]" s9 q E
--% a% k# O1 k3 R
-- Definition of table `student`
; G! G* Y! _. D. ]$ [; U: L--* x- ^, }! k. B2 F" C1 a
; Z' m2 O8 i& J4 _( F( J1 mDROP TABLE IF EXISTS `student`;9 W9 q' n1 ?. f! y4 z8 c9 [; t
CREATE TABLE `student` (' F3 N& N- s# b& H1 \% c+ T# `) U
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
. J7 b' e5 \( D `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,- N/ F1 `: c/ g" M
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,/ }2 ~/ z3 S# E! O7 E
`className` varchar(255) COLLATE utf8_unicode_c1 q/ }1 U" j0 i$ y6 h
[Msg] Finished - Unsuccessfully |
|