|
该用户从未签到
|
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( Y& l* q; }& x6 ?! ?
--
( D, Y# h0 x- W8 V9 m! w+ V( D-- ---------------------------------------' at line 1
5 H) B6 B) ^2 N[Err] -- MySQL Administrator dump 1.40 x0 A% s+ e5 e( u4 T3 _/ V
--
- e H/ e7 J$ Z' T2 o6 p' I5 f-- ------------------------------------------------------+ \$ ^1 ^ a% s' V- n/ }' K
-- Server version 5.5.15
# z5 O4 y% \2 M# ]5 v& ~
& z7 `# q: ?# o5 G, b) O" G5 d( `3 U3 r" ^! P# ]. H9 F: ]
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;& p1 Z: b3 R: a8 [
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
$ t* O/ q' [8 I0 X3 u! k5 x/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
' h x) Z% B, Y5 g L; ?- z/*!40101 SET NAMES utf8 */;7 Z4 |' C5 D# T* R/ `
8 ]: d# W) ?. f5 P
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
0 C2 I" Z+ O0 E* S( C/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
! H3 Z2 g2 {8 x3 S' v5 N n% Q/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;' U0 a4 v9 g" b( u! _ [
' ]# |0 ?6 A; ?
6 X# o5 O, s9 | n, ~1 Z( |: _--$ F& e& |, i& }
-- Create schema onlinexam
" ^% x7 X4 b* @7 i1 Y6 r- u* J--
4 G! h4 C' N, G6 c& V% t; }& k4 E1 Q1 ?: B, [# J
CREATE DATABASE IF NOT EXISTS onlinexam;9 I+ n1 W1 N. O; n8 ^
USE onlinexam;) E2 D9 g) Q7 F+ k$ A7 B; ]
7 Q. r& W( w; T, N
--
: @' ^0 ?4 f, D1 k) T0 L# [8 L5 U-- Definition of table `admin`
6 a' _* a* M! J. O& ^1 G--5 J/ D2 A) ^# U1 _ q3 v
2 J# n4 v5 V% c9 l3 K& L& LDROP TABLE IF EXISTS `admin`;
: K& ]9 z3 w! DCREATE TABLE `admin` (
4 P) m0 U- q3 A9 _ `adm_id` int(11) NOT NULL AUTO_INCREMENT,. f9 D5 A& g1 k1 p
`admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
% J* h, ~& q+ ~9 C1 L5 k2 g9 v! @ `admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,7 G U8 ~6 Y2 F7 O, [! V
PRIMARY KEY (`adm_id`)
) W; [. z6 |. {$ [5 c: ~) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3 g& u. U+ @8 ]; U1 I6 j
7 O( ]( c) a; q/ l; B--
: b9 S& a+ p: b# E" J: X0 [: @& U-- Dumping data for table `admin`
y8 d5 R1 p' \' b7 `--0 t; L% V0 G; N" W2 s* |
2 D/ j- ]: w: @$ `" m
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
: }7 S7 @. e% a$ {# ^INSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES
! I# |4 U; ^9 q% e! \4 d (1,'admin','52itstyle');7 H( f6 M3 J' A; H% l) I
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
, R# R: X2 F' `4 z L4 O- ^/ A: C6 y3 I
1 K* }3 }7 B9 j% J5 D. v
--
. O" b: {& T9 |/ D9 K$ g-- Definition of table `examtype`/ o2 V/ x5 {: Y% s9 d4 }
--2 A& k; B3 f3 Y- J$ u$ t: \
: O5 U @* n0 h6 [- @/ [- gDROP TABLE IF EXISTS `examtype`;! n- q/ X7 i$ \
CREATE TABLE `examtype` (. l% Z# v* K3 _2 l
`type_id` int(11) NOT NULL AUTO_INCREMENT,! b# b+ R3 m# z. H9 s5 p+ ^
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1 Z% Z. `" K* u$ ] `testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
j! C+ ]5 P+ a U' n. J8 L PRIMARY KEY (`type_id`)1 F7 h# j% F( ?$ c0 D& O6 T
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- ?% O/ ?. k0 c/ @/ U) u4 c8 k4 K! T
--9 j& s; M& x; ]4 E8 v- v* u" N7 y
-- Dumping data for table `examtype`
4 d6 B, y$ D: x; \--! {, z% \! c- n* D3 l8 J6 Q: ^
* |5 M* I E& r& e9 A
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
2 P/ I6 S: b% j v7 a% rINSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES
7 y, Z2 t: y, I2 D0 A, K (1,'语文','6')," M3 l/ {2 @; \8 ?, V
(2,'PHP','2011-10-26'),3 Q, A+ w7 `$ q' K2 U: |
(3,'ORACLE','120');7 Q9 o$ w" e# v) F& R% X
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;% d) }; t# j& l0 W) B6 G% c5 ?) l7 C
0 n% G* ]5 {% G9 J6 [
+ r$ \( ]) h L; W, ]9 _
--
5 w* k: N- a3 O1 u-- Definition of table `question`
" p0 ]( q( i& }8 N7 r8 c--
, c; A% J8 c# n: I# H3 t$ Q* t3 M
& z6 c, Q, Q9 {9 j Z/ _2 jDROP TABLE IF EXISTS `question`;
! V$ M4 U* s, Z5 i1 ^/ i) L2 W8 RCREATE TABLE `question` (( J( T: F7 w6 `
`qu_id` int(11) NOT NULL AUTO_INCREMENT,1 j0 P8 A( u' u
`type_id` int(11) NOT NULL, ^! C, Q6 w4 \& b0 J
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,9 ~1 x& C: h/ N+ N
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,+ R6 i6 R( E6 c a# L3 K, @; t9 f8 ]
`quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL," y* k a) i/ {2 A1 n
`quScore` int(11) NOT NULL,* a: ~+ n, Y/ ^0 ~' R
`quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
) C3 f8 l: E' Q9 s5 T `selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
( E8 D0 e) {2 i5 W2 z PRIMARY KEY (`qu_id`),5 @0 V& Q7 I d5 g
KEY `FKBE5CA00621011593` (`type_id`),. c/ _& N8 {* ~
KEY `FKBE5CA006B04D67C1` (`type_id`),% D, {; m2 @, `6 S6 Y3 {
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),6 q" u$ @# a% b. U
CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
# _/ }6 x! ?7 U3 |- S1 m CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`), V j3 L' X: {
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
. u* g3 `9 J+ V. f3 Q
/ d$ V4 f+ N. I% ?; T" {--. u. I3 F' d: Q4 r
-- Dumping data for table `question`2 j+ J. F1 @# C, M2 A
--; I4 O8 n+ L6 C4 a7 j/ _
# {9 D/ {1 ^+ c/ b/*!40000 ALTER TABLE `question` DISABLE KEYS */;
* {% V( O4 ?" @+ t* T0 U0 oINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES 1 @9 x$ l3 {; M2 t1 B# V8 R3 Q, R
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
4 @7 i% ?7 O( r4 b2 C (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
* T! ?5 V3 N8 S (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),
( m. Z* }" X; E5 m (4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),
2 R9 C; Q% R' k0 v* r1 o; u (5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),
- o6 p7 ~: u8 |" ?9 ] (6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),) e4 i6 d6 k! m' ?
(7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),3 D' M% k: {. @3 J
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
7 o. z @4 B8 R5 e7 u% `8 w (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),2 _7 _- B; h/ i, t/ k
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
# x! L- D7 i' o (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),
8 p8 l9 h( d/ h/ z+ \3 L: g. u6 { (12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),7 |% [) F+ i4 P, P
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),
" S; X, Z- W7 ?4 A7 P: ? (14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');- R" {9 C+ T6 f: J8 d# T* x! d
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
& X- W) _6 c9 d7 V7 M4 O J/ o' A h0 Y; {1 C0 }
6 B& w( `* B9 _/ ^- ?# F; C--5 J: }4 l( u# X8 K# O% r
-- Definition of table `student`
5 z- ~( \% x! G--6 O! O" W% x0 ?
& X- t+ u- g& i6 L! }# B$ ^. I" Q3 k
DROP TABLE IF EXISTS `student`;
" F1 a8 b, P& KCREATE TABLE `student` (% }; R. N5 S: q8 H0 f% w' G7 j
`stu_id` int(11) NOT NULL AUTO_INCREMENT,
: h$ [# {1 f& d6 a$ T& T {) l% u `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
; i: H6 ~/ r. s0 P `stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,. s: ] f l, }$ h. O4 p6 ^" Y* c: o% G. d
`className` varchar(255) COLLATE utf8_unicode_c! U5 A: b6 d- h {$ _
[Msg] Finished - Unsuccessfully |
|
[复制链接]
/1 
|Archiver|手机版|小黑屋|科帮网
( 鲁ICP备19059327号-2 ) 
窥视卡
雷达卡
显身卡
