|
该用户从未签到
|
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
$ c' ~' A( J4 o, b% g7 y--
8 h' c% M$ J6 }3 d8 c- x; j" R-- ---------------------------------------' at line 1- m" T3 k- S# q% [/ n. G6 L& V6 N
[Err] -- MySQL Administrator dump 1.4) D0 V2 k3 @# c
--
$ H" E. p0 x; q1 Y8 C# _-- ------------------------------------------------------
/ G! I1 C$ W; |) k% P-- Server version 5.5.15
& d; i0 ~. z/ L9 k& ]+ s; o- T& C0 v; a8 m+ i- S% X6 r4 P: v y5 a1 l7 c
r7 ^& o1 G, c% O' A/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
( \2 o, Y+ H5 [7 s( q/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;- D" V) n- D! B3 h7 b/ _
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
; a' m8 \4 Y8 f& O% I2 n; u/*!40101 SET NAMES utf8 */;1 F% b- g4 @7 Q& y
+ n2 I9 M# {( D$ o/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
% e+ |- ?% b2 r! j5 m4 Z" q6 P2 y/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;# b# m8 }4 t7 E8 G% j
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
; ?+ X$ b; ^1 S; p: q* J5 @- M2 X6 l/ q( b% j/ }9 I1 @4 \% L
; E8 p2 w, i4 b5 y& c+ Y
--
: r# c- P+ f1 H-- Create schema onlinexam! G/ h: T1 [# |% j
--
$ p0 D% m* [4 M% L$ b; i* {; w
CREATE DATABASE IF NOT EXISTS onlinexam;8 i4 ?0 T; _* d
USE onlinexam;
' s* @& H, p7 e L* y" s2 Q& w" q8 K; a5 k7 f) _
--* G k! V% d0 F
-- Definition of table `admin`: D k# `" N- X! `' B
--9 e; v, K1 @% x% Y9 \. y
# ?4 o& a0 y1 w# _9 Y( dDROP TABLE IF EXISTS `admin`;4 L- D2 L1 p. [: o: Y' m. u2 q
CREATE TABLE `admin` (: T+ `- k/ R" Z& j8 l
`adm_id` int(11) NOT NULL AUTO_INCREMENT,) m* @$ P$ M) l g! K: g5 @/ x* ]3 z
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) u! U) C) B' m& h3 X+ U3 K% y `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 C4 ?6 b* D# u- v$ p
PRIMARY KEY (`adm_id`)8 m4 x) i; d& a! F
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
$ h( p% m1 d3 ~ t1 c( s& f5 `, b) ~0 ?
--0 }! T# t' Y% H# W9 o2 e8 F
-- Dumping data for table `admin`
, [. `, l7 x+ Y) j' i--
[! b2 z$ j4 Z9 b# B" M1 u, H. j: ^1 U* F4 U; i8 L9 K' r
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
5 t' q' `4 G6 x4 XINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES 2 c+ E7 o; S% t- ]3 I# Y
(1,'admin','52itstyle');0 f# ^, Y D2 {7 C# h+ X
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;. a9 l' e7 B8 E+ g; I# U
8 D6 M* r, E' a* M# z3 u
/ j& n6 O1 V8 S# x--, e. t. |4 M) f0 K) S
-- Definition of table `examtype`1 J5 R. J. T: C( O! |5 i# u) t
--
Z6 L7 b2 n- }0 p) t0 {$ Y& ~" |# ?8 P
DROP TABLE IF EXISTS `examtype`;
$ @- k$ e( t" d( U: f7 \1 lCREATE TABLE `examtype` (
?7 [8 l; A [' @/ _6 U$ j1 C `type_id` int(11) NOT NULL AUTO_INCREMENT,
8 {1 F' I3 y8 g: L9 f `testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 X S2 z+ ?" ^/ U" H. J `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
, V* b/ i3 d8 l, D1 i PRIMARY KEY (`type_id`)1 z( o9 J8 ~3 y0 T9 V
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
' k1 A3 S5 g/ m1 W$ I+ K1 p8 Q* A; w9 M. V
--
4 g* X; B3 H A8 h7 H; X9 ?* ]-- Dumping data for table `examtype`# E8 A) a- T1 g$ s) g
--9 Z6 c* M' e1 O% r( }+ h
) A6 X, ~: }+ x0 m2 b& C/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
* K: v: V$ x3 {% q- L w1 W: BINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
! S. F6 }% Y4 ^. X (1,'语文','6'),, G, S% |. T( |* E9 e
(2,'PHP','2011-10-26'),
' s, I% U! ]8 ~* G B+ K" d (3,'ORACLE','120');
) [ s6 D) S8 ~8 D3 U7 d" W. q+ r/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;
* d6 w+ V- v' O: a! j9 K: L
. W& |$ d) F) I: }$ O9 t) k' _
0 f1 ^" y/ u4 i/ N4 t, _--7 O; @7 W5 u# ]# ~9 ?' W" _! r, u
-- Definition of table `question`$ G. R' `- Z- F" \" a, `
--0 V/ w0 I$ y6 C- F7 G# O$ F$ t
/ Q, Y: _2 f* V5 e n% }' s
DROP TABLE IF EXISTS `question`;
8 p; b0 s/ W a2 [CREATE TABLE `question` (& _9 D1 u. h/ f
`qu_id` int(11) NOT NULL AUTO_INCREMENT,
: \- h% e& h n, W3 P: h `type_id` int(11) NOT NULL,1 h9 n! S! a3 B2 Z' F! ^
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
$ d3 t3 w* V& {( C4 G `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
5 R$ M# r4 F2 b; P! r" m- T+ _* u `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,+ L/ e1 S5 A$ G \
`quScore` int(11) NOT NULL,8 A+ x. }1 j+ T: t8 Y5 o: X
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,5 [5 i P8 @2 v2 L! }
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,% @/ d6 ?! x4 s; b. \8 |
PRIMARY KEY (`qu_id`),
8 q$ h/ H9 ~* b- J KEY `FKBE5CA00621011593` (`type_id`),
! j, q- A& @& u: c/ A( r E2 c+ ^8 ] KEY `FKBE5CA006B04D67C1` (`type_id`),
4 |3 R4 I* x4 _ CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`), y( {: q6 }3 n
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
9 y1 t0 Q$ D* U1 |6 s CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
* W2 x. I) C: |) `) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;8 l0 ~5 `7 m7 y: ?% g# E
6 h# u9 S5 v* z4 r8 |
--8 P! {8 l- J5 ^# F
-- Dumping data for table `question`
1 A5 M* i# M, U--
0 P) N2 Z' K2 l/ u
5 y8 ?- b# G0 U5 N; x+ _' ~' p/*!40000 ALTER TABLE `question` DISABLE KEYS */;/ y3 G5 u- {5 P" K" o. ^7 U
INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
" b' F. ~1 g9 ~7 r: } (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
! y0 t" P; {, N( c (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'), f& x r' G( @3 B6 u
(3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
7 Y/ u; A% G/ [/ w9 }2 q (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
; B3 ~9 B! a' S$ | F (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
" t" R h+ `' z1 n (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
A7 h' ]( A+ H) d# Y (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),
3 S3 ? U) [" m7 @ (8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
8 Y! G- k+ x( }+ j, R6 H (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
+ m( U* F/ T8 e0 t4 u (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),2 K( ^/ D; R5 j
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),( X) s5 u, ?, f9 \6 D" V
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
" |) _/ S" V. {# ~ (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'), W0 T: V* K' K0 J
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');+ ?0 D3 {/ S; ?; l& P
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
! A: ^# a$ B- [5 T2 _4 ^& T" D$ T1 W. @" e
+ U: P2 W. G6 o$ n--
8 y' V% E) e }, Q: ^-- Definition of table `student`& G8 o ?( `) @7 p1 @# M
--
2 S1 b, K F# d9 o
% _% T/ G) K& d! k9 u$ N% c- ADROP TABLE IF EXISTS `student`;
+ V! j) s: }% d$ q+ u) D1 h! g6 @CREATE TABLE `student` (
! O# T. I& r( u" T1 a6 x `stu_id` int(11) NOT NULL AUTO_INCREMENT,
( ~8 X8 w. x* E `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,+ w0 A) k& z) j
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,3 N0 Z, n" h$ X
`className` varchar(255) COLLATE utf8_unicode_c" ?$ S5 Q( f) v T" |
[Msg] Finished - Unsuccessfully |
|
[复制链接]
|Archiver|手机版|小黑屋|科帮网-Java论坛、Java社区、JavaWeb毕业设计
( 鲁ICP备19004528号-2 ) 
窥视卡
雷达卡
显身卡
