|
该用户从未签到
|
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+ d- R6 d. V& \
--
E- T0 g8 j+ [5 y-- ---------------------------------------' at line 1
% A& D; ^# }/ V7 A5 E" G[Err] -- MySQL Administrator dump 1.4/ t$ x2 T- n0 `' r- e# z9 G* ?
--
3 p3 g6 E! X* A-- ------------------------------------------------------
' H( L# V5 \& N# j4 `1 D* a$ S" T-- Server version 5.5.15
m( V5 M6 {8 C' t+ B6 y0 b2 h7 r$ u
, H! A0 _0 i8 G2 ^/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
) m8 M) E; U/ S/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
! E3 X2 b j- P8 R k/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;) L ?0 r. M$ O5 R" k
/*!40101 SET NAMES utf8 */;# F6 @$ t+ y, I
6 g* f: l D1 i! f
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1 d' k0 j; ?% }+ ?" {* C9 K5 ]/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;" i s/ e( f' r% p$ z
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
1 _1 s5 L' v! M5 R* v$ {
- ^+ G- r, q, p7 n# `8 W0 P
6 T. R- X$ h# e1 l--/ q+ t9 {' s& q U- j
-- Create schema onlinexam
$ w" }' a; D# V9 e+ _. G( V/ f; a9 B--* ?( o/ w+ A: Q! a( w# s6 Z _
; M/ o, B* ^7 P4 W: hCREATE DATABASE IF NOT EXISTS onlinexam;
1 d& p" c: f2 w& J. k9 o! S. {USE onlinexam;1 ?0 }4 ^6 q) V7 r3 N; `# H
9 v) {$ O {* F8 t. C* R. }% k
--! Z$ j0 }% D2 \" w+ e/ H, _* h
-- Definition of table `admin`
- [2 ?/ f' e% }# C2 a--
; v, b. `2 R' Z @
: J+ q- B; I* b) l4 ODROP TABLE IF EXISTS `admin`;
' |9 Q- ]# B; W* j% H3 e+ ~CREATE TABLE `admin` (
) n- b0 c ]' a# K `adm_id` int(11) NOT NULL AUTO_INCREMENT,
- p; ]0 s. ~" e; h" @ `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,# {. ~3 J" a# v
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,# f' g. m! A/ X
PRIMARY KEY (`adm_id`)
. r- x/ d1 g: C# M3 n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;1 \# w8 ]1 c9 u6 |
. G& W. H3 Q+ d6 S--
2 |, z: S4 i4 u-- Dumping data for table `admin`
, {' m% D7 U ]% ^--
1 v# J' v6 U7 B
# f& p5 i" t ~5 b/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
$ `& b: e9 P( j: y% x C+ r( X& XINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES ; x9 m& C5 z& R; i
(1,'admin','52itstyle');7 a5 x' W+ z- Y* z
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
u) P9 T. r9 D
5 X& T" v8 y2 [; J6 P" S. k
* A1 ^) P8 i8 {6 d' M! f--
& p2 e' e7 E6 j; ]' S# B6 U-- Definition of table `examtype`
$ r4 b6 K/ `4 S+ c7 `9 \--
, @) D# d; C7 ^6 n$ i& e: }8 g) U; Z( L t4 W5 O# J" ?/ w
DROP TABLE IF EXISTS `examtype`;1 m) t+ c) a3 ^2 Z. F2 _
CREATE TABLE `examtype` (
0 ?7 x/ `7 `# O6 s8 v `type_id` int(11) NOT NULL AUTO_INCREMENT,
6 F5 I2 ^$ d- A) A- Y `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 z! Z1 u9 s1 l
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3 u7 W1 |: i9 @9 m+ w6 X PRIMARY KEY (`type_id`)( b# J" T3 Q$ N% g
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;4 P/ W. _. a' j3 U# ]
6 \% y4 S: |3 z0 q Z( L) M/ K
--
- r7 W6 `; r) t0 t-- Dumping data for table `examtype`
1 u! A0 Q. U# J4 ~--1 ^+ V/ p4 \9 ]1 P! {% U
; F- x. l5 t6 V0 L/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
2 m# A( H* X0 uINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES / G/ R0 y" ? {/ h1 o
(1,'语文','6'),
4 ^% `- Y7 \) a/ y (2,'PHP','2011-10-26'),
9 ?! s; m4 J: s ~) t9 [) Y (3,'ORACLE','120');7 o( j! M. \3 J8 @( j# u3 ?1 u4 O
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;
) w* \0 h0 v, s! D9 ?5 U3 ]' ?
8 _9 X7 r0 |' N* a
; E: Q! f1 j- G5 F# U; J--& W% u8 q, Z$ f! p% X! u6 ?
-- Definition of table `question`
9 Y$ y& ~7 l; f7 P4 P--
* I+ n; z! Z. o4 ^8 _! X0 Q k% d1 y7 Z; [( Y' B" M* Q* A- G7 U
DROP TABLE IF EXISTS `question`;4 k! m' g* m+ K( J% k
CREATE TABLE `question` (
/ s' o, d- X9 k) k/ Z" `$ ] `qu_id` int(11) NOT NULL AUTO_INCREMENT,# h' _1 z) |! P; j
`type_id` int(11) NOT NULL,
: ?" @* n9 B6 J# @3 R" X! v+ _ `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 c* U+ Z: p7 F3 u; c6 [ `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,3 S, C* b1 z2 I5 `/ a/ b4 z
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,$ @ }; v, ]( y1 G! ] Q
`quScore` int(11) NOT NULL,8 K5 Y2 Q, ^* W' j% y$ z; S
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3 E# J$ c0 l3 t- N$ _: R `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,$ G2 S2 a+ p* t. m. T- Y* E
PRIMARY KEY (`qu_id`),
" T# h& G" y- C- H5 n KEY `FKBE5CA00621011593` (`type_id`),
1 a1 O* y8 v2 ~ KEY `FKBE5CA006B04D67C1` (`type_id`),
+ w) y4 C& F: } }- B3 u8 }* \" s! } CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
& _4 A7 ~, K5 W* M CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),. R9 v( o- }1 Z1 ~4 G
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)3 k# F. Q8 @4 V
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
) p# P% C. D L T' C' a& x1 H/ g
* z" \/ H) w# A7 J( T- Z1 Y--
5 s. [/ s9 u2 A3 U-- Dumping data for table `question`
! S3 m8 r6 Q' D$ R9 M0 y! d( K--! C% n8 S5 }( {/ E: b2 M
* h6 S8 Y. Q8 W* V+ X$ e
/*!40000 ALTER TABLE `question` DISABLE KEYS */;) @# q' l- Q: s* ]$ V7 m* T, m
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
( V/ [* V, _. y% ^9 k# i0 q7 U1 i! X. ? (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
1 c: o8 Y# N) a7 y: z) @/ d (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),, ^) A; \$ Q3 }- X; N( G
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
7 B) a" @4 W7 n6 X (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
9 f" U5 o% h% m7 C1 I$ K' E (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),- {9 j- Z+ Q' Y
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),2 \* N( w2 p0 m3 ` P% b
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
. c0 c: z4 T# C0 P (8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
% |* v* K. [7 W# w2 u (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),% R# S' e8 p( o) o% q& b5 P A* F
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
6 a1 w2 V3 R/ }1 Z, @ (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
, u- l K2 C) C9 _; B2 x% v0 k0 R (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
, {5 J/ {! ?- H1 i3 d; ^ (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),/ w9 s" o6 ]8 G7 H7 |- {. I
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');9 e( S2 `4 D N6 ]. V7 X
/*!40000 ALTER TABLE `question` ENABLE KEYS */;) z3 S( d3 C9 v" ^, W
$ ?- } B" \" E `2 K9 ^/ |1 k
% }, M; Q4 V4 w
--
\% |. P1 K( v; D; B' o-- Definition of table `student`
U W8 t6 u# R- g" ?--4 U9 h$ R4 o) D8 b
# e: ~5 n3 z4 r0 H
DROP TABLE IF EXISTS `student`;
$ x9 v" L, l# z0 J% C+ KCREATE TABLE `student` (
" t6 Q g" S$ ]8 x3 n% f `stu_id` int(11) NOT NULL AUTO_INCREMENT,( F# V+ E q4 {, k$ U6 r2 q
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 I( w) {/ I' Z2 x# G; r8 D/ S
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
/ i3 Z( K( `2 i: [ `className` varchar(255) COLLATE utf8_unicode_c
6 M' ]+ p/ }! b% n& {8 B6 v' l: @[Msg] Finished - Unsuccessfully |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
