|
该用户从未签到
|
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.42 {, \1 N1 B9 z p& W; Q
--
, g c7 X9 \4 O- g1 v. Q$ F3 I-- ---------------------------------------' at line 1 y! H0 _# N9 m6 w0 l; a2 G2 t
[Err] -- MySQL Administrator dump 1.4
8 k' \% s1 Y% D9 t3 G--
5 G/ Z0 z" j8 a6 z+ v( @-- ------------------------------------------------------
/ A; Q2 I$ h& U& ~/ m% \" A, E, F-- Server version 5.5.15) _1 C0 m! W5 l' a' V: S0 Q$ N
$ T5 ^8 R+ j/ k: {6 \4 s5 R6 q6 x, t. H5 I2 ~3 W- a* l
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;! ]0 V1 B5 ]; A2 d
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;4 k' h `/ ?# `+ [6 G5 Z2 w/ s* ?3 J& u
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; L4 h# \! M. b: `
/*!40101 SET NAMES utf8 */;4 _& l- e- M1 b, e- R w1 y
. a# Y3 U8 Q1 C @1 \4 v/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
4 j$ W; V8 v; D; N/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
* |5 B7 } r2 S9 M/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
F0 X! w' t9 _# C: }1 C4 d" Y8 L: Q$ S( Z2 [6 X- w7 _' w) |7 R
5 P" B/ h3 D$ w: j0 Q: r: ?& V/ t. a--
+ o' b" ]6 G( i# C-- Create schema onlinexam
/ h( }8 ?0 `, g/ x" N( ?: q# G6 ?8 T--+ s% g0 B0 [( B0 Z9 a
0 g) D8 \ a: J H" ~: a
CREATE DATABASE IF NOT EXISTS onlinexam;4 {& M& m9 K# f; ]$ R# i# z
USE onlinexam;
2 D2 W* @) y" `# ~- F
2 `' B7 ^) R% D3 [--
* _+ z6 f& C* ?-- Definition of table `admin`
& z/ V: ] M) @& q, X+ w" K--
; n$ [) j7 a' ^
1 f: n. |+ ]/ E" VDROP TABLE IF EXISTS `admin`;
2 O- F/ b% u5 o7 f& v8 T, u: D9 [CREATE TABLE `admin` (
) s7 k4 w+ m" T$ l* n/ L+ _4 q3 j5 \; G `adm_id` int(11) NOT NULL AUTO_INCREMENT,
3 t% v' ^* ^) o6 Z/ V `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,9 i- f' l! X3 y2 M4 j2 `1 W
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,- ?$ g8 j4 n O& W( ~4 [# N
PRIMARY KEY (`adm_id`)
3 T0 K5 a/ q3 `' h. t) O" r5 ]) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;2 E$ H. h" B1 Q9 X$ a
* ^. i: Z& o# k7 ^1 w
--
7 s7 g4 F7 M9 o1 T-- Dumping data for table `admin`0 \! a" A$ ^. Q8 K
--! S1 }' d" U- M" ?
?! F0 m* F% X4 D8 C) _& D
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
/ v9 P1 P* ?' C- e6 E2 dINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
) K% ^: S$ L" @" E: D2 T% I (1,'admin','52itstyle');
5 _' ~1 ~- u @1 @: |1 W i5 B/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
& X( _) ~" E+ R( W2 }5 u9 [
& C" q! q. @" S' Z4 X2 o& I( T
# t9 H3 }- [: Z--
) O2 A/ ~! {9 | D( l4 b+ K" R-- Definition of table `examtype`+ M6 \ T/ x* b5 K; L
--1 N* B) _0 S1 |- b, M( H
6 _; P: a5 p& n7 p: W
DROP TABLE IF EXISTS `examtype`;5 p& P8 w. _# W, l7 x5 D, @# t, E2 A
CREATE TABLE `examtype` (7 U( a4 {9 J0 E7 Y0 U; q2 W
`type_id` int(11) NOT NULL AUTO_INCREMENT,
) M0 E# K3 ^" L( B `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
@1 r) ^3 t' }# J) l `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,5 ]( x; h! }- [3 G: c, X" s+ N
PRIMARY KEY (`type_id`)3 i" a5 n& j, u: c( H/ A# I
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;! ]6 @9 B9 M$ W1 {
7 G2 V* F- y" W; ]0 E. x$ X--
) @% T/ e1 x$ Q5 |8 k# w-- Dumping data for table `examtype`5 H: v( m x, z7 f; Y+ I$ S
--
* m, a* q% ?4 l4 N8 }+ A/ z8 n; P; o+ ]2 J; q$ K& Y
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;( y9 Q& \# G" J6 M$ t" G
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
3 Y/ K5 U& N: ?6 z (1,'语文','6'),
- ?/ n" O y1 y! j9 F S& j (2,'PHP','2011-10-26'),5 U$ k& }3 a8 P3 V- Q/ x5 s( Q) i
(3,'ORACLE','120');4 f( N, [' ~$ a0 G
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;# B7 A& G0 N# ~0 x
c* V" l9 g* d! g+ ~! X4 q7 t, Z8 C
6 \8 o0 @" D/ D# l& ^; _) }--( Z$ ^3 x2 H& y5 B' W' j. O
-- Definition of table `question`1 a; F/ O# G Y6 }+ a; r
--3 z( a2 x4 S$ Q6 e: J' V4 W+ v3 s
/ k" Z! }. e8 R1 a( M9 `, qDROP TABLE IF EXISTS `question`;: Q# R; f9 F3 o% j. P, V
CREATE TABLE `question` (& P* g5 J; J2 u: }9 l
`qu_id` int(11) NOT NULL AUTO_INCREMENT,8 l a2 o$ T0 ^0 R( p
`type_id` int(11) NOT NULL,
4 W' _ i' s1 E' e5 h8 _" S$ v `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
. W0 M& g0 e# i3 }0 t7 h! q5 Q `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,/ J0 |& e; {: n) g+ C% f1 f; @! N
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
* K2 N8 k$ F, O3 Q, F. R `quScore` int(11) NOT NULL,& h, J$ l0 d# n# E0 P* a
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) k+ E+ K: D, ~5 K2 l- S& [ `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 Q/ x) D$ B2 e# I3 c PRIMARY KEY (`qu_id`),
$ x$ v v6 s1 n$ B, Q& {7 U' } KEY `FKBE5CA00621011593` (`type_id`),
( F# b2 `7 p( ?) o. E, v KEY `FKBE5CA006B04D67C1` (`type_id`),
$ l0 P G4 _7 m CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
0 R" G- s& r0 Z6 `) R; R CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),' ` O, m9 |' b* }6 U
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
! }& D2 s7 {9 `& N4 H3 B) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;2 e* \+ G, A6 D* h* H- M# R
( J* S8 \6 G- c# H8 V--/ N( k0 j4 s0 S0 ?2 w7 _" G
-- Dumping data for table `question` c4 e6 Q) f) y& J& F2 V$ u$ U
--
8 e) s" D; x; [; I! k8 \: [4 E
' O; i* @5 ~7 { G0 p/*!40000 ALTER TABLE `question` DISABLE KEYS */;' s4 L$ N. ?1 ~9 y, E% i% |* v4 J6 f
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
, h7 Y7 e7 M: [' X! a (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),8 ]* R; M/ {5 T# u! r% s6 _
(2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
' K5 \! q/ c5 f: r0 s% w (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),+ B2 u" ~" K2 h3 Z9 j2 W& ~ W
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1')," R# G( b% i2 {) g
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),3 y7 ^* D4 E+ Y# j5 r _
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
3 n j. X* w' S8 Q% Y/ f) Z (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),- A, ^* T) M$ p; w
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
, |6 P( h$ i/ K5 x (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),4 K, `% r9 q) I6 g( T
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),* a% |( i5 O& N. e- T2 s* d
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),! ~% K" f9 _1 E8 z# g
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),: f) i3 C3 G& F1 }" N4 y; N
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),9 L7 s7 h0 n. p8 Q) s% D
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
- C% k+ x, }6 v7 x8 T3 J/*!40000 ALTER TABLE `question` ENABLE KEYS */;1 G% i: R, Z: W4 A
; ?& g$ M' K" z6 U# L5 y" d8 w6 s9 o3 Q
--
0 j% q/ e9 U1 `1 ^8 _3 H8 t4 l7 `$ Y-- Definition of table `student`
0 z+ K3 N1 ]7 a2 {/ X( Q--9 u3 q- U2 A2 j* e
: R& t2 g, e3 eDROP TABLE IF EXISTS `student`;
4 A2 {4 F `' J; _6 d& R4 }/ BCREATE TABLE `student` (
6 ~! c( [7 N! _2 ?2 N; Z& v `stu_id` int(11) NOT NULL AUTO_INCREMENT," B4 x6 I& k c$ V) Q
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,! z2 z" \% V) a# t
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
, W T9 n* q. y4 Y4 v `className` varchar(255) COLLATE utf8_unicode_c+ l, U& J4 ^* L# b6 c
[Msg] Finished - Unsuccessfully |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
