该用户从未签到
|
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
" A/ d8 s( J5 V& Q& V' X--- ?; y+ h! f, c, j* H. M3 K
-- ---------------------------------------' at line 1+ z/ }+ _% L- ~9 X2 Z- J" P# r; M% \6 F
[Err] -- MySQL Administrator dump 1.44 o, M( o |" V2 N$ b6 |# r
--
: z3 [" p9 o/ \6 Q) F-- ------------------------------------------------------
8 s' h& w. t/ \. y# x' w-- Server version 5.5.15
) |3 l* h" n; l" x% A
3 T2 S+ ^7 H4 b! R! y: K9 T8 x4 s1 P4 |1 q6 o" \
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;3 L, b; K, e" o, c
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
1 I+ X9 _) M9 u2 K" w& x. b* E* m: \/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;9 g) z5 z& T" J) @. g+ D( ]% [ P
/*!40101 SET NAMES utf8 */;
$ g6 t6 H8 K/ U2 _! t8 g, k
+ c% E# @ u0 J( W. f/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;2 I: ?3 [9 B) A
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
# \2 S- X; {, w' _# k) Y c' }/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
, T8 A9 ^# {4 n' I, m6 D& S8 B( B3 ~; Y8 [3 j# V6 S
+ l T/ C! I" t; \
--
7 M, D0 n0 t8 J# M& y3 ^# c& e-- Create schema onlinexam4 I# E8 K1 K T+ ~# g
--
' B4 `2 N; U9 c( X: ~/ r/ s( P U
CREATE DATABASE IF NOT EXISTS onlinexam;
E0 M. o3 j! e8 _5 X# VUSE onlinexam;0 {8 l( O" f3 m5 Q, B
( x. K5 |2 [3 U4 M ~3 M2 j
--) D' E- s& k# B
-- Definition of table `admin`' e* X7 p8 I" y( N
--2 \" U+ i" l) S
, F0 k5 A- r" J& xDROP TABLE IF EXISTS `admin`;
% [, i/ s9 w3 s* d. o+ W( pCREATE TABLE `admin` (
2 h( `3 M' F3 g- ~+ [: Z `adm_id` int(11) NOT NULL AUTO_INCREMENT,
7 v8 I8 m5 z- t& ~1 P+ n6 L `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 z$ g5 A7 m( b: g* a" o" ?" C8 g! h8 k `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ C6 ]( d/ R. Z0 v PRIMARY KEY (`adm_id`)& N# D9 D( K. p( f1 ^/ [6 N
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;2 E: v' Z3 ?: P0 m9 F! g
9 T0 s& @, i6 |2 K--4 F2 _) p4 n! o! R! i. c% d5 P
-- Dumping data for table `admin`
1 [% }7 E3 D+ H4 K--
$ m! R0 z0 e7 @1 u( N: B/ g$ v9 M; Y( {6 X9 @* k6 s+ R: r* N- \" f7 U
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
% }* B. V) O# n9 J3 hINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
" E0 d3 X# d q3 `. L' [! S# h# \! h (1,'admin','52itstyle');% q/ T9 t t/ A3 \0 z1 o
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;" S8 L0 W9 w6 [. U
5 ]# y* i% U2 u. l
; S @8 I* `5 r+ p- | g--6 s, X% N1 s( x6 T) _ l, j
-- Definition of table `examtype`
5 X3 |7 @* C; F6 T! u: C--
/ e+ | b: z7 u+ R u. H) w( ~& R
" [. p* Z0 |8 P' [8 ODROP TABLE IF EXISTS `examtype`;
, u: U: H0 X# `( DCREATE TABLE `examtype` (
, ?7 Q3 C, ?& K# h `type_id` int(11) NOT NULL AUTO_INCREMENT,
" j: ?$ d" t6 m- | J `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,8 Z- J e# o3 u1 S' v
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,4 c/ y7 p3 s: N9 E+ m! U
PRIMARY KEY (`type_id`)
- @1 `( K9 q* t# M1 Y3 C7 z M. L) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;2 D5 i H$ ^7 Z
/ h2 H& J' w: s( O--5 v: C: J D6 v/ W, B% P
-- Dumping data for table `examtype`
6 M# k9 e/ [7 ]; S- b. o! e `$ W--
I# L8 }7 [8 N
' D- P/ @1 s/ x& q5 E0 U/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
; [+ F# t: A& H$ UINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
8 [% X C1 Q6 |8 B! @ (1,'语文','6'),
; o; ^- K) }# a3 l. U/ N3 r (2,'PHP','2011-10-26'),
, P2 {2 L9 R" M0 D6 s (3,'ORACLE','120');
/ X9 s8 d. w& H/ I+ \" @/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;5 c: r5 W S0 W
, o/ }, P9 E# N* ]' q$ S9 a3 H6 i! j4 w% U7 I% f
--
, ]" x" V$ L/ {+ p-- Definition of table `question`
. a: D& Q0 r, D5 K: U0 w--
; a- T. Y+ \) m4 C4 ]9 ^( ~1 w! k/ ` g$ M4 m0 r
DROP TABLE IF EXISTS `question`;$ ~& f8 T" J. D( r* f) n
CREATE TABLE `question` (
$ f9 z' n2 W- d6 Y; v5 h% c/ U `qu_id` int(11) NOT NULL AUTO_INCREMENT,
; M* B, m+ c* y% g, n `type_id` int(11) NOT NULL,
0 ?7 w" ?* m/ g$ { `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,& N S8 p( l7 [4 b+ Y" M
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,3 r! S% f# Q7 W. u
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 u/ X& e& |9 q9 Y `quScore` int(11) NOT NULL,
6 D, Q- q7 B) K `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,6 a/ o" S8 c2 [/ P0 l
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
" u& W W/ A* p' [$ @ PRIMARY KEY (`qu_id`),- r. O' J8 r4 U$ b( ]3 P/ F
KEY `FKBE5CA00621011593` (`type_id`),
% e6 h* Y- }) l9 q KEY `FKBE5CA006B04D67C1` (`type_id`),
# o& W: X" o0 Q- d0 l CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),2 P+ b2 q' w# `/ K' }
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),- l2 e/ O1 ^5 d+ {/ P
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
( Z5 |- `4 B2 f) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
; e- P3 S' J E$ a5 c; s( E8 ~3 K0 o" S3 G
--; P& Q2 P1 B6 c( o2 f1 q( U( W5 i& h
-- Dumping data for table `question`) h; h( |' {+ G) d* R. A
--" b v2 c/ B6 h: Q2 k& X* p' [
4 K# [9 \) \4 |' f+ j4 X5 B3 J/*!40000 ALTER TABLE `question` DISABLE KEYS */;
7 D/ r! i: x$ ~: pINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES - M2 j, n) l* t& R& H' ^. Y' C! f4 c) A
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1')," z5 J% K* K6 H4 j! d, _- _# T
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
+ `+ _) ^* _$ f (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
/ C# W- K3 R$ Y7 h7 Q# a' k (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),! b% n$ _) D* ^* Z7 F
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),# {1 i& A8 O: `1 c6 ^: ?& j
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
, }7 `' E0 _+ r- ~$ ]7 R# R5 z' Q; i (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'), i* R7 S" Y/ W# ?: y! s+ p
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
8 t+ v5 ]( g8 b6 [# W (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
4 m8 Y+ B: v" P& x& q6 U" |- I (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),/ R# |, e* `" x& p: ]" u( x9 D$ S
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1')," u \. R+ f y) F
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
- n( S( \" ~5 F) h (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),4 r+ w8 g( X1 }7 D( J. O0 C) x
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');5 W: ?/ |$ W+ A$ V. T
/*!40000 ALTER TABLE `question` ENABLE KEYS */;8 R/ \, \. J5 Y2 O8 i7 {; H
; g j8 a2 g% l
/ a/ V- @6 B# q& I
--% z' X4 t) U8 D7 v
-- Definition of table `student`" M% {; g6 U3 Z# O- ^/ s X" f7 h
--
. ~4 V+ w7 i7 g4 S1 D
}$ R1 T! }5 D0 [ c0 I* jDROP TABLE IF EXISTS `student`;3 c+ I2 s% L2 w
CREATE TABLE `student` () a1 p' g6 g2 k. j0 n) `: y4 k; _2 a7 G! z
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
3 y: A/ D0 L* N `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 K {' H+ F* t# A
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 w, a9 W6 z f) q, I) B `className` varchar(255) COLLATE utf8_unicode_c+ P- w/ T* N9 ]. U5 V5 r. v; F: H
[Msg] Finished - Unsuccessfully |
|