|
该用户从未签到
|
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.49 ?% w- H& ^+ x- P9 `% d. n* o7 k
--
3 G$ Z/ x% C" M7 ?8 ]3 J5 [-- ---------------------------------------' at line 1
8 P) `2 s0 j1 x; H4 J[Err] -- MySQL Administrator dump 1.4% w7 t2 H5 K1 L7 \" A
--! c" N' J9 d& N9 |
-- ------------------------------------------------------$ A' ^$ g6 U5 }5 c/ K. v
-- Server version 5.5.15
) I( G* V& s% B" d# ~6 R9 |: X) d% W" N
1 p6 ~) o: m1 y
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
# D2 K6 Q% Y3 v$ M, q C: i* P+ G/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;% T' O& r+ [ `$ R4 F3 r- w
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# _. R1 i+ _3 K: s r4 P8 u
/*!40101 SET NAMES utf8 */;
4 f7 S! Z2 m0 z' f% ^+ K
* T: u9 o1 x! G* T5 h/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;( e. r& d+ l# O' M+ x! v; l
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
! `) R" q$ r; h9 j2 y/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;. _$ P% V6 V* C& N4 j
# l% i. ~( n3 S8 J' [+ g0 K) j
; w' Z0 v5 t* I( M5 u* ^
--
$ u" q0 S& n; c# g! a-- Create schema onlinexam
2 V/ K# W% B7 S; Q! K9 ~--3 ~- ~4 s3 b: a. @. ]3 B
' p- Q1 X: I% J4 W0 H
CREATE DATABASE IF NOT EXISTS onlinexam;9 _5 t+ O* b4 L0 y
USE onlinexam;
( }: J$ q% o# ]2 d% r' ?1 N6 d4 e( x: q7 L1 \7 B* w$ T
--. J8 A @7 f a6 r$ L
-- Definition of table `admin`1 K8 q( W+ R1 w/ G S
--' u/ L2 Z6 x1 [+ ^
5 h: `! S* I3 I
DROP TABLE IF EXISTS `admin`;* N" l5 X5 a4 S
CREATE TABLE `admin` (4 Q- l8 ]$ J: _% W7 t/ O& ^
`adm_id` int(11) NOT NULL AUTO_INCREMENT,/ [( s9 L( A9 U9 j# _ A. b
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
$ t* |1 m4 G: M% H- ] `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 ]% ^: D+ l( g7 B; p/ I PRIMARY KEY (`adm_id`)1 `3 z9 A) @; b. O3 Q
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
: K: z0 ?" Y% b$ S- F) T/ S$ `' }" b1 g- I3 {2 ^
--
+ {3 ^' Z2 d7 T2 D-- Dumping data for table `admin`
, E5 e2 d( r1 e+ t; U2 N--
# n+ b' F% i' b2 f0 i: v! Q- n
7 N0 l3 u9 W% t. N: y/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
3 D. D7 \4 P6 b$ O1 IINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES - k$ q) C5 \' d" j3 S
(1,'admin','52itstyle');
7 C" I* \3 W% U+ U/ E K/*!40000 ALTER TABLE `admin` ENABLE KEYS */;$ e4 F7 g- t$ D( T' b, I
8 ?# p% o- I& S7 [: i6 \2 o0 M; Z/ ?( g1 R4 L2 h# }
--
L4 |( ?3 e" D' P4 b-- Definition of table `examtype`
& K1 W; f% o- s( j) ?; i-- N! v8 o5 X' q- j; T3 \! `8 y
, T( l! F3 K( z) j8 D; s- I) M% |* SDROP TABLE IF EXISTS `examtype`;; ?& u4 z8 L0 y# H
CREATE TABLE `examtype` (5 D; q* I- @6 M3 N! _
`type_id` int(11) NOT NULL AUTO_INCREMENT,
3 Z( J0 R! e0 h$ [& j- Y `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,! b Y$ A* z5 X( f
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL, C6 _& V' a; d8 R' H8 \6 z9 Z7 s
PRIMARY KEY (`type_id`). b; Y) C& r0 c9 H4 }1 X* r! c
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;' x& l, {0 ?1 M1 u4 a
+ C! }/ d& W. F& Q7 e3 R--# Y+ m2 X$ R/ ^% ?! m
-- Dumping data for table `examtype`
$ r* ^0 \* N0 \$ V- I3 t: E--
- G1 I- s! A8 e9 V: w1 E8 A3 ^) Y7 S3 r2 s1 m
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
/ v1 H" y8 J: n$ l" h4 ?: k5 A1 N* WINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
2 i. J, \9 l) L& a4 n* j4 W$ I (1,'语文','6'),
) t8 Y5 w2 Z6 H0 U' x (2,'PHP','2011-10-26'),
! h) L; L, d9 ~! [# R1 t" D( Y7 x; Y X (3,'ORACLE','120');
% _/ [' }9 Z2 J9 b) r/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;% v) c5 W/ q, v8 R% _4 ^
9 H( _; O8 J0 H5 y2 G! F) o& Y0 o( l
; Q$ a. O' j" U% V8 z& s- y--+ M3 m3 y! k9 {/ Q% I
-- Definition of table `question`
3 X, J3 N& @5 y: k7 B. T--; p# s8 T& h8 M; k& E; S
: B/ }) N0 ~% k" E" S9 Y8 _+ l( UDROP TABLE IF EXISTS `question`;
* ?2 H+ ~7 I- w" ^1 X+ oCREATE TABLE `question` (
# }" c( M0 V; \. \! a# Q `qu_id` int(11) NOT NULL AUTO_INCREMENT,' g9 L) ]+ B! x7 r. n. r% ]
`type_id` int(11) NOT NULL,
1 \' k' f/ ]9 ]2 j& H `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ A7 r$ V5 P7 U5 Y `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) g: T0 O' W4 {& {' T `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
* m4 z6 F$ R0 h/ j `quScore` int(11) NOT NULL,+ _. R5 ^: [$ U: ~- L* `
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,4 ~ O5 D# S$ _' t
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3 k8 j1 y6 k+ H2 ?6 [ PRIMARY KEY (`qu_id`),
; p: a) J6 u }2 r B. Z KEY `FKBE5CA00621011593` (`type_id`),- _$ n1 E/ F7 g+ i$ R& X
KEY `FKBE5CA006B04D67C1` (`type_id`)," K1 Y/ ]5 K! l% V* V
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),2 j4 R) _+ S$ C7 G& _
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),) u1 B. q9 P {6 }* h* r. S% R
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)! V7 O# S j8 Q
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
% s* @" w0 J. ~; `' }5 A1 ~# Z9 ^ G7 C( M
--" b( a+ t8 m( Q' V; y3 L
-- Dumping data for table `question`: Q1 q# Q8 s# l
--
7 M9 S4 }. }' \$ p4 F6 z; y* \; ~8 G3 x3 k+ G) F1 `+ J
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
- c; e4 R }% L/ z) R" f- c# xINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
5 h, z* M& X7 U7 D: _4 u (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
( Y; ]! H# B, p3 i1 \ (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'), N. ~5 O) U/ _0 C1 v5 x9 d
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
* @% Q/ }* f/ C% V3 c (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
3 B4 ~& I, G) S/ }3 N6 ~( l1 ?; S (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
8 \; |4 S) @! s/ g1 ?0 u (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),* k/ L0 k' ~; A* X* P/ c0 i% Z
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),. p, O8 D: L+ o6 q$ g
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),6 |# q# J: W3 m A, B0 ~" A
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
! H) v( t: O1 U! ?3 ~# \) A (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),: s0 ~) u7 ~3 ^9 v1 b
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),$ P% w3 F& W9 o# ~' o* k# q; j# l! [
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
1 @8 | Q l! w (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),* A4 i9 L; H" m
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
* ~. O- S Y3 G* ?6 D0 n/*!40000 ALTER TABLE `question` ENABLE KEYS */;
+ ~3 L4 a& B9 [0 v
* T! p. r0 X( j7 ` ?; d6 G$ V9 o/ v
-- X# D8 R3 Y% H# J
-- Definition of table `student`
+ P+ x( _; T7 T& k! R--
" t1 s h) M9 o0 V
2 I5 V8 P- t2 {+ YDROP TABLE IF EXISTS `student`;7 g8 |, S% l' D9 a9 X- o2 C
CREATE TABLE `student` (. W1 C$ u k; ?: u. U5 C- X
`stu_id` int(11) NOT NULL AUTO_INCREMENT,5 y+ i3 @1 x" I0 T$ q
`stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,$ B5 n8 I+ R) t8 U5 R9 S
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2 S4 J; p! D+ v5 F" `/ [; i `className` varchar(255) COLLATE utf8_unicode_c
5 d) N9 r$ ]% O4 W7 ~[Msg] Finished - Unsuccessfully |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
