该用户从未签到
|
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, v; ]8 t+ s& t* y; B7 b6 z. b6 R
--: _5 L. B8 B! t2 M
-- ---------------------------------------' at line 1
, e; v: n! ?% A$ H% D[Err] -- MySQL Administrator dump 1.4
% t( c* b+ P, E6 Z+ N" R$ e--; i+ U% l" I/ y: a0 M q
-- ------------------------------------------------------
. L6 t! p: S L* ^/ n% I. V! d-- Server version 5.5.15: P1 { C7 X5 c& M/ t% @
( b" r% e8 r/ q, B# H; T- t
7 F9 u+ P0 S e
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;3 F$ E( j1 N! A/ k6 \+ v
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
& [" g6 i+ e5 i# S/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
" ~. G) U% p3 u4 W# L/*!40101 SET NAMES utf8 */;
8 M5 I2 h* N& ?1 w' m/ ]! j2 M8 h/ z
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;$ B+ d! \0 p9 f: U
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;+ Y0 U7 d1 g8 N# L) @
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;; Q& u, ^9 |' D! \
! X9 {: d, O! }/ P& O% ?7 [; H- ]& z9 s6 |
--
- P4 j2 j* i( U-- Create schema onlinexam; v$ {3 I# J/ W% s
--
& i, g' ~9 m0 |5 r* T3 {, c) ~+ U$ W0 d% E3 n
CREATE DATABASE IF NOT EXISTS onlinexam;* y# D5 n9 k1 x% B+ F6 r: M( J
USE onlinexam;: y6 v2 U+ E) q1 q
6 E5 {5 T6 W! z2 x" G2 L" d
--
# f$ g+ H4 G1 d7 k" b' g' W% l. u-- Definition of table `admin`0 G6 l7 }( s4 E: z+ z
--
8 N# ]# D' ]- a6 p. n! L6 P
3 y7 U! z; R3 ~3 G% F; u( T) bDROP TABLE IF EXISTS `admin`;
! p( @) Y* v- L0 n/ B0 f& bCREATE TABLE `admin` (% i# T, ^2 O m0 I8 A p' s
`adm_id` int(11) NOT NULL AUTO_INCREMENT,
' K, P1 N# a6 o6 i! Z `admName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,* X5 l1 {8 N; K# a, p$ v
`admPass` varchar(255) COLLATE utf8_unicode_ci NOT NULL," }6 i8 ~. w# F% T* T5 l
PRIMARY KEY (`adm_id`). ^2 _! M' C% }8 A% |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
$ q5 b1 e+ S( O1 `7 y/ F* Y% a k. l. j
--
3 ^; l: g7 Q5 M, R-- Dumping data for table `admin`
$ H4 F1 I+ Y! u9 m O( k--1 A& Z; C o5 F% r
|7 D; M8 S! b
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
0 S' D' t* e' K0 u$ C/ F- [, uINSERT INTO `admin` (`adm_id`,`admName`,`admPass`) VALUES 4 ~# x+ v3 ?3 i& o
(1,'admin','52itstyle');. h5 D0 j( l* u B: W- M
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
- Y. }" J. v) p; V/ g, w/ w$ P
, [7 d& i" h7 l4 V" Y
1 S6 s# c# S; p, J+ c( c--* Q; ~3 A) Q# l3 |! {: |
-- Definition of table `examtype`
# V/ c5 F& T$ I* ]6 J6 s--
$ x& M) F+ q' S9 a+ ^# B7 `+ T$ w* M; k8 e5 A8 H8 l" I1 T
DROP TABLE IF EXISTS `examtype`;# L, d! X1 d- |0 C; i& d# J
CREATE TABLE `examtype` (
- A$ @- j- }: ^( ^# l! j4 A `type_id` int(11) NOT NULL AUTO_INCREMENT,$ Y2 _: h: r2 J2 h# [4 p
`testTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,6 s1 d9 d7 [/ V! L5 z* E2 u" v
`testTime` varchar(255) COLLATE utf8_unicode_ci NOT NULL,+ u3 e* U" a6 Z# h# T6 O
PRIMARY KEY (`type_id`)
0 e* Q+ r# l8 k+ X: [) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;6 \! f9 ^/ U8 H3 m! D/ p; ~
1 V$ g+ v t# C: ^( q5 [4 F
--
6 \; j2 A- H5 J8 N' `1 Q-- Dumping data for table `examtype`- u; D9 @' c4 T) C3 v
--
: Q5 T; y2 p; ^; X0 K+ k2 z+ c3 D1 s% X+ r' f7 a9 m
/*!40000 ALTER TABLE `examtype` DISABLE KEYS */;
& A- d* G, j- C H( t, s' r. r. {INSERT INTO `examtype` (`type_id`,`testTitle`,`testTime`) VALUES / w( b$ ~6 s, o0 [. `! A2 C: [! D' |
(1,'语文','6'),1 ?8 C5 J& Q+ a" P5 `$ s8 Z: b
(2,'PHP','2011-10-26'),7 d0 D; b. y, N
(3,'ORACLE','120');7 o: n+ s" M9 q* N/ E
/*!40000 ALTER TABLE `examtype` ENABLE KEYS */;1 k8 e9 ~" V" Q1 R
# l" S2 R% q$ p( r9 P8 w! i0 H) S$ K L
0 Y- X; r: j. `4 I( q# \& T--! s, W! ~+ o( x6 {+ @4 [
-- Definition of table `question`7 `! E1 w, Y1 O! d F: x5 H
--# f5 F, p6 b" w8 |
+ y$ Y o1 g6 z$ ^( w$ z# ZDROP TABLE IF EXISTS `question`;
4 X: h/ j. j" I% K8 Y+ m# _CREATE TABLE `question` (- ]& H$ X+ Y( u, u
`qu_id` int(11) NOT NULL AUTO_INCREMENT,2 N$ g B+ a% C7 x( w
`type_id` int(11) NOT NULL,1 G0 a6 j8 u* L# ~ s
`quTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,/ r+ K: d! }5 A
`quHard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
A- k1 g0 @' F$ W5 |1 v6 ?0 i8 [& x `quType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
7 e+ X) x" U1 x5 H `quScore` int(11) NOT NULL,
" t: a9 N6 a+ ]8 T `quAnswer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,0 s' D# S5 a8 U: l
`selectOption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
J8 b9 z8 B9 I4 ?5 ?' M; `/ n. m9 L PRIMARY KEY (`qu_id`),
/ S6 c4 r4 `( c9 Y5 j- s1 o& s' T KEY `FKBE5CA00621011593` (`type_id`),, |- s6 h o8 K
KEY `FKBE5CA006B04D67C1` (`type_id`)," b# d* q3 o5 E0 ^. f) |
CONSTRAINT `FKBE5CA00621011593` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
: L- {" k8 a2 Q CONSTRAINT `FKBE5CA006B04D67C1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`),
% i V7 F- O; r* l, o- W5 | CONSTRAINT `question_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `examtype` (`type_id`)
6 W+ r4 ~: P2 V- I+ M) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
, d, H) X- _2 D3 V! n e
6 V( S0 B, e2 y( w2 {3 J) M$ C O: s--) s& n( D. i' |1 S9 p% m! G/ c5 f
-- Dumping data for table `question`1 K) Q1 c3 l1 N% u: w& r8 u
--
" Q, {% `2 R' s9 ~- w4 ? N
: D4 w3 \) w) z, T; C/*!40000 ALTER TABLE `question` DISABLE KEYS */;
7 c) J. @/ o; r( XINSERT INTO `question` (`qu_id`,`type_id`,`quTitle`,`quHard`,`quType`,`quScore`,`quAnswer`,`selectOption`) VALUES ( R$ {! U C, i0 y3 P& O& ]
(1,1,'汉的拼音','简单','单选题',1,'han:ham:hak','1'),
, E8 b& N; `5 g. p (2,1,'民的拼音','简单','单选题',1,'min:ming:mng','1'),
! _' P1 k$ q3 E- c l4 M( u0 _ (3,1,'王的拼音','简单','单选题',1,'wang:ang:wan','1'),! M3 Y( k2 m. v/ V7 i# s
(4,1,'哈的拼音','简单','单选题',1,'ha:hu:hua','1'),* A( Q. h) z) c) |5 O
(5,1,'维的拼音','简单','单选题',1,'wei:ei:wi','1'),2 \* k9 F+ N7 {. d
(6,1,'孟的拼音','简单','单选题',1,'meng:men:neng','1'),
- O+ D9 D0 R: h: X( V9 C& k (7,1,'无的拼音','简单','单选题',1,'wu:w:u','1'),6 `( Q5 D5 ?2 v$ E7 `" G9 D
(8,1,'欧的拼音','简单','单选题',1,'ou w:you','1'),
+ [! {0 \! _5 r (9,1,'天的拼音','简单','单选题',1,'tian:tan:tyan','1'),4 F6 m# X* H: ^0 B" D$ x) A' I: T
(10,1,'化的拼音','简单','单选题',1,'hua:ham:hak','1'),
2 x# B8 ?" |/ s* i0 o (11,1,'就的拼音','简单','单选题',1,'jiu:jou:jyou','1'),; e0 i& `2 u% K
(12,1,'年的拼音','简单','单选题',1,'nian:yan:nan','1'),# V" o) f# r6 x3 J2 t/ L f0 _
(13,1,'欻的拼音','简单','单选题',1,'chua:chuan:yan','1'),5 ^& ^3 E9 M2 N! n7 ^* G, B7 o4 q
(14,3,'SELECT * FROM emp是什么意思','简单','单选题',1,'不知道','不知道:查询全部员工');) f* }( L+ s( E7 `
/*!40000 ALTER TABLE `question` ENABLE KEYS */;# f" u- W6 E" o$ m4 ?7 ~* V
- n. f6 l, u1 \' {3 D5 K
9 ?! R+ F" |% S% X2 \--3 X* |* n- A1 Y" m, Q9 i; C
-- Definition of table `student`1 l" U' t! c: s4 f8 H: q
--2 }$ _1 w0 d) ]1 d
9 I1 \# l( X1 v7 [
DROP TABLE IF EXISTS `student`;1 |! {, x- C: \7 c& B7 b4 _5 P
CREATE TABLE `student` (
# K# L" q# l& D8 N# N* |/ t `stu_id` int(11) NOT NULL AUTO_INCREMENT,
! d' y% L+ v' p5 S! g$ e `stuNumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL,0 Q2 A: q, ~/ c# u$ K6 ~/ I/ \
`stuName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,: A2 ~5 @1 O4 E
`className` varchar(255) COLLATE utf8_unicode_c# N4 f: Q, @+ ?: N. O( `+ } r
[Msg] Finished - Unsuccessfully |
|