|
该用户从未签到
|
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/ l9 ?' X$ g5 `% c9 o9 d
--
( U/ `; q3 H* Z( O! d, A-- ---------------------------------------' at line 1
; x- j# m; C' E! [* b[Err] -- MySQL Administrator dump 1.44 q1 i, n1 a$ p' h% e* y
--
! L/ I( p" L' D-- ------------------------------------------------------+ a+ s: l* F+ D p4 M
-- Server version 5.5.15/ ^8 o$ K1 {) [4 o0 r
C6 A8 j) S$ z2 z, z% ]# L3 s
2 [4 v0 r$ T" @. Q X0 U/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;$ L) V6 {, {2 r8 D
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;& e& k" S; j- m3 h$ c ]4 o
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
3 \ N q4 e1 k5 c" v" w( g/*!40101 SET NAMES utf8 */;/ f) Z4 h: A/ N! |+ m
$ k4 ]) g! ~ V. |6 L' S9 X1 l6 H
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
0 ]5 r& g& }! |$ F( c; @% [; I/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;. I. L0 E: Z1 t" H2 v w
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;7 ?. f% n( P s0 d
7 B% u$ Q& U9 p, S
) J) m P$ W- T2 c& S1 a
--9 L0 I" s2 n7 l R
-- Create schema onlinexam$ t) j% p7 j% w" c- d8 d" C! f8 T
--: ~; o* T1 B' M3 w0 ~
5 c0 L3 `' Q% G" K+ |CREATE DATABASE IF NOT EXISTS onlinexam;2 _. V8 `& V! _- [2 L. n4 ^! h
USE onlinexam;
$ v1 C; @/ q" v& Y1 y# X( G, K$ ?$ s' }5 ]( _/ l! u4 h
--/ {; ~" \( U. Q3 Z% B/ w
-- Definition of table `admin`8 u: v4 D1 s6 @7 R9 x
--! M& W6 c) z# X
# \$ J* ?$ L o S5 H- c$ JDROP TABLE IF EXISTS `admin`;% r8 Q. z. O1 K1 `/ w
CREATE TABLE `admin` (
3 N4 ^* S! q4 m; L+ O `adm_id` int(11) NOT NULL AUTO_INCREMENT, p0 n' D1 F, @
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
& L; F; e! Y# [ `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,/ v w; x9 `4 b' Z+ O7 g5 y3 t% e( @
PRIMARY KEY (`adm_id`)- c$ @! M1 {9 i* y
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;3 o3 N4 {5 r/ Y( N. m6 U% y+ p4 u% y
. S" v2 ]' Z: o4 N7 f+ X+ H--6 X; B% E2 t3 G j' ~
-- Dumping data for table `admin`
6 @% I& L' }' f0 J2 x9 _' p--# |; k. f# l+ V# S
' [1 N& }% [; I ~/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
' L3 y1 t6 s& e* jINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES ! ?7 H2 u: t5 Y& x5 c& e
(1,'admin','52itstyle');, z6 U; K. q- n4 t0 m
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;& z7 s! s( W& P+ S- e* r8 K
( Z- g* ^3 g% i
/ L0 H: S3 q; w: O; k/ A0 ]0 P--- `, E% @" N3 f
-- Definition of table `examtype`) _0 _4 Z0 m2 b
--) l/ h% m& J" [/ |* s# v
, M5 z6 ?0 [( I- L: p! jDROP TABLE IF EXISTS `examtype`;
6 g! S3 Q2 w( J0 V5 I0 q7 bCREATE TABLE `examtype` (+ R: o8 r" A- C! n
`type_id` int(11) NOT NULL AUTO_INCREMENT,
& |# j* p3 p1 D; E `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 v6 f1 ]( O6 p) k
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) l; L# m0 j4 M+ S PRIMARY KEY (`type_id`)
- g: x3 d: V4 B) q) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;: @6 T- K) |0 {3 _+ @
; _0 `+ z" w2 u% l
--6 ]( V+ {" p3 s. ?9 z3 H7 Y( e
-- Dumping data for table `examtype`
. b8 L! Y w Z1 S8 A3 e--+ q+ y7 w- r; M0 I) j0 H: K
" N y8 c* m: `# h/ s9 o% f/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;) Y3 b* p2 u% k( p
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
, `: D6 A7 \3 t5 Y& s (1,'语文','6'),
- P2 D' b4 Z) X9 n2 O4 m (2,'PHP','2011-10-26'),
1 l5 e" G! _9 ^, c0 P7 |* v (3,'ORACLE','120');5 j9 [7 F: B6 t) h7 B# ~
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;; S) t" o7 Q# O0 R! l8 Z
$ j% E7 v1 B$ i! L9 b
, J2 h8 ?6 @) F0 a--
. I1 }) c5 y/ |' Q! V- L-- Definition of table `question`* {7 S* h$ Q; S$ Y8 h+ u
--
. v! k8 I8 A& P- ?0 o! D$ S, d: y; d
DROP TABLE IF EXISTS `question`;) W9 t" U& m2 G/ r
CREATE TABLE `question` (5 n. [2 f9 B* ~, }
`qu_id` int(11) NOT NULL AUTO_INCREMENT,7 R; d9 T) ^4 L. h2 u, V1 G
`type_id` int(11) NOT NULL,: f0 U' U% ?8 d; r
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,9 l. s1 t5 h$ U; N( t5 u
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,% r) D* S& q0 \0 a T4 K
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
' v& l, |4 V* a' {# x _ `quScore` int(11) NOT NULL,
2 G" X1 I% J) O1 J( B: c `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,! U7 @0 W; A* X- i' n1 z
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,; q9 A$ w! B0 _
PRIMARY KEY (`qu_id`),
: @ x. a& y2 E1 z: n5 H( Z KEY `FKBE5CA00621011593` (`type_id`),
4 v) O5 ]; f7 T KEY `FKBE5CA006B04D67C1` (`type_id`),- I% u: l: b) I% y+ A" g/ @
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
% ~$ x! T: h! Y1 M+ b% F CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),5 n6 Z; L" t" A, N1 h4 G6 O
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`), X# B0 z0 g' ?
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;$ F' b/ n, q' U) G6 |
; t: x% s0 p$ C) [) I7 R8 q
--* B5 c$ w' d3 c0 }+ z: @
-- Dumping data for table `question`+ t2 A: D% G- b
--
% N$ v, u. K* d3 H0 i
9 h" \ f0 p N& l+ c8 ~$ v. f/*!40000 ALTER TABLE `question` DISABLE KEYS */;9 h4 G. }7 J' m3 |, }
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
: }/ C0 }4 Q8 G& D (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),! ?# o* i( l8 G* Q8 c" ~: a& O
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),* \7 Y4 |& m/ C9 g4 Z) K/ Z
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'), o5 ]$ u+ C" F8 ^0 ~
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
$ T4 J6 ^6 l% R$ E% s- c5 R (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
) m8 x' u) K9 a% g) { (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),. Q- o- X+ S- c% h) I
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),8 G3 m! \7 D3 q
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
: t/ v( R# P) G* L2 q- [6 E5 B (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),( X: Z; d# D4 ^2 b
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),8 b; ^: g8 _! T x* s3 A
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
3 }$ S% P- _( N) J; y (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
+ x1 I. l6 D1 j S4 w9 C- S (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
+ _8 F$ z- O2 s" `' P/ Z (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');5 p: A7 A) ]- U% _: f3 X, U7 ~
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
" \1 Z2 t, F- e+ p! M
& u5 s. B: J; z2 o- ?" v/ ]
) ^! z _. [1 x: k s$ B; s. d* ^--3 {8 q/ o0 r& |
-- Definition of table `student`
( L) S) U/ C% V9 Y* X! Z, Z--
! a/ Z9 G1 {9 z& d0 B! l- Q9 ?: Q# g: M8 H
DROP TABLE IF EXISTS `student`;
0 E6 {) V% b+ N! p) S/ Y9 [CREATE TABLE `student` (
: _) B" }$ Y9 i# V& D6 Z6 A `stu_id` int(11) NOT NULL AUTO_INCREMENT,
+ z9 L7 \2 Y; U1 s4 U `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
' J u( a+ |. d `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
0 |. [7 B2 a9 H: j `className` varchar(255) COLLATE utf8_unicode_c
3 e/ t& f; u5 _[Msg] Finished - Unsuccessfully |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|我的日常
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
