该用户从未签到
|
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 b' d# s. t, |4 r8 \/ m
--
8 M. {( d$ X0 d; w7 w# W. ^4 v: e-- ---------------------------------------' at line 1+ c* |4 {* `1 M P& o* h
[Err] -- MySQL Administrator dump 1.4
5 s) M/ o: I7 H--4 c0 _) u6 X( w( m$ W- ^+ v9 k
-- ------------------------------------------------------
2 b. u; A; c& ^6 Y5 S7 ~-- Server version 5.5.15
" T) I" l$ o" S5 i1 @
+ R$ U0 s, o# c) N! ~0 c s% D5 s2 x- d, Z
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
! s. K1 g! ~/ c! u$ R# F/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; N, ~$ `! v4 b- B8 S
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
; @# J9 m0 o0 @8 Q2 C2 e% y1 r/*!40101 SET NAMES utf8 */;) x p5 _; o- ]% u M
! |" A9 f% _. a; }$ ~5 `8 L! @/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;3 d K+ Y3 T) c" {; V2 P! ^
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
; V7 s4 l* ]* r$ u5 B2 h5 P/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;0 o' X" y0 Z r* z1 k+ m
. l( m- O! y1 g L: p6 ~
4 i3 X* f1 l8 R--
! z4 I. _ ]2 v( Q3 }2 L' R-- Create schema onlinexam' W/ x' _; q0 e3 L( b3 ^( c
-- P9 ^) i3 @0 |. ~1 e) ^
# M* ]9 h8 b! H6 I* H7 j& T$ v
CREATE DATABASE IF NOT EXISTS onlinexam;4 {/ c- }6 s3 f) o, V! p( `
USE onlinexam;
/ }$ ^) @* J# }) U y/ G6 u( }* X' v4 |9 M- i5 ^
--
' D$ m( }: U) T9 e- i) z, [. m* a& @-- Definition of table `admin`
, F7 {! S. i8 s- G--
1 m8 f7 n' u. X! M* m8 d( u# A4 a! b, `! Y- y G/ y
DROP TABLE IF EXISTS `admin`;
! p" v8 L- y3 I a. z; B: c, zCREATE TABLE `admin` (
3 }) ?' t( H! d `. ~& G2 p `adm_id` int(11) NOT NULL AUTO_INCREMENT,1 Q- H) G& s5 U8 N7 x
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,5 H/ g5 h% P0 A
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,$ `; b! f' ~- H" k- P) h" w
PRIMARY KEY (`adm_id`)$ z/ h! v. B9 ]* @; k
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
' r" i3 e8 `. {9 c
, e. W4 n% l! X; u' x- r--
; D; R: g: M. O4 X. T" {-- Dumping data for table `admin`
3 |5 w7 _& i* I/ U--7 i M6 P5 W, s4 B: E
- W5 a3 }5 r: ]4 {
/*!40000 ALTER TABLE `admin` DISABLE KEYS */; u2 L' ~3 d5 g8 a# j
INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
6 ?- |- t1 Z C9 ] (1,'admin','52itstyle');
3 l8 B0 ?8 q% [9 S% a$ S$ x! ~. f/*!40000 ALTER TABLE `admin` ENABLE KEYS */;3 L" x7 ]" Q+ E" K' ]1 b
0 N. E: j. B2 d8 N x% x
) Q9 |/ ~/ P* J! e
--& Z ]/ J) D; w% m: z. M, D. W
-- Definition of table `examtype`
- H8 c5 M8 ]3 J& k! ?& s--
5 `: W) A, @4 d: Z
' i! } Y! J; M* {$ iDROP TABLE IF EXISTS `examtype`;
( q/ N, u1 s$ f P3 c! v3 ?; ECREATE TABLE `examtype` (* J% w0 y, G# F# [) j
`type_id` int(11) NOT NULL AUTO_INCREMENT,
/ n. i" Q. C3 A B0 [ `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ H! J9 o4 o) T( ^/ u/ x `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
$ u7 J! W. |: R9 J PRIMARY KEY (`type_id`)
8 m0 \. R+ d o2 X) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;4 h9 y7 G H) e, X7 f" z( b
4 `- \. U) R2 V! T! J--0 {( {6 W/ c1 [; P& P
-- Dumping data for table `examtype`( [& z% j& R* u& \+ e* l2 w
--
) l V# D0 J3 O3 e
6 o! W" E. i" p( \$ F1 k4 i% |/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;& O0 V s3 k K z6 z( V, v1 H
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES ; i% B+ U" f/ F8 g$ F3 |# q2 _
(1,'语文','6'),
& e. ^* ~/ A- ~% N) r (2,'PHP','2011-10-26'),
/ E. F1 N; d# k' x9 h (3,'ORACLE','120');
; m& Q3 A8 n2 B' C% z: l, f8 M; r/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;6 z9 K8 x; o2 t
9 Q: x( C" V* k V3 t3 ^' k! ^
" P( Y5 U; E z: b--
- X) g7 Z" R; F9 ^$ i2 I8 g-- Definition of table `question`& |- |- s' ]. d
--
: P* u+ O( \6 R3 l4 M% }# p: o4 Q) ]
DROP TABLE IF EXISTS `question`;" t2 \1 h) a d: b; V6 N
CREATE TABLE `question` (; N( U6 Q0 q7 ~9 [5 i( g" r
`qu_id` int(11) NOT NULL AUTO_INCREMENT,# U: f# q& v6 ]% X% @
`type_id` int(11) NOT NULL,
$ k- Q7 D$ w4 c3 O7 k `quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,1 K" s! ]- |- n2 w6 c w+ u
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,& f5 A: ?. {$ S0 L
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
( z. Q0 T, E0 t& V* p# L `quScore` int(11) NOT NULL,' d' ^0 q7 z+ H: T8 Q
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
' T+ D* `$ U) A' Y8 j- S9 v `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
0 i7 I1 N1 i( V0 A$ K PRIMARY KEY (`qu_id`),
* R5 t% B. T$ D A0 G k) d0 j KEY `FKBE5CA00621011593` (`type_id`),) b2 m3 p+ n n5 k* d, ?) [
KEY `FKBE5CA006B04D67C1` (`type_id`),+ L9 S' e- E7 u3 f( J$ d6 ^3 n9 i
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),3 O; t1 q4 ~+ y2 D8 e
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),8 [7 w1 s4 M5 { S
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)# P+ d7 J" q; k) q# W* b% A' h
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;* O! q: G* q- n, L$ ~3 ?7 k
3 O3 h) T c( m1 Z% d9 w--8 y$ A6 D' k6 @; I7 c
-- Dumping data for table `question`
; T5 A% v& T8 l$ K& j--
! p& x% B8 k/ X4 D9 g$ m+ b0 {; }% [$ ]. M1 G+ d
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
- a2 C3 L6 y, s) P' x* H" CINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
* _0 C5 v8 V+ a, _) y (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
2 m2 L. A( n5 t( H (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),. t% u" y% K3 O \
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),, ?. s) G3 k2 R; [) k; h. l
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
# `& B( O' ]0 q9 {5 Y (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),7 l5 ` J- n/ j, K& B& l
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),9 j2 U& C) D: a2 V7 I& ]9 L
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
, z" s% d+ P, \" e2 Q" f (8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),, a9 z; c6 I, b- B0 N* K
(9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),1 p6 s; c% q' F# X: g
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
9 h3 \$ ?5 U3 S (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),5 q1 p" y0 E) N& _ |$ s; g
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),0 W/ a/ \, a$ R
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
5 B! U) ]2 q) ^! A. X6 g (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');
2 T- R, f4 `2 |1 @4 j" ^7 a; b/*!40000 ALTER TABLE `question` ENABLE KEYS */;
" M# W( x! t, U1 N6 l; j1 A8 g7 M% w. t. }
x0 w: ?! M( e1 l9 V! R' ~-- d2 d: z0 O4 y _9 B
-- Definition of table `student`
, a+ n; Y/ |% v8 I--
# b& ~6 U, o6 q4 \
1 g: g, O: b; t% M. c9 U/ {$ h- bDROP TABLE IF EXISTS `student`;0 |* y( ]6 n: t$ G
CREATE TABLE `student` (
6 X) X. G1 W& O1 R' L* V6 h/ r `stu_id` int(11) NOT NULL AUTO_INCREMENT,
! v1 a" a" V/ n2 c8 M! P `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
3 @+ T9 q$ L- L9 d2 g8 ^ `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
. P/ A0 B/ m" t3 X! c `className` varchar(255) COLLATE utf8_unicode_c. H {3 ]$ W! M$ Y2 `* |
[Msg] Finished - Unsuccessfully |
|