该用户从未签到
|
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.48 j* S$ \9 s4 Q" d8 O
-- `5 h8 o, l9 V0 h( L1 F
-- ---------------------------------------' at line 1
5 X4 @" L" G/ x[Err] -- MySQL Administrator dump 1.4
/ Q; Q, k' F3 E3 F9 I5 {--- e7 X; e# c0 ~
-- ------------------------------------------------------
, }6 h( B5 R6 P5 U* X( p/ J-- Server version 5.5.150 Q2 M/ P( h" h ?
& E" S' p5 R M3 o3 ~" Q
?0 R+ F9 |- _3 C& t- U5 `2 S/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;+ L" O( F B2 I8 E3 ]3 q7 f
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
% a g" O. O2 i4 l: ?# X8 e8 t% J7 C/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;9 D4 G: Q; |! _: j) _" G5 S" p& Y
/*!40101 SET NAMES utf8 */;6 X J9 ?1 }! L4 i2 t# `: S
" J( H) h% H8 v3 {
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
M$ F# F' k) ^2 _( J- H: ~& H/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
# R% z8 } P* }+ V/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
8 ~* u9 J9 c" Y/ I/ p2 c e) o* s6 X; z/ z4 M1 ]
5 f% H# I6 U1 w4 q- x8 W+ T7 G1 |--
7 f C5 F: d; x, a-- Create schema onlinexam8 m2 N* Q1 R% E5 C. s. s
--0 I$ A: w) Q; K# y! g
* I7 ]+ N _9 `
CREATE DATABASE IF NOT EXISTS onlinexam;
6 N, F: N+ i7 x# \' {$ X9 N9 lUSE onlinexam;
! }7 f. J5 U& h
8 P' B0 P y( F( L7 o# A--& w- u: x8 d" Q1 h0 @9 [- p3 Q& U
-- Definition of table `admin`' j/ b K: `. _* H! C) g& ?
--$ J/ h3 J3 d) F" h, w
- x, j# u+ e. ~) oDROP TABLE IF EXISTS `admin`;
. U* c/ G' N! B$ FCREATE TABLE `admin` (
- L6 \' X! e/ A& ~ `adm_id` int(11) NOT NULL AUTO_INCREMENT,# y8 }) p9 i. o8 p, L+ K
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,' w2 s( w* B; k0 y, E) b
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
' v l5 Y( n' e% ~: t. H, O PRIMARY KEY (`adm_id`)
2 i+ s9 p$ C: e( e- @) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
& m3 k- F, X% D; R( m" y+ d" ]1 B5 \ g d: M! Q
--+ j2 c; p0 k; \* }/ U. t( j
-- Dumping data for table `admin`! Q/ {: Y* `/ |: r& Z: F
--6 g5 |3 {2 H& e0 a; O
' g& Y9 d# N6 u2 U. E2 D5 c2 h/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
d9 ` {: b: b: BINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
+ f5 l2 a2 @$ g H3 S( J (1,'admin','52itstyle');
2 C/ e7 D; V) B2 k* I- m/ u8 A, D9 @/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
1 S, Y6 n; X$ l d. d3 g0 w) x6 R- G$ w) C* V4 H( a, \
5 Q U _8 x& u--
- R) V$ V$ T$ F3 {( C* w-- Definition of table `examtype`+ L! [! S# c8 F, o( G
--* }3 J( C5 U [. k C
. Y3 G' k+ d0 I* _3 z; dDROP TABLE IF EXISTS `examtype`;7 S- W. ~- K5 Y) P. G' P
CREATE TABLE `examtype` (* S/ C( ^$ h) [9 ~$ @7 e
`type_id` int(11) NOT NULL AUTO_INCREMENT, p H6 M* o/ D- g. E o) k K) F
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,% g2 H% t! j2 f& X1 ?
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; B6 p8 }% c+ l9 v4 i: b PRIMARY KEY (`type_id`)7 e6 P2 S$ B1 \5 G z
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
$ W# I+ g! Y9 Y) j, e/ G, g# m& c" o2 w7 O x% i; Y- J v" \
--
& ^: L0 E+ @# u6 A-- Dumping data for table `examtype`
& F' ^( y* s- u) }- X) |--5 E3 F4 {' b. V1 \9 n( F4 g" y
2 T7 I1 G# u1 T. T& T
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;% ?4 i: {* V: O4 q% T* j
INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES 0 M, R/ N" i' M" e8 j
(1,'语文','6'),
. G8 E+ G* m8 [ (2,'PHP','2011-10-26'),* t) L4 [6 @' o# X0 @4 ?
(3,'ORACLE','120');
8 R4 l3 M/ T& X2 d/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;7 `+ S1 c/ X/ {# i6 {
/ D) H- c& d; ~5 ?& o; w( P
. N/ }; y' v$ q( E& R3 e5 ~4 s
--) C0 d" o- o8 Y; K/ L9 o: }( h L
-- Definition of table `question`
1 U4 R/ `, B- J! m m--
+ ?8 {4 D' U) Q; h& W k# ~% j" r- z/ y( J2 D2 [( A9 R
DROP TABLE IF EXISTS `question`;9 r, t: `5 C/ s. R* K
CREATE TABLE `question` (; S1 N4 S, f5 t T X
`qu_id` int(11) NOT NULL AUTO_INCREMENT," Y6 l$ O% I" u0 p: C) L
`type_id` int(11) NOT NULL,: o `8 I4 T j6 [# P7 l
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
0 ]- T9 z( s+ v+ C4 q; Z1 Y( O `quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
# a0 p0 T# F' _$ }( M `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,, U* z5 ?5 i5 N* H r* H0 A/ z, V2 o# Q
`quScore` int(11) NOT NULL,
0 ^! I8 f+ w7 m& D( M `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,2 b8 h4 q5 \! o( b
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,' o7 t# w+ }; u- R# R
PRIMARY KEY (`qu_id`),
6 N* v$ T* H( Q; }# m/ b KEY `FKBE5CA00621011593` (`type_id`),# K5 \, }# @' v+ u
KEY `FKBE5CA006B04D67C1` (`type_id`),
) y' q5 q* l9 O9 Z0 Q! W0 ^+ L CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),, V/ ~4 r0 Y5 W4 [2 H$ V
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),7 j" u, h# e' j. |1 \8 q [0 {
CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)6 ?4 Y; y6 x- ]8 X( v# |+ \
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;: M' C, B+ J0 ? T% Q
" t+ ^1 d$ Y0 |--& }& K- k6 y5 u* ?
-- Dumping data for table `question`3 D+ V' ]$ J8 Z% g
--3 k+ i9 l" z+ o0 B" ]1 _3 r
4 [# } u( O, u0 ^/ L3 z& n
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
- g' M& N8 ]* k6 h6 _INSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES
* ?$ l W7 k7 E% T4 p0 d (1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
" N! f& R; a: N. R- a; q8 m5 m (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
4 L4 y$ a; u* t (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
- c; ~8 O- h7 ?( p7 A (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),4 V9 r8 s6 k9 l7 E4 H+ S1 v- S
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),: w- a, [. g* J4 S ]. [
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
4 f: H% g% u2 f! u+ s (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),. |: N1 c' ]0 o, U- w# E! i
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
6 z3 ?& o$ ?( Q" z3 @3 P% y0 F (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),
2 {3 D( }! ~* c5 l0 p0 i) g2 F (10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),$ p, d" s1 q9 E! V* j
(11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
r9 \1 y9 D5 C& p7 H5 \ (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),
: [) J: _7 s) x: z (13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),( O' Z5 r* e: Y! B p6 e
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');# k; A% i X, v
/*!40000 ALTER TABLE `question` ENABLE KEYS */;5 l) H; k _; L% t7 W
" | u4 ~: R; a Q% k' M
! }* P+ x3 B5 h* C. h--
0 L/ q; m" a6 l% o, V5 }. B-- Definition of table `student`
( V" c/ _( K' q# a- ]' Q--) P5 x% W& A/ `; N( Y
4 G& T4 n) e$ t
DROP TABLE IF EXISTS `student`;
# m6 f" M' f# GCREATE TABLE `student` (
2 u" H/ _8 k5 ?9 e5 F2 }( \0 V( P' ? `stu_id` int(11) NOT NULL AUTO_INCREMENT,
4 f Q' Z$ X5 g9 V `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,3 }. m/ \- L2 {
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,9 o9 i9 [9 x6 P9 t1 Z# F
`className` varchar(255) COLLATE utf8_unicode_c
! ~9 m' |( E4 J8 ^7 d1 q0 G% l" F[Msg] Finished - Unsuccessfully |
|